These columns identify the type of commands given to Teradata Database by the user. Three levels of granularity are given:
- Transactions. These columns consist of one or more requests.
- Requests. These consist of one or more statements.
- Statements. These columns are subdivided into the various statement types.
| Column Name | Mode | Description | Data Type |
|---|---|---|---|
| CmdAlterStmts | count | Number of alter, modify, or drop statement commands. | FLOAT |
| CmdArchUtilityStmts | count | Number of archival utility commands (for example, restore, archive and recovery). | FLOAT |
| CmdCreateStmts | count | Number of create or replace statement commands. | FLOAT |
| CmdDeleteStmts | count | Number of delete commands. | FLOAT |
| CmdGrantStmts | count | Number of grant or revoke commands. | FLOAT |
| CmdInsertStmts | count | Number of insert commands. | FLOAT |
| CmdLoadUtilityStmts | count | Number of FastLoad and MultiLoad utility commands. (Tpump commands cannot be distinguished, and are therefore counted by the INSERT, UPDATE and DELETE statements). | FLOAT |
| CmdOtherStmts | count | Number of other commands. | FLOAT |
| CmdRequests | count | Number of request commands. | FLOAT |
| CmdSelectStmts | count | Number of select commands. | FLOAT |
| CmdTransactions | count | Number of transaction commands. | FLOAT |
| CmdUpdateStmts | count | Number of update commands. | FLOAT |