Category: Query
Database: DBC
| View Column | Data Type | Format | Description |
|---|---|---|---|
| ProcID | DECIMAL(5,0) NOT NULL | -(5)9 | The process ID of the dispatcher. |
| CollectTimeStamp | TIMESTAMP(6) NOT NULL | YYYY-MM-DDBHH:MI:SS.S(6) | (Prime Key) Time and date when the TDWM summary cache was written. |
| WDID | INTEGER NOT NULL | --,---,---,--9 | The workload definition under which the query was classified. |
| OpEnvID | INTEGER | --,---,---,--9 | The ID of the operational environment currently activated by TDWM. |
| SysConID | INTEGER | --,---,---,--9 | The ID of the system condition currently activated by TDWM. |
| StartColTime | TIMESTAMP(6) NOT NULL | YYYY-MM-DDBHH:MI:SS.S(6) | Indicates the time at the start of the summary interval. |
| Arrivals | INTEGER NOT NULL | --,---,---,--9 | Indicates how many queries were classified in the summary interval for this workload definition. |
| ActiveCount | INTEGER NOT NULL | --,---,---,--9 | Number of queries that are active in the WD in the collection period. |
| Completions | INTEGER NOT NULL | --,---,---,--9 | Number of queries that completed in this WD in this collection period. |
| MinRespTime | FLOAT NOT NULL | ZZZZZZ.99 | The fastest response time in centiseconds of all queries completed in the summary interval for the workload definition. |
| MaxRespTime | FLOAT NOT NULL | ZZZZZZ.99 | The slowest response time in centiseconds of all queries completed in the summary interval for the workload definition. |
| AvgRespTime | FLOAT NOT NULL | ZZZZZZ.99 | The average response time in centiseconds for all queries completed in the summary interval for the workload definition. |
| MinCPUTime | FLOAT NOT NULL | Z,ZZZ,ZZZ,ZZ9.99 | The least CPU time in seconds (with .001 resolution) of all queries completed in the summary interval for the workload definition. |
| MaxCPUTime | FLOAT NOT NULL | Z,ZZZ,ZZZ,ZZ9.99 | The most CPU time in seconds (with .001 resolution) of all queries completed in the summary interval for the workload definition. |
| AvgCPUTime | FLOAT NOT NULL | Z,ZZZ,ZZZ,ZZ9.99 | The average CPU time in seconds (with .001 resolution) for all queries completed in the summary interval for the workload definition. |
| DelayedCount | INTEGER NOT NULL | --,---,---,--9 | Indicates number of queries that were completed in the summary interval for the workload definition were. |
| AvgDelayTime | FLOAT NOT NULL | ----,---,---,---,--9 | The average delay time in centiseconds for all queries completed in the summary interval for the workload definition. |
| ExceptionAbCount | INTEGER NOT NULL | --,---,---,--9 | Number of queries that were aborted due to an exception action for this workload definition during this interval. |
| ExceptionMvCount | INTEGER NOT NULL | --,---,---,--9 | Number of queries that moved to another workload definition due to an exception action for this workload definition during this interval. |
| ExceptionCoCount | INTEGER NOT NULL | --,---,---,--9 | Number of queries that encountered an exception but continued in this workload definition during this interval. |
| ExceptionCount | INTEGER | -(10)9 | Number of queries with exceptions in this workload definition in this collection period. |
| MetSLGCount | INTEGER NOT NULL | --,---,---,--9 | Number of queries completed in the summary interval for the workload definition met their SLG objectives. |
| AbortCount | INTEGER NOT NULL | --,---,---,--9 | The count of queries that were classified into the WD but were subsequently aborted (no DBS error code). |
| ErrorCount | INTEGER NOT NULL | --,---,---,--9 | The count of queries that completed with an error (error code) in the collection period for this WD. |
| RejectedCount | INTEGER NOT NULL | --,---,---,--9 | Number of queries that were rejected by TDWM for this workload definition during this interval. |
| MovedInCount | INTEGER | --,---,---,--9 | Number of queries that were moved into this workload definition due to an exception during this interval. |
| IntervalDelayCnt | INTEGER | --,---,---,--9 | Number of queries that are currently delayed during this interval. |
| DelayedQueries | INTEGER | --,---,---,--9 | Number of queries that are delayed for this workload definition. |
| OtherCount | INTEGER | --,---,---,--9 | Number of queries that finished in this WD that had no error or abort, AMPs or Parser CPU. |
| VirtualPartNum | INTEGER | --,---,---,--9 | The Virtual Partition number of the WD. |
| AvgIOWaitTime | FLOAT | ----,---,---,---,--9 | The average IO wait time in milliseconds for those queries completed in this WD in this collection period. |
| MaxIOWaitTime | FLOAT | ----,---,---,---,--9 | The maximum IO wait time in milliseconds for those queries completed in this WD in this collection period. |
| AvgOtherWaitTime | FLOAT | ----,---,---,---,--9 | The average other wait time in seconds for those queries completed in this WD in this collection period. |
| MaxOtherWaitTime | FLOAT | ----,---,---,---,--9 | The maximum other wait time in seconds for those queries completed in this WD in this collection period. |
| AvgCPURunDelay | FLOAT | ----,---,---,---,--9 | The average CPU run delay in milliseconds for those queries completed in this WD in this collection period. |
| MaxCPURunDelay | FLOAT | ----,---,---,---,--9 | The maximum CPU run delay in milliseconds for those queries completed in this WD in this collection period. |
| AvgSeqRespTime | FLOAT | ----,---,---,---,--9 | The average sequential response time in milliseconds for those queries completed in this WD in this collection period. |
| MaxSeqRespTime | FLOAT | ----,---,---,---,--9 | The maximum sequential response time in milliseconds for those queries completed in this WD in this collection period. |
| AvgLogicalIO | FLOAT | ----,---,---,---,--9 | The average logical IO for those queries completed in this WD in this collection period. |
| MaxLogicalIO | FLOAT | ----,---,---,---,--9 | The maximum logical IO for those queries completed in this WD in this collection period. |
| AvgLogicalKBs | FLOAT | ----,---,---,---,--9 | The average logical KBs for those queries completed in this WD in this collection period. |
| MaxLogicalKBs | FLOAT | ----,---,---,---,--9 | The maximum logical KBs for those queries completed in this WD in this collection period. |
| AvgPhysicalIO | FLOAT | ----,---,---,---,--9 | The average physical IO for those queries completed in this WD in this collection period. |
| MaxPhysicalIO | FLOAT | ----,---,---,---,--9 | The maximum physical IO for those queries completed in this WD in this collection period. |
| AvgPhysicalKBs | FLOAT | ----,---,---,---,--9 | The average physical KBs for those queries completed in this WD in this collection period. |
| MaxPhysicalKBs | FLOAT | ----,---,---,---,--9 | The maximum physical KBs for those queries completed in this WD in this collection period. |
| ThrottleBypassed | INTEGER | --,---,---,--9 | Number of queries that are only running due to the ThrottleBypass feature. |
| FlexActive | INTEGER NOT NULL | --,---,---,--9 | Number of queries that are only running due to the Flex Throttle feature. |
| FlexComplete | INTEGER NOT NULL | --,---,---,--9 | The number of queries that completed due to the Flex Throttle feature. |
| FlexArrivals | INTEGER NOT NULL | --,---,---,--9 | Number of queries that arrived due to Flex during this period |
| DeferredCount | INTEGER NOT NULL | --,---,---,--9 | Number of queries in this WD which have been deferred due to an ARM rule in this collection period. |
| DeferredQueries | INTEGER NOT NULL | --,---,---,--9 | Number of queries in this WD that were currently deferred due to an ARM rule when this data was collected. |
| AvgDeferTime | FLOAT NOT NULL | ----,---,---,---,--9 | The average defer time due to ARM rules in centiseconds for queries in this WD in this collection period. |