3. Vector Concepts : Command Summary
 
Share this page                  
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
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