Collection Services data files: QAPMSMSYS
This database file contains summarized metrics from system data (*SYSLVL collection category) that may be used in support of system monitoring.
These metrics are calculated from more discrete data found in the QAPMSYSTEM file. One record is written per database interval.
| Field Name | Description | Attribute |
|---|---|---|
| INTNUM | Interval number. The nth sample database interval based on the start time specified in the Create Performance Data (CRTPFRDTA) command. | PD (5,0) |
| DATETIME | Interval date and time. The date and time of the sample interval. | Timestamp |
| INTSEC | Elapsed interval seconds. The number of seconds since the last sample interval. | PD (7,0) |
| SMSCPUCPU | Configured CPU percent unscaled. The amount of unscaled system CPU consumed relative to the configured CPU time (processor units) available to the partition during the interval. | B (9,2) |
| SMSCPUUPU | Uncapped CPU percent unscaled. The amount of unscaled system CPU consumed relative to the maximum uncapped CPU time the partition could consume based on the smaller of the virtual processors assigned to the partition and the capacity of the shared virtual pool. | B (9,2) |
| SMSCPUVPU | Virtual CPU percent unscaled. The amount of unscaled system CPU consumed relative to the number of virtual processors allocated to the partition during the interval. | B (9,2) |
| SMSCPUCPS | Configured CPU percent scaled. The amount of scaled system CPU consumed relative to the configured CPU time (processor units) available to the partition during the interval. | B (9,2) |
| SMSCPUUPS | Uncapped CPU percent scaled. The amount of scaled system CPU consumed relative to the maximum uncapped CPU time the partition could consume based on the smaller of the virtual processors assigned to the partition and the capacity of the shared virtual pool. | B (9,2) |
| SMSCPUVPS | Virtual CPU percent scaled. The amount of scaled system CPU consumed relative to the number of virtual processors allocated to the partition during the interval. | B (9,2) |
| SMSPRCSPDP | Processor speed percent. Processor speed, relative to nominal,
shown as a percent (based on the ratio of scaled CPU consumed to unscaled
CPU consumed). Note: This value may not be accurate at low utilizations.
|
B (9,2) |
| SMSVSPP | Virtual shared pool CPU percent. The amount of CPU consumed in the virtual shared pool by all partitions using the pool relative to the CPU available within the pool. | B (9,2) |
| SMSPSPP | Physical shared pool CPU percent. The amount of CPU consumed in the physical shared pool by all partitions using the pool relative to the CPU available within the pool. | B (9,2) |
| SMSCTSTGU | Temporary storage used. The total amount of temporary storage (megabytes) in use within the system. This includes both system and user temporary storage. | B (18,0) |
| SMSCTSTGP | Temporary storage percent. The percent of the system ASP that is in use for temporary storage. | B (9,2) |
| SMSCPUQPU | SQL CPU percent unscaled. The amount of unscaled system CPU consumed performing work done on behalf of SQL operations relative to the configured CPU time (processor units) available to the partition during the interval. | B (9,2) |
| SMSB4F01 | Reserved. | B (9,0) |
| SMSB4F01 | Reserved. | B (9,0) |
| SMSB8F01 | Reserved. | B (18,0) |
| SMSB8F01 | Reserved. | B (18,0) |
