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 |