Getting Started : 11. Command Summary
 
Share this page                  
Command Summary
Command Summary
Commands and utilities for performing operations in Vector are listed in the following table.
Note:  Lowercase = line-based command; uppercase = SQL statement
Task
Tools
Start or stop Vector
ingstart, ingstop
Create or remove databases
createdb, destroydb
Create tables
CREATE TABLE
Load or unload data
copydb, unloaddb, vwload, COPY VWLOAD
Copy, back up, or recover data
ckpdb, clonedb, copydb, movedb, rollforwarddb, unloaddb, CSVEXPORT
Query
sql, isql
Maintain or tune databases
optimizedb, statdump, CREATE STATISTICS
Create or manage locations
CREATE LOCATION, accessdb, extenddb, relocatedb, unextenddb
Change characteristics of an existing database
alterdb
Configure installation
ingprenv, ingsetenv, ingunset,
iigetres, iisetres, iiinitres, iiremres, iivalres, iigenres
Manage security alarms
CREATE SECURITY_ALARM, DROP SECURITY_ALARM, HELP SECURITY_ALARM
Manage security auditing
ALTER SECURITY_AUDIT, DISABLE SECURITY_AUDIT, ENABLE SECURITY_AUDIT, REGISTER TABLE, REMOVE TABLE
Manage database procedures
CREATE PROCEDURE, DROP PROCEDURE, EXECUTE PROCEDURE, GRANT...ON PROCEDURE, HELP PERMIT ON PROCEDURE, HELP PROCEDURE, REVOKE
Tidy tables and indexes for system catalogs and user tables
sysmod, COMBINE, CONDENSE_LOG, REWRITE
Change current vectorwise.log
VWLOG-ROTATE, VWLOG_RELOAD
Manage or monitor
infodb, ingstatus, vwinfo, iimonitor, iinamu, ipm, GETCONF, SETCONF
What Is Next?
Refer to the other guides in the documentation set to learn about:
Configuring Vector
Performance tips
Updating data
Disaster recovery
Backing up and restoring the database
Monitoring the database
Profiling a query
Managing cluster resources
Authorizing user access and other security related tasks