SAP ABAP Domain DB2DSCTQAL (DB2 IFI DSC qualification by top statements)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-DB2 (Application Component) DB2 for z/OS
⤷
STU3 (Package) Development Class for Database Monitor
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-DB2 (Application Component) DB2 for z/OS⤷
STU3 (Package) Development Class for Database Monitor
Basic Data
| Domain Name | DB2DSCTQAL |
| Short Description | DB2 IFI DSC qualification by top statements |
Definition
| Data Type | NUMC | Character string with only digits |
| No. Characters | 2 | |
| Decimal Places | ||
| Output Length | 2 | |
| Conversion Routine | ||
| Sign | ||
| Lower Case |
Value Range
| # | Lower Limit | Upper Limit | Short Description |
|---|---|---|---|
| 1 | 01 | Number of executions | |
| 2 | 02 | Number of synchronous reads | |
| 3 | 03 | number of getpages | |
| 4 | 04 | Number of rows examined | |
| 5 | 05 | Number of rows proceesed | |
| 6 | 06 | Number of sorts | |
| 7 | 07 | Number of index scans | |
| 8 | 08 | Number of tablespace scans | |
| 9 | 09 | Number of parallel groups | |
| 10 | 10 | Number of synchronous writes | |
| 11 | 11 | Accumulated elapsed time | |
| 12 | 12 | Number of RID list failures (DB2 limits) | |
| 13 | 13 | Number of RID list failures (no storage) | |
| 14 | 14 | Accumulated CPU time | |
| 15 | 15 | Accumulated wait time for synch. I/O | |
| 16 | 16 | Accumulated wait time for lock request | |
| 17 | 17 | Accumulated wait time for a synch. execution unit switch | |
| 18 | 18 | Accumulated wait time for global locks | |
| 19 | 19 | Accumulated wait time for read activity by another thread | |
| 20 | 20 | Accumulated wait time for write activity by another thread | |
History
| Last changed by/on | SAP | 20110908 |
| SAP Release Created in | 700 |
