Category: Query
Database: DBC
| View Column | Data Type | Format | Description |
|---|---|---|---|
| StepStartTime | TIMESTAMP(6) | YYYY-MM-DDBHH:MI:SS.S(6) | Time when this step started execution on this specific AMP. |
| StepStopTime | TIMESTAMP(6) | YYYY-MM-DDBHH:MI:SS.S(6) | Time when this step stopped execution on this specific AMP. |
| QueryID | DECIMAL(18,0) | --Z(17)9 | (Foreign Key) System wide unique value to join DBQL tables. |
| AmpNum | INTEGER | -(10)9 | Number of the AMP vproc that collected this data row. |
| StepClass | CHAR(10) LATIN NOT CASESPECIFIC | X(10) | Step Class in text form. |
| StepKind | CHAR(15) LATIN NOT CASESPECIFIC | X(15) | Step Kind in text form. |
| StepLvl1 | INTEGER | -(10)9 | Step number Level 1. |
| StepLvl2 | INTEGER | -(10)9 | Step number Level 2, if this column has non-zero value, then this is a parallel step. |
| Version | INTEGER | -(10)9 | Version of Extended DBQL data collected for this step in this AMP vproc. |
| SlotsFilled | INTEGER | -(10)9 | Number of Extended DBQL data slots filled in. |
| PSFWDID | INTEGER | -(10)9 | PSF wdid for this step in this AMP vproc. |
| PSFOK | BYTEINT | -(3)9 | Value of 1 means PSF Data OK, otherwise invalid for this step in this AMP vproc. |
| WorkType | BYTEINT | -(3)9 | Expedite-adjusted AWT work type for this step execution in this AMP vproc. |
| PEVproc | INTEGER | -(10)9 | PE vproc id from which this request was issued. |
| TxnUnique | BYTE(4) | X(8) | Transaction unique value of this request. |
| IOWaitPDE | FLOAT | ----,---,---,---,--9.999 | PDE IO Wait in seconds for this step in this AMP vproc. |
| WaitOtherPDE | FLOAT | ----,---,---,---,--9.999 | PDE Other Wait in seconds for this step in this AMP vproc. |
| IOWait | FLOAT | ----,---,---,---,--9.999 | IO Wait in seconds for this step in this AMP vproc. |
| WaitOther | FLOAT | ----,---,---,---,--9.999 | Other Wait in seconds for this step in this AMP vproc. |
| CpuRunDelay | FLOAT | ----,---,---,---,--9.999 | CPU run delay in seconds for this step in this AMP vproc. |
| TotalKernelCPUTime | FLOAT | ----,---,---,---,--9.999 | Kernel CPU time in seconds used by this AMP vproc since the task started. |
| KernelCPUTime | FLOAT | ----,---,---,---,--9.999 | Kernel CPU time in seconds for this step in this AMP vproc. |
| TotalUserCPUTime | FLOAT | ----,---,---,---,--9.999 | User CPU time in seconds used by this AMP vproc since the task started. |
| UserCPUTime | FLOAT | ----,---,---,---,--9.999 | User CPU time in seconds for this step in this AMP vproc. |
| FsgIoEl | INTEGER | -(10)9 | Time in ms spent sleeping waiting for a FSG I/O to complete. |
| FsgIoCnt | INTEGER | -(10)9 | Number of times spent sleeping waiting for a FSG I/O to complete. |
| FsgWritePendMiEl | INTEGER | -(10)9 | Time in ms spent sleeping waiting for an MI write lock. |
| FsgWritePendMiCnt | INTEGER | -(10)9 | Number of times spent sleeping waiting for an MI write lock. |
| FsgNoModPendMiEl | INTEGER | -(10)9 | Time in ms spent sleeping waiting for an MI nomod write lock. |
| FsgNoModPendMiCnt | INTEGER | -(10)9 | Number of times spent sleeping waiting for an MI nomod write lock. |
| FsgReadPendMiEl | INTEGER | -(10)9 | Time in ms spent sleeping waiting for an MI read lock. |
| FsgReadPendMiCnt | INTEGER | -(10)9 | Number of times spent sleeping waiting for an MI read lock. |
| FsgWritePendNonSpoolCiEl | INTEGER | -(10)9 | Time in ms spent sleeping waiting for a nonspool CI write lock. |
| FsgWritePendNonSpoolCiCnt | INTEGER | -(10)9 | Number of times spent sleeping waiting for a nonspool CI write lock. |
| FsgNoModPendNonSpoolCiEl | INTEGER | -(10)9 | Time in ms spent sleeping waiting for a nonspool CI nomod write lock. |
| FsgNoModPendNonSpoolCiCnt | INTEGER | -(10)9 | Number of times spent sleeping waiting for a nonspool CI nomod write lock. |
| FsgReadPendNonSpoolCiEl | INTEGER | -(10)9 | Time in ms spent sleeping waiting for a nonspool CI read lock. |
| FsgReadPendNonSpoolCiCnt | INTEGER | -(10)9 | Number of times spent sleeping waiting for a nonspool CI read lock. |
| FsgWritePendSpoolCiEl | INTEGER | -(10)9 | Time in ms spent sleeping waiting for a spool CI write lock. |
| FsgWritePendSpoolCiCnt | INTEGER | -(10)9 | Number of times spent sleeping waiting for a spool CI write lock. |
| FsgNoModPendSpoolCiEl | INTEGER | -(10)9 | Time in ms spent sleeping waiting for a spool CI nomod write lock. |
| FsgNoModPendSpoolCiCnt | INTEGER | -(10)9 | Number of times spent sleeping waiting for a spool CI nomod write lock. |
| FsgReadPendSpoolCiEl | INTEGER | -(10)9 | Time in ms spent sleeping waiting for a spool CI read lock. |
| FsgReadPendSpoolCiCnt | INTEGER | -(10)9 | Number of times spent sleeping waiting for a spool CI read lock. |
| FsgWritePendDbEl | INTEGER | -(10)9 | Time in ms spent sleeping waiting for a DB write lock. |
| FsgWritePendDbCnt | INTEGER | -(10)9 | Number of times spent sleeping waiting for a DB write lock. |
| FsgNoModPendDbEl | INTEGER | -(10)9 | Time in ms spent sleeping waiting for a DB nomod write lock. |
| FsgNoModPendDbCnt | INTEGER | -(10)9 | Number of times spent sleeping waiting for a DB nomod write lock. |
| FsgReadPendDbEl | INTEGER | -(10)9 | Time in ms spent sleeping waiting for a DB read lock. |
| FsgReadPendDbCnt | INTEGER | -(10)9 | Number of times spent sleeping waiting for a DB read lock. |