Category: Query
Database: DBC
| View Column | Data Type | Format | Description |
|---|---|---|---|
| StepStartTime | TIMESTAMP(6) | YYYY-MM-DDBHH:MI:SS.S(6) | Returns the date and time to the nearest microsecond when the step is sent to the AMP. |
| StepStopTime | TIMESTAMP(6) | YYYY-MM-DDBHH:MI:SS.S(6) | Returns the date and time to the nearest microsecond when the step returns from the 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. |
| CumCPU | FLOAT | ----,---,---,---,--9.999 | Cumulative CPU time for the specific session in seconds. |
| CumIO | FLOAT | ----,---,---,---,--9 | Cumulative IO count for the specific session. |
| CPUTime | FLOAT | ----,---,---,---,--9.999 | CPU time in seconds for this step execution in this AMP vproc. |
| IOCount | FLOAT | ----,---,---,---,--9 | IO count for this step execution in this AMP vproc. |
| IOKB | FLOAT | ----,---,---,---,--9.999 | IO in KB for this step execution in this AMP vproc. |
| PhysIOCount | FLOAT | ----,---,---,---,--9 | Physical IO count for this step execution in this AMP vproc. |
| PhysIOKB | FLOAT | ----,---,---,---,--9.999 | Physical IO in KB for this step execution in this AMP vproc. |
| VHIOCount | FLOAT | ----,---,---,---,--9 | Very Hot IO count for this step execution in this AMP vproc. |
| VHIOKB | FLOAT | ----,---,---,---,--9.999 | Very Hot IO in KB for this step execution in this AMP vproc. |
| VHPhysIOCount | FLOAT | ----,---,---,---,--9 | Very Hot Physical IO count for this step execution in this AMP vproc. |
| VHPhysIOKB | FLOAT | ----,---,---,---,--9.999 | Very Hot Physical IO in KB for this step execution in this AMP vproc. |
| 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. |
| TDWMwdid | INTEGER | -(10)9 | TDWM wdid for this step in this AMP vproc. |
| CPUDecayLevel | BYTEINT | -(3)9 | CPU Decay Level for this step execution in this AMP vproc. |
| IODecayLevel | BYTEINT | -(3)9 | IO Decay Level for this step execution in this AMP vproc. |
| CPUException | BYTEINT | -(3)9 | CPU Exception for this step execution in this AMP vproc. |
| IOException | BYTEINT | -(3)9 | IO Exception for this step execution in this AMP vproc. |
| UsedIOTA | FLOAT | ----,---,---,---,--9.999 | Used IO Token Allocation for this step execution in this AMP vproc. |
| CollectAlg | SMALLINT | ---,--9 | DBQL data collection algorithm used for this collection. |
| UDFCpuTime | FLOAT | ----,---,---,---,--9.999 | UDF CPU Usage for this step execution in this AMP vproc. |
| UDFMemUsage | FLOAT | ----,---,---,---,--9.999 | UDF Memory Usage for this step execution in this AMP vproc. |
| UDFVMPeak | FLOAT | ----,---,---,---,--9.999 | UDF Virtual Memory Peak usage for this step in this AMP vproc. |
| UDFVMData | FLOAT | ----,---,---,---,--9.999 | UDF Virtual Memory Data usage for this step in this AMP vproc. |
| AWTSec | FLOAT | ----,---,---,---,--9.999 | AWT elapsed time in seconds for this step in this AMP vproc. |
| SpoolUsage | FLOAT | ----,---,---,---,--9.999 | Peak spool usage in bytes for this step in this AMP vproc. |
| PersistentSpoolUsage | FLOAT | ----,---,---,---,--9.999 | Peak persistent spool usage in bytes for this step in this AMP vproc. |
| LocSpoolUsage | FLOAT | ----,---,---,---,--9.999 | Peak Local spool usage in bytes for this step in this AMP vproc. |
| NosRecordsReturned | BIGINT | --,---,---,---,---,---,--9 | NOS records returned for this step in this AMP vproc. |
| NosRecordsSkipped | BIGINT | --,---,---,---,---,---,--9 | NOS records skipped for this step in this AMP vproc. |
| NosPhysReadIO | BIGINT | --,---,---,---,---,---,--9 | NOS Physical read IO count for this step in this AMP vproc. |
| NosPhysReadIOKB | FLOAT | ----,---,---,---,--9.999 | NOS Physical read IO in KB for this step in this AMP vproc. |
| NosRecordsReturnedKB | FLOAT | ----,---,---,---,--9.999 | NOS Records returned in KB for this step in this AMP vproc. |
| NosTotalIOWaitTime | FLOAT | ----,---,---,---,--9.999 | NOS Total IO wait time for this step in this AMP vproc. |
| NosMaxIOWaitTime | FLOAT | ----,---,---,---,--9.999 | NOS Maximum IO wait time for this step in this AMP vproc. |
| NosCPUTime | FLOAT | ----,---,---,---,--9.999 | NOS CPU time for this step in this AMP vproc. |
| NosFiles | INTEGER | --,---,---,--9 | NOS files count for this step in this AMP vproc. |
| NosFilesSkipped | INTEGER | --,---,---,--9 | NOS files skipped count for this step in this AMP vproc. |
| NumPrvSegs | INTEGER | --,---,---,--9 | Number of 64K private memory segments used for this step in this AMP vproc. |
| MaxPrvSegs | INTEGER | --,---,---,--9 | Maximum number of 64K private memory segments used for this step in this AMP vproc. |
| NumShrSegs | INTEGER | --,---,---,--9 | Number of 64K shared memory segments used for this step in this AMP vproc. |
| MaxShrSegs | INTEGER | --,---,---,--9 | Maximum number of 64K shared memory segments used for this step in this AMP vproc. |
| UsrPrvsegget | INTEGER | --,---,---,--9 | Number of segget() used to get private DBS memory for this step by this AMP vproc. |
| UsrPrvseggetSz | FLOAT | ----,---,---,---,--9.999 | Private DBS memory in MB used for this step by this AMP vproc. |
| UsrShrsegaccess | INTEGER | --,---,---,--9 | Number of segaccess() used to get shared DBS memory for this step by this AMP vproc. |
| UsrShrsegaccessSz | FLOAT | ----,---,---,---,--9.999 | Shared DBS memory in MB used for this step by this AMP vproc. |
| UsrPrvsegdiscard | INTEGER | --,---,---,--9 | Number of segdiscard() used to discard private DBS memory for this step by this AMP vproc. |
| UsrPrvsegdiscardSz | FLOAT | ----,---,---,---,--9.999 | Private DBS memory in MB discarded for this step by this AMP vproc. |
| UsrShrsegdrop | INTEGER | --,---,---,--9 | Number of segdrop() used to drop shared DBS memory for this step by this AMP vproc. |
| UsrShrsegdropSz | FLOAT | ----,---,---,---,--9.999 | Shared DBS memory in MB dropped for this step by this AMP vproc. |
| UsrPrvsegcurSz | FLOAT | ----,---,---,---,--9.999 | Current private memory in MB used for this step by this AMP vproc. |
| UsrShrsegcurSz | FLOAT | ----,---,---,---,--9.999 | Current shared memory in MB used for this step by this AMP vproc. |
| UsrPrvsegpeakSz | FLOAT | ----,---,---,---,--9.999 | Peak private memory in MB used for this step by this AMP vproc |
| UsrShrsegpeakSz | FLOAT | ----,---,---,---,--9.999 | Peak shared memory in MB used for this step by this AMP vproc. |
| IOWaitPDE | FLOAT | ----,---,---,---,--9.999 | PDE IO wait time in seconds for this step by this AMP vproc. |
| WaitOtherPDE | FLOAT | ----,---,---,---,--9.999 | PDE Non-IO wait time in seconds for this step by this AMP vproc. |
| IOWait | FLOAT | ----,---,---,---,--9.999 | OS IO wait time in seconds for this step by this AMP vproc. |
| WaitOther | FLOAT | ----,---,---,---,--9.999 | OS non-IO wait time in seconds for this step by this AMP vproc. |
| CPURunDelay | FLOAT | ----,---,---,---,--9.999 | OS wait time in seconds for CPU in this step by 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 by 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 by this AMP vproc. |
| NosPhysWriteIO | BIGINT | --,---,---,---,---,---,--9 | NOS physical write IO count for this step in this AMP vproc. |
| NosPhysWriteIOKB | FLOAT | ----,---,---,---,--9.999 | NOS physical write IO in KB for this step in this AMP vproc. |
| NosFilesWritten | INTEGER | --,---,---,--9 | NOS files written count for this step in this AMP vproc. |
| PhysLocIO | FLOAT | ----,---,---,---,--9.999 | Physical local IO count used for this step in this AMP vproc. |
| PhysLocIOKB | FLOAT | ----,---,---,---,--9.999 | Physical local IO in KB used for this step in this AMP vproc. |
| HPPCSRatio | FLOAT | ----,---,---,---,--9.999 | The producer-consumer speed ratio for this step in this AMP vproc. |
| HPNumBuffers | INTEGER | --,---,---,--9 | The number of buffers used by the step as a producer to write the rows. |
| NosPhysDataReadIO | BIGINT | ----,---,---,---,--9 | NOS physical data read IO count for this step in this AMP vproc. |
| NosPhysDataReadIOKB | FLOAT | ----,---,---,---,--9.999 | NOS physical data read IO in KB for this step in this AMP vproc. |
| NosCacheReadIO | BIGINT | ----,---,---,---,--9 | NOS cache data read IO count for this step in this AMP vproc. |
| NosCacheReadIOKB | FLOAT | ----,---,---,---,--9.999 | NOS cache data read IO in KB for this step in this AMP vproc. |
| NosPrefetchReadIO | FLOAT | ----,---,---,---,--9.999 | NOS readahead data read IO count for this step in this AMP vproc. |
| NosPrefetchReadIOKB | FLOAT | ----,---,---,---,--9.999 | NOS readahead data read IO in KB for this step in this AMP vproc. |
| NosFilesDeleted | FLOAT | ----,---,---,---,--9.999 | NOS files deleted count for this step in this AMP vproc. |
| NosDeleteIO | FLOAT | ----,---,---,---,--9.999 | NOS delete IO count for this step in this AMP vproc. |
| NosDeleteIOKB | FLOAT | ----,---,---,---,--9.999 | NOS delete IO in KB for this step in this AMP vproc. |
| NosSpTablesRead | INTEGER | --,---,---,--9 | Number of OFS spool tables accessed. This value should be same as the number of OFS spool MIs read for this step in this AMP vproc. |
| NosSpTablesWritten | INTEGER | --,---,---,--9 | Number of OFS spool tables written. This corresponds to the number of OFS spool MIs written for this step in this AMP vproc. |
| NosSpCIsReturned | BIGINT | --,---,---,---,---,---,--9 | Number of OFS spool CIs returned by an OFS spool for this step in this AMP vproc. |
| NosSpCIsReturnedKB | FLOAT | ----,---,---,---,--9.999 | Total KB of OFS spool CIs returned by an OFS spool for this step in this AMP vproc. |
| NosSpDBChunksReturned | BIGINT | --,---,---,---,---,---,--9 | Number of OFS spool datablock chunks returned by an OFS spool for this step in this AMP vproc. |
| NosSpDBChunksReturnedKB | FLOAT | ----,---,---,---,--9.999 | Total KB of OFS spool datablock chunks returned by an OFS spool for this step in this AMP vproc. |
| NosSpDBsReturned | BIGINT | --,---,---,---,---,---,--9 | Number of OFS spool datablocks returned by an OFS spool for this step in this AMP vproc. |
| NosSpDBsReturnedKB | FLOAT | ----,---,---,---,--9.999 | Total KB of OFS spool datablocks returned by an OFS spool for this step in this AMP vproc. |
| NosSpBlksFSGAcqs | BIGINT | --,---,---,---,---,---,--9 | Number of OFS spool datablocks read from FSG for this step in this AMP vproc. |
| NosSpBlksFSGAcqsKB | FLOAT | ----,---,---,---,--9.999 | Total KB of OFS spool datablocks read from FSG for this step in this AMP vproc. |
| NosSpCPUTime | FLOAT | ----,---,---,---,--9.999 | Total CPU time in seconds for reading OFS spool blocks (MI, CI, DBChunks) for this step in this AMP vproc. |
| NosSpMaxIOWaitTime | FLOAT | ----,---,---,---,--9.999 | Maximum OFS spool IO wait time in seconds for any individual IO for this step in this AMP vproc. |
| NosSpTotalIOWaitTime | FLOAT | ----,---,---,---,--9.999 | Total OFS spool IO wait time in seconds for this step in this AMP vproc. |
| NosSpCIsWritten | BIGINT | --,---,---,---,---,---,--9 | Number of OFS spool CIs written for this step in this AMP vproc. |
| NosSpCIsWrittenKB | FLOAT | ----,---,---,---,--9.999 | Total KB of OFS spool CIs written for this step in this AMP vproc. |
| NosSpDBChunksWritten | BIGINT | --,---,---,---,---,---,--9 | Number of OFS spool DB chunks written for this step in this AMP vproc. |
| NosSpDBChunksWrittenKB | FLOAT | ----,---,---,---,--9.999 | Total KB of OFS spool DB chunks written for this step in this AMP vproc. |
| NosSpDBsWritten | BIGINT | --,---,---,---,---,---,--9 | Number of OFS spool DBs written for this step in this AMP vproc. |
| NosSpDBsWrittenKB | FLOAT | ----,---,---,---,--9.999 | Total KB of OFS spool DBs written for this step in this AMP vproc. |
| SpoolProd | BIGINT | --,---,---,---,---,---,--9 | Spool produced by this step in this AMP vproc in bytes. |
| SpoolCons | BIGINT | --,---,---,---,---,---,--9 | Spool consumed by this step in this AMP vproc in bytes. |