17.05 - User Command: User Command Columns - Teradata Database

Teradata Vantageā„¢ - Resource Usage Macros and Tables

Advanced SQL Engine
Teradata Database
June 2020
User Guide
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