These columns provide statistics on current logging characteristics.
Column Name | Mode | Description | Data Type |
---|---|---|---|
GmtTime | n/a | Greenwich Mean Time is not affected by the Daylight Savings Time adjustments that occur twice a year. | FLOAT |
PdiskGlobalId | n/a | Identifies the pdisk in the system. Each pdisk in the system has a global ID which uniquely identifies the pdisk in the system. If a pdisk is connected to the nodes in a clique, all the nodes in that clique see the same pdisk global ID associated with that pdisk. In Summary Mode, the pdisk global ID is -1. |
INTEGER |
PdiskType | n/a | Type of pdisk. The pdisk can be one of the following:
|
CHAR(4) |
PdiskDeviceId | n/a | Identifies the local pdisk device.
In Summary Mode, the pdisk device ID is 0xFFFFFFFF. |
BYTE(4) |
NodeType | n/a | Type of node, representing the per node system family type. | CHAR(8) |
Secs | n/a | Actual number of seconds in the log period represented by this row. Normally the same as NominalSecs, but can be different in three cases:
Useful for normalizing the count statistics contained in this row, for example, to a per-second measurement. |
SMALLINT |
CentiSecs | n/a | Number of centiseconds in the logging period. This field is useful when performing data calculations with small elapsed times where the difference between centisecond-based data and whole seconds results in a percentage error. | INTEGER |
NominalSecs | n/a | Specified or nominal number of seconds in the logging period. | SMALLINT |
SummaryFlag | n/a | Summarization status of this row. If the value is 'N,' the row is a non-summary row. If the value is 'S,' the row is a summary row. | CHAR(1) |
Active | max | Controls whether or not the rows will be logged to the resource usage tables if Active Row Filter Mode is enabled. If Active is set to a non-zero value, the row contains data columns. If Active is set to a zero value, none of the data columns in the row have been updated during the logging period. For example, if you enable Active Row Filter Mode, the rows that have a zero Active column value will not be logged to the resource usage tables. |
FLOAT |
TheTimestamp | n/a | Number of seconds since midnight, January 1, 1970. This column is useful for aligning data with the DBQL log. |
BIGINT |
PM_CPU_COD | n/a | Platform Metering CPU COD value in one tenths of a percent.For example, a value of 500 represents a PM CPU COD value of 50.0%. The value is set to 1000 if the PM CPU COD is disabled. |
SMALLINT |
WM_CPU_COD | n/a | Workload Management CPU COD value in one tenths of a percent. For example, a value of 500 represents a WM CPU COD value of 50.0%. The value is set to 1000 if the WM CPU COD is disabled. WM CPU COD is not supported on SLES 10. Its value is set to 1000 on SLES 10.
|
SMALLINT |
PM_IO_COD | n/a | Platform Metering I/O COD value in whole percent. For example, a value of 50 represents a PM I/O COD value of 50.0%. The value is set to 100 if the PM I/O COD is disabled. |
SMALLINT |
WM_IO_COD | n/a | Workload Management I/O COD value in whole percent. For example, a value of 50 represents a WM I/O COD value of 50.0%. The value is set to 100 if the WM I/O COD is disabled. WM I/O COD is not supported on SLES 10. Its value is set to 100 on SLES 10.
|
SMALLINT |