Commands are available to trace such things as disk file access, locks, user interface-to-DBMS Server communications, query plans of the Query Optimizer and various types of memory usage. For more information on tracing, see the Database Administrator Guide.

DBMS Server tracing is generally enabled by some form of the SET command, although some forms of tracing make use of Actian X environment variables. SET commands used specifically for debugging and troubleshooting are discussed in this document. General SET commands are documented in the SQL Reference Guide.