Page tree
Skip to end of metadata
Go to start of metadata

 

This table contains the statistics of short-running queries, which have been aggregated into one record and written to the repository at the end of each statistics aggregation interval.

Column NameData TypeDefaultDescription
INSTANCE_IDINT UNSIGNEDNO DEFAULT

NOT NULL

NOT DROPPABLE SERIALIZED
Unique ID that identifies the instance from which the metric originated.
TENANT_IDINT UNSIGNEDNO DEFAULT

NOT NULL

NOT DROPPABLE SERIALIZED
Unique ID that identifies the tenant (if any) from which the metric originated. Value is 0 (zero) if there is no tenant.
COMPONENT_IDINT UNSIGNEDDEFAULT NULL SERIALIZEDUnique ID for the component, 1 through 16.
PROCESS_IDINTDEFAULT NULL SERIALIZEDUnique ID from the operating system, which identifies the process associated with the metric.
THREAD_IDINT UNSIGNEDDEFAULT NULL SERIALIZEDThread ID for the process.
NODE_IDINT UNSIGNEDDEFAULT NULL SERIALIZEDLogical node ID from the foundation layer, which is a numeric identifier for the current node.
PNID_IDINT UNSIGNEDDEFAULT NULL SERIALIZEDPhysical node ID from the foundation layer.
HOST_IDINT UNSIGNEDNO DEFAULT

NOT NULL

NOT DROPPABLE SERIALIZED
Host ID from the operating system, which is a numeric identifier for the current host.
IP_ADDRESS_IDCHAR(32)

CHARACTER SET ISO88591

COLLATE DEFAULT
DEFAULT NULL SERIALIZEDInternet Protocol (IP) address of the node from which the data for this table originated.
SEQUENCE_NUMBERINT UNSIGNEDDEFAULT NULL SERIALIZEDSequence ID generated by the data producer.
PROCESS_NAMECHAR(32)

CHARACTER SET ISO88591

COLLATE DEFAULT
DEFAULT NULL SERIALIZEDLogical process name of the DCS server that is handling the query and that reported the statistics.
SESSION_IDCHAR(108)

CHARACTER SET ISO88591

COLLATE DEFAULT
NO DEFAULT

NOT NULL

NOT DROPPABLE SERIALIZED
Primary Key
Unique session ID generated by the DCS server when the connection was established.
SESSION_START_UTC_TSTIMESTAMP(6)NO DEFAULT NOT NULL NOT DROPPABLEPrimary Key
Timestamp, in Coordinated Universal Time, indicating when the session started and when statistics started to be recorded in the repository.
AGGREGATION_LAST_UPDATE_UTC_TSTIMESTAMP(6)DEFAULT NULLTimestamp, in Coordinated Universal Time, indicating when the aggregated statistics were last updated.
AGGREGATION_LAST_ELAPSED_TIMELARGEINTDEFAULT NULL SERIALIZEDAggregation interval, in seconds, that was set. The default interval is 60 seconds.
USER_IDLARGEINTDEFAULT NULL SERIALIZEDInternal representation of the authorization ID, which is a 32-bit number that the database generates and uses for efficient access and storage.
USER_NAMECHAR(256 BYTES)

CHARACTER SET UTF8

COLLATE DEFAULT
DEFAULT NULL SERIALIZEDName of the user connected to the instance.
ROLE_NAMECHAR(256 BYTES)

CHARACTER SET UTF8

COLLATE DEFAULT
DEFAULT NULL SERIALIZEDName of the role that was granted to the user.
CLIENT_NAMEVARCHAR(256 CHARS)

CHARACTER SET UTF8

COLLATE DEFAULT
DEFAULT NULL SERIALIZEDName of the client workstation.
CLIENT_USER_NAMECHAR(256 BYTES)

CHARACTER SET UTF8

COLLATE DEFAULT
DEFAULT NULL SERIALIZEDName of the user who originated the session by logging in to a client workstation. If the name is unavailable from the ODBC or JDBC driver, this field is NULL.
APPLICATION_NAMECHAR(130)

CHARACTER SET ISO88591

COLLATE DEFAULT
DEFAULT NULL SERIALIZEDName of the client application connected to the database.
TOTAL_EST_ROWS_ACCESSEDLARGEINTDEFAULT NULL SERIALIZEDAggregated estimates of the total number of rows accessed in each table by all the scan, insert, update, and delete operators in the query plan.
TOTAL_EST_ROWS_USEDLARGEINTDEFAULT NULL SERIALIZEDAggregated estimates of the total number of rows retrieved and/or actually used by the statement, which is the number of rows that were returned by the Executor in Disk (EID) process after evaluating non-key predicates.
TOTAL_ROWS_RETRIEVEDLARGEINTDEFAULT NULL SERIALIZEDAggregated total number of rows retrieved and/or actually used by the statement.
TOTAL_NUM_ROWS_IUDLARGEINTDEFAULT NULL SERIALIZEDAggregated total number of rows accessed in each table by all the scan, insert, update, and delete operators in the query plan.
TOTAL_SELECTSLARGEINTDEFAULT NULL SERIALIZEDTotal number of SELECT statements.
TOTAL_INSERTSLARGEINTDEFAULT NULL SERIALIZEDTotal number of INSERT statements.
TOTAL_UPDATESLARGEINTDEFAULT NULLTotal number of UPDATE statements.
TOTAL_DELETESLARGEINTDEFAULT NULL SERIALIZEDTotal number of DELETE statements.
TOTAL_DDL_STMTSLARGEINTDEFAULT NULL SERIALIZEDTotal number of DDL statements.
TOTAL_UTIL_STMTSLARGEINTDEFAULT NULL SERIALIZEDTotal number of utility statements like MAINTAIN, REORG and so on.
TOTAL_CATALOG_STMTSLARGEINTDEFAULT NULL SERIALIZEDTotal number of catalog APIs invoked by ODBC and JDBC application.
TOTAL_OTHER_STMTSLARGEINTDEFAULT NULL SERIALIZEDTotal number of other statements like CALL stmts.
TOTAL_INSERT_ERRORSLARGEINTDEFAULT NULL SERIALIZEDTotal number of errors during execution of INSERT statements.
TOTAL_DELETE_ERRORSLARGEINTDEFAULT NULL SERIALIZEDTotal number of errors during execution of DELETE statements.
TOTAL_UPDATE_ERRORSLARGEINTDEFAULT NULL SERIALIZEDTotal number of errors during execution of UPDATE statements.
TOTAL_SELECT_ERRORSLARGEINTDEFAULT NULL SERIALIZEDTotal number of errors during execution of SELECT statements.
TOTAL_DDL_ERRORSLARGEINTDEFAULT NULL SERIALIZEDTotal number of errors during execution of DDL statements.
TOTAL_UTIL_ERRORSLARGEINTDEFAULT NULL SERIALIZEDTotal number of errors during execution of utility statements.
TOTAL_CATALOG_ERRORSLARGEINTDEFAULT NULL SERIALIZEDTotal number of errors reported during invocation of catlog APIs.
TOTAL_OTHER_ERRORSLARGEINTDEFAULT NULL SERIALIZEDTotal number of errors during execution of other statements.
DELTA_ESTIMATED_ROWS_ACCESSEDLARGEINTDEFAULT NULL SERIALIZEDNumber of estimated rows accessed between two intervals.
DELTA_ESTIMATED_ROWS_USEDLARGEINTDEFAULT NULL SERIALIZEDNumber of estimated rows retrieved and or actually used between two intervals.
DELTA_ROWS_ACCESSEDLARGEINTDEFAULT NULL SERIALIZEDNumber of rows accessed between two intervals.
DELTA_ROWS_RETRIEVEDLARGEINTDEFAULT NULL SERIALIZEDNumber of rows retrieved between two intervals.
DELTA_NUM_ROWS_UIDLARGEINTDEFAULT NULL SERIALIZEDTotal number of rows accessed for insert, update, and delete operators between two intervals.
DELTA_SELECTSLARGEINTDEFAULT NULL SERIALIZEDTotal number of SELECT statements between two intervals.
DELTA_INSERTSLARGEINTDEFAULT NULL SERIALIZEDTotal number of INSERT statements between two intervals.
DELTA_UPDATESLARGEINTDEFAULT NULL SERIALIZEDTotal number of UPDATE statements between two intervals.
DELTA_DELETESLARGEINTDEFAULT NULL SERIALIZEDTotal number of DELETE statements between two intervals.
DELTA_DDL_STMTSLARGEINTDEFAULT NULL SERIALIZEDTotal number of DDL statements between two intervals.
DELTA_UTIL_STMTSLARGEINTDEFAULT NULL SERIALIZEDTotal number of utility statements between two intervals.
DELTA_CATALOG_STMTSLARGEINTDEFAULT NULL SERIALIZEDTotal number of catalog APIs invoked between two intervals.
DELTA_OTHER_STMTSLARGEINTDEFAULT NULL SERIALIZEDTotal number of other SQL statements between two intervals.
DELTA_INSERT_ERRORSLARGEINTDEFAULT NULL SERIALIZEDTotal number of INSERT statement errors between two intervals.
DELTA_DELETE_ERRORSLARGEINTDEFAULT NULL SERIALIZEDTotal number of DELETE statement errors between two intervals.
DELTA_UPDATE_ERRORSLARGEINTDEFAULT NULL SERIALIZEDTotal number of UPDATE statement errors between two intervals.
DELTA_SELECT_ERRORSLARGEINTDEFAULT NULL SERIALIZEDTotal number of SELECT statement errors between two intervals.
DELTA_DDL_ERRORSLARGEINTDEFAULT NULL SERIALIZEDTotal number of DDL statement errors between two intervals.
DELTA_UTIL_ERRORSLARGEINTDEFAULT NULL SERIALIZEDTotal number of utitlity statement errors between two intervals.
DELTA_CATALOG_ERRORSLARGEINTDEFAULT NULL SERIALIZEDTotal number of catalog API errors between two intervals.
DELTA_OTHER_ERRORSLARGEINTDEFAULT NULL SERIALIZEDTotal number of error for other statements between two intervals.

Return to the Trafodion Manageability page.

  • No labels