Category: Query
Database: DBC
| View Column | Data Type | Format | Description |
|---|---|---|---|
| ReqStartTime | TIMESTAMP(6) | YYYY-MM-DDBHH:MI:SS.S(6) | Time when this request started execution on this specific PE. |
| ReqStopTime | TIMESTAMP(6) | YYYY-MM-DDBHH:MI:SS.S(6) | Time when this request stopped execution on this specific PE.Time when this request stopped execution on this specific PE. |
| QueryID | DECIMAL(18,0) | --Z(17)9 | (Foreign Key) System wide unique value to join DBQL tables. |
| PSFWDID | INTEGER | -(10)9 | PSF wdid for this request in this PE vproc when the request completed. |
| PSFOK | BYTEINT | -(3)9 | Value of 1 means PSF Data OK, otherwise invalid for this request in this PE vproc. |
| PEVproc | INTEGER | -(10)9 | PE vproc id from which this request was issued. |
| Version | INTEGER | -(10)9 | Version of Extended DBQL data collected for this request in this PE vproc. |
| SlotsFilled | INTEGER | -(10)9 | Number of Extended DBQL data slots filled in. |
| IOWaitPDE | FLOAT | ----,---,---,---,--9.999 | PDE IO Wait in seconds for this request in this PE vproc. |
| WaitOtherPDE | FLOAT | ----,---,---,---,--9.999 | PDE Other Wait in seconds for this request in this PE vproc. |
| IOWait | FLOAT | ----,---,---,---,--9.999 | IO Wait in seconds for this request in this PE vproc. |
| WaitOther | FLOAT | ----,---,---,---,--9.999 | Other Wait in seconds for this request in this PE vproc. |
| CpuRunDelay | FLOAT | ----,---,---,---,--9.999 | CPU run delay in seconds for this request in this PE vproc. |
| TotalKernelCPUTime | FLOAT | ----,---,---,---,--9.999 | Kernel CPU time in seconds used by this PE vproc since the task started. |
| KernelCPUTime | FLOAT | ----,---,---,---,--9.999 | Kernel CPU time in seconds used by this PE vproc since the request started. |
| TotalUserCPUTime | FLOAT | ----,---,---,---,--9.999 | User CPU time in seconds used by this PE vproc since the task started. |
| UserCPUTime | FLOAT | ----,---,---,---,--9.999 | User CPU time in seconds used by this PE vproc since the request started. |
| RxTime | FLOAT | ----,---,---,---,--9.999 | Parser express request elapsed time in seconds spent in msgrx, part is delay time and part real work for this request in this PE vproc. |
| RxCount | INTEGER | -(10)9 | Number of msgrx calls in RxTime for this request in this PE vproc. |
| TxTime | FLOAT | ----,---,---,---,--9.999 | Parser express request elapsed time in seconds spent in msgtx, part is delay time and part real work for this request in this PE vproc. |
| TxCount | INTEGER | -(10)9 | Number of msgtx calls in TxTime for this request in this PE vproc. |
| SleepTime | FLOAT | ----,---,---,---,--9.999 | Parser express request elapsed seconds spent in timhang/sleep for this request in this PE vproc. |
| SleepCount | INTEGER | -(10)9 | Number of timhang/sleep calls in SleepTime for this request in this PE vproc. |
| DelayTime | FLOAT | ----,---,---,---,--9.999 | Parser express request elapsed seconds delay time asked for in timhang/sleep for this request in this PE vproc. |
| FsgDbPendLockDepthCnt | INTEGER | -(10)9 | Number of times task has waited for DB lock. |
| FsgMiPendLockDepthMax | INTEGER | -(10)9 | Maximum number of tasks waiting for MI lock when this task tried to get MI lock. |
| FsgCiPendLockDepthMax | INTEGER | -(10)9 | Maximum number of tasks waiting for MI lock when this task tried to get CI lock. |
| FsgDbPendLockDepthMax | INTEGER | -(10)9 | Maximum number of tasks waiting for MI lock when this task tried to get DB lock. |
| FsgIoWaitWithCiLockEl | INTEGER | -(10)9 | Time in ms spent waiting for an I/O to complete while holding CI lock. |
| FsgIoWaitWithCiLockCnt | INTEGER | -(10)9 | Number of times spent waiting for an I/O to complete while holding CI lock. |
| FsgIoWaitWithDbLockEl | INTEGER | -(10)9 | Time in ms spent waiting for an I/O to complete while holding DB lock. |
| FsgIoWaitWithDbLockCnt | INTEGER | -(10)9 | Number of times spent waiting for an I/O to complete while holding DB lock. |
| TotalLockWaitWithMiEl | INTEGER | -(10)9 | Time in ms spent waiting for FSG lock while holding MI lock. |
| TotalLockWaitWithCiEl | INTEGER | -(10)9 | Time in ms spent waiting for FSG lock while holding CI lock. |
| TotalLockWaitWithDbEl | INTEGER | -(10)9 | Time in ms spent waiting for FSG lock while holding DB lock. |
| TotalLockWaitWithMiCnt | INTEGER | -(10)9 | Number of times spent waiting for FSG lock while holding MI lock. |
| TotalLockWaitWithCiCnt | INTEGER | -(10)9 | Number of times spent waiting for FSG lock while holding CI lock. |
| TotalLockWaitWithDbCnt | INTEGER | -(10)9 | Number of times spent waiting for FSG lock while holding DB lock. |
| CiLockWaitWithMiWriteEl | INTEGER | -(10)9 | Time in ms spent waiting for CI lock while holding MI with write lock. |
| CiLockWaitWithMiNomodWrEl | INTEGER | -(10)9 | Time in ms spent waiting for CI lock while holding MI with nomodwrite lock. |
| CiLockWaitWithMiReadEl | INTEGER | -(10)9 | Time in ms spent waiting for CI lock while holding MI with read lock. |
| DbLockWaitWithCiWriteEl | INTEGER | -(10)9 | Time in ms spent waiting for DB lock while holding CI with write lock. |
| DbLockWaitWithCiNomodWrEl | INTEGER | -(10)9 | Time in ms spent waiting for DB lock while holding CI with nomodwrite lock. |
| DbLockWaitWithCiReadEl | INTEGER | -(10)9 | Time in ms spent waiting for DB lock while holding CI with read lock. |
| CiLockWaitWithMiWriteCnt | INTEGER | -(10)9 | Number of times spent waiting for CI lock while holding MI with write lock. |
| CiLockWaitWithMiNomodWrCnt | INTEGER | -(10)9 | Number of times spent waiting for CI lock while holding MI with nomodwrite lock. |
| CiLockWaitWithMiReadCnt | INTEGER | -(10)9 | Number of times spent waiting for CI lock while holding MI with read lock. |
| DbLockWaitWithCiWriteCnt | INTEGER | -(10)9 | Number of times spent waiting for DB lock while holding CI with write lock. |
| DbLockWaitWithCiNomodWrCnt | INTEGER | -(10)9 | Number of times spent waiting for DB lock while holding CI with nomodwrite lock. |
| DbLockWaitWithCiReadCnt | INTEGER | -(10)9 | Number of times spent waiting for DB lock while holding CI with read lock. |