Database: td_metric_svc
If you need detailed statistics for each host channel and TCP/IP network used to communicate with the system, use this view to:
- Identify patterns in inbound and outbound traffic with the system.
- Quantify channel or network traffic volume.
- Verify that all host channels are participating equally in communication between a host and the system.
| View Column | Data Type | Format | Comment |
|---|---|---|---|
| Location | VARCHAR(2048) UNICODE CASESPECIFIC | X(2048) | File path in object storage for metric data objects. |
| path_component_id | VARCHAR(8000) UNICODE CASESPECIFIC | X(8000) | Operational group (primary cluster or compute cluster) ID. |
| path_collecttimestamp | VARCHAR(8000) UNICODE CASESPECIFIC | X(8000) | Timestamp, in EPOCH timestamp format, this metric data was collected from your database and written to object storage. |
| path_year | VARCHAR(8000) UNICODE CASESPECIFIC | X(8000) | The year in which the data was logged. |
| path_month | VARCHAR(8000) UNICODE CASESPECIFIC | X(8000) | The month in which the data was recorded in the table. |
| path_day | VARCHAR(8000) UNICODE CASESPECIFIC | X(8000) | The day on which the data was recorded in the table. |
| path_hour | VARCHAR(8000) UNICODE CASESPECIFIC | X(8000) | The hour at which the data was recorded in the table. |
| path_minute | VARCHAR(8000) UNICODE CASESPECIFIC | X(8000) | The minute at which the data was recorded in the table. |
| path_ver | VARCHAR(8000) UNICODE CASESPECIFIC | X(8000) | The version of Vantage software that was running on the operational group. |
| TheDate | DATE NOT NULL | YYYY/MM/DD | Local Date of the log entry. |
| NodeID | INTEGER NOT NULL | ZZZ9-9999 | Numeric value that uniquely identifies a node (cloud compute instance) within a compute cluster. For example, '10001','10002'. |
| TheTime | FLOAT NOT NULL | 99:99:99.99 | Nominal local time of the log entry. |
| GmtTime | FLOAT NOT NULL | 99:99:99.99 | Nominal GMT time of the log entry. Greenwich Mean Time is not affected by the Daylight Saving Time adjustments that occur twice a year. |
| CabinetID Not applicable. Do not use.
|
Not applicable. | ||
| ModuleID Not applicable. Do not use.
|
Not applicable. | ||
| NodeType | CHAR(8) LATIN NOT CASESPECIFIC NOT NULL | X(8) | Indicates the node (cloud compute instance) family. For example, '67_R5'. |
| TheTimestamp | BIGINT NOT NULL | -(20)9 | Number of seconds since midnight, January 1, 1970. |
| CentiSecs | INTEGER NOT NULL | -(11)9 | Actual number of centiseconds in the logging period. |
| Secs | SMALLINT NOT NULL | -(6)9 | Actual number of seconds in the logging period. |
| NominalSecs | SMALLINT NOT NULL | -(6)9 | Nominal number of seconds in the logging period. |
| SummaryFlag | CHAR(1) LATIN NOT CASESPECIFIC NOT NULL | X(1) | Summarization status of this row. Possible values are N if the row is a non-summary row, and S if the row is a summary row. |
| ReservedS0 | CHAR(3) LATIN NOT CASESPECIFIC NOT NULL | X(3) | Reserved for future use. |
| PM_COD_CPU | SMALLINT NOT NULL | -(6)9 | Platform Metering CPU COD value in one tenths of a percent. For example, a value of 500 represents a COD value of 50.0%. |
| WM_COD_CPU | SMALLINT NOT NULL | -(6)9 | Workload Management CPU COD value in one tenths of a percent. For example, a value of 500 represents a COD value of 50.0%. |
| IPaddr0 | BIGINT NOT NULL | -(20)9 | Bytes 0-7 of the 16-byte IP address. |
| IPaddr1 | BIGINT NOT NULL | -(20)9 | Bytes 8-15 of the 16-byte IP address. |
| HstType | CHAR(8) LATIN NOT CASESPECIFIC NOT NULL | X(8) | Type of host connection:
|
| vprid | INTEGER NOT NULL | -11(9) | For NETWORK HstType, it is the Gateway vproc ID. |
| ReservedS1 | CHAR(4) LATIN NOT CASESPECIFIC NOT NULL | X(4) | Reserved for future use. |
| hstid | BIGINT NOT NULL | -(20)9 | IBMECS: RRRRRAAAUUUNNN, RRRRR=link, AAA=channel unit
addr, UUU=logical control unit, NNN=logical channel. IBMNET: host group ID. NETWORK and IBMMUX: BBMMPPHHH, BB=bus, MM=module/chassis, PP=port, HHH=host group ID. |
| HostReadKB | FLOAT NOT NULL | -(20)9 | KB transferred in from the host. |
| HostWriteKB | FLOAT NOT NULL | -(20)9 | KB transferred out to the host. |
| Active | FLOAT NOT NULL | -(20)9 | Controls whether the rows are logged to the resource usage tables if Active Row Filter Mode is enabled. |
| HostBlockReads | FLOAT NOT NULL | -(20)9 | Number of message blocks (one or more messages sent in one physical group) received from all clients. |
| HostBlockWrites | FLOAT NOT NULL | -(20)9 | Number of message blocks (that is, one or more messages sent in one physical group) sent to all hosts. |
| HostMessageReads | FLOAT NOT NULL | -(20)9 | Number of messages read in from the host. |
| HostMessageWrites | FLOAT NOT NULL | -(20)9 | Number of messages written out to the host. |
| HostReadFails | FLOAT NOT NULL | -(20)9 | Number of failures transmitting from the host. |
| HostWriteFails | FLOAT NOT NULL | -(20)9 | Number of failures transmitting to the host. |
| CmdTransactions | FLOAT NOT NULL | -(20)9 | Number of transaction commands. |
| CmdRequests | FLOAT NOT NULL | -(20)9 | Number of request commands. |
| CmdAlterStmts | FLOAT NOT NULL | -(20)9 | Number of alter, modify, or drop statement commands. |
| CmdCreateStmts | FLOAT NOT NULL | -(20)9 | Number of create or replace statement commands. |
| CmdDeleteStmts | FLOAT NOT NULL | -(20)9 | Number of delete commands. |
| CmdGrantStmts | FLOAT NOT NULL | -(20)9 | Number of grant or revoke commands. |
| CmdInsertStmts | FLOAT NOT NULL | -(20)9 | Number of insert commands. |
| CmdSelectStmts | FLOAT NOT NULL | -(20)9 | Number of select commands. |
| CmdUpdateStmts | FLOAT NOT NULL | -(20)9 | Number of update commands. |
| CmdArchUtilityStmts | FLOAT NOT NULL | -(20)9 | Number of archival utility commands (for example, restore, archive and recovery). |
| CmdLoadUtilityStmts | FLOAT NOT NULL | -(20)9 | Number of FastLoad and MultiLoad utility commands. (Tpump commands cannot be distinguished, and are therefore counted by the INSERT, UPDATE and DELETE statements). |
| CmdOtherStmts | FLOAT NOT NULL | -(20)9 | Number of other commands. |
| CmdStmtSuccesses | FLOAT NOT NULL | -(20)9 | Number of statements that departed normally. |
| CmdStmtFailures | FLOAT NOT NULL | -(20)9 | Number of statements that departed normally. |
| CmdStmtErrors | FLOAT NOT NULL | -(20)9 | Number of statements that departed in error. |