User Command: User Command Columns - Analytics Database - Teradata Vantage

Resource Usage Macros and Tables

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-10-30
dita:mapPath
efj1628112349534.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
wqp1472240716284
lifecycle
latest
Product Category
Teradata Vantageā„¢
These columns identify the type of commands given to Vantage 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