Quick Start for Windows > Quick Start Guide > A. Tools Quick Reference
Was this helpful?
Tools Quick Reference
The following table lists tools that are used frequently to perform operations in Actian X. Many of these operations can also be performed using the Visual Tools on Windows.
This table uses the following conventions:
Lowercase = Line-based command
Lowercase bold = Command that starts a forms-based utility
Uppercase = SQL statement
For command syntax and examples, see the Command Reference Guide.
 
Task
Tools
Also See
Start or stop Actian X
ingstart, ingstop
Installation Guide
Create or destroy databases
createdb, destroydb
Database Administrator Guide
Create tables
CREATE TABLE
SQL Reference Guide
Load or unload data
copydb, unloaddb, vwload, COPY VWLOAD
Database Administrator Guide
Back up or recover data
ckpdb, copydb, rollforwarddb, unloaddb, relocatedb, auditdb, CSVEXPORT
Database Administrator Guide
Query
isql, sql, vdba
SQL Reference Guide
Maintain or tune databases
MODIFY, usermod, sysmod, optimizedb, alterdb, statdump, CREATE STATISTICS
Database Administrator Guide
Configure installation
cbf, netutil, ingprenv, ingsetenv, ingunset, iigetres, iisetres, iiinitres
System Administrator Guide
Manage or monitor
ipm, iimonitor, lockstat, logstat, iinamu, cacheutil, verifydb, infodb, vwinfo, SETCONF
Interactive Performance Monitor Tools User Guide
System Administrator Guide
Authorize user access
accessdb
GRANT, REVOKE
Security Guide
SQL Reference Guide
 
Last modified date: 12/14/2023