Category: Query
Database: DBC
| View Column | Data Type | Format | Description |
|---|---|---|---|
| ProcID | DECIMAL(5,0) NOT NULL | -(5)9 | (Prime Key) ID of the Processing Engine where query ran. |
| CollectTimeStamp | TIMESTAMP(6) NOT NULL | YYYY-MM-DDBHH:MI:SS.S(6) | (Prime Key) Time and date when the DBQL steps cache was written. |
| QueryID | DECIMAL(18,0) NOT NULL | --Z(17)9 | (Foreign Key) Systemwide unique value to join DBQL tables. |
| StepLev1Num | SMALLINT NOT NULL | ---,--9 | Level 1 step number. |
| StepLev2Num | SMALLINT | ---,--9 | Level 2 step number for parallel steps. |
| StepName | CHAR(6) LATIN NOT CASESPECIFIC NOT NULL | X(6) | Abbreviation of the step name. For example: DEL for delete step. |
| StepStartTime | TIMESTAMP(6) | YYYY-MM-DDBHH:MI:SS.S(6) | 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) | Date and time to the nearest microsecond when the step returns from the AMP. |
| ElapsedTime | HS | -h(4):mm:ss.s(6) | Difference between last response time and start time (to the nearest microsecond) |
| EstProcTime | FLOAT | ----,---,---,---,--9.999 | Estimated processing time in seconds from the Optimizer. |
| EstCPUCost | FLOAT | ZZ,ZZZ,ZZ9.999 | An estimate (from the optimizer) of the milliseconds of CPU time for the step. |
| CPUTime | FLOAT | ZZ,ZZZ,ZZ9.999 | Amount of CPU time in seconds used by the step. |
| IOcount | FLOAT | ----,---,---,---,--9 | Number of logical IOs issued by the step. |
| EstRowCount | FLOAT | ----,---,---,---,--9 | The estimated row count from the Optimizer; For PRPD step, the total estimated row count. |
| EstRowCountSkew | FLOAT | ----,---,---,---,--9 | For PRPD step, the estimated row count of skew spool. |
| EstRowCountSkewMatch | FLOAT | ----,---,---,---,--9 | For PRPD step, the estimated row count of skewmatch spool. |
| RowCount | FLOAT | ----,---,---,---,--9 | Number of rows inserted for the MultiLoad EXE step and the Merge Row Multiple (MRM) step; For PRPD step, the total row count of all split spools; For other steps, RowCount is the number of rows returned by the step. |
| RowCount2 | FLOAT | ----,---,---,---,--9 | Number of rows updated by the MultiLoad EXE step or the MRM step. For FastLoad LFI step, RowCount2 is the number of rows loaded by the step; For PRPD step, the row count of skew spool. |
| RowCount3 | FLOAT | ----,---,---,---,--9 | For MultiLoad EXE step, number of rows deleted. For PRPD step, the row count of skewmatch spool. |
| NumOfActiveAMPs | INTEGER | --,---,---,--9 | Number of AMPs that were active for this query. |
| MaxAmpCPUTime | FLOAT | ZZ,ZZZ,ZZ9.999 | The CPU time of the highest CPU used AMP in the query in seconds. |
| MaxCPUAmpNumber | INTEGER | --,---,---,--9 | Number of the AMP with the highest CPU activity. |
| MinAmpCPUTime | FLOAT | ZZ,ZZZ,ZZ9.999 | The CPU time of the lowest CPU used AMP in the step in seconds. |
| MaxAmpIO | FLOAT | ----,---,---,---,--9 | (renamed from HotAmpIO) The I/O count of the highest I/O used AMP in the step. |
| MaxIOAmpNumber | INTEGER | --,---,---,--9 | Number of the AMP with the highest IO usage for this step. |
| MinAmpIO | FLOAT | ----,---,---,---,--9 | (renamed from LowAmpIO) The I/O count of the lowest I/O used AMP in the query. |
| SpoolUsage | BIGINT | --,---,---,---,---,---,--9 | Peak Spool usage (bytes) of this step (DataCollectAlg=3). Otherwise, number of bytes of spool used by the step. |
| MaxAMPSpool | BIGINT | --,---,---,---,---,---,--9 | The highest spool usage on an AMP. This is the number of bytes of spool at the step level. |
| MaxSpoolAmpNumber | INTEGER | --,---,---,--9 | Number of the AMP with high spool usage. |
| MinAMPSpool | BIGINT | --,---,---,---,---,---,--9 | The lowest Spool usage on an AMP. This is the number of bytes of spool at the step level. |
| StepWD | INTEGER | --,---,---,--9 | Identifier of the workload for the step. |
| LSN | INTEGER | --,---,---,--9 | Logon Sequence Number used by the load utility. |
| UtilityTableID | BYTE(4) | X(8) | Table ID for the load utilities. |
| RowsWComprColumns | FLOAT | ----,---,---,---,--9 | For each step, the number of rows that contain at least one compressed column. |
| EstIOCost | FLOAT | ZZ,ZZZ,ZZ9.999 | An estimate (from the Optimizer) of service time in milliseconds for IO for the step. |
| EstNetCost | FLOAT | ZZ,ZZZ,ZZ9.999 | An estimate (from the Optimizer) of the BYNET service time in milliseconds for the step. |
| EstHRCost | FLOAT | ZZ,ZZZ,ZZ9.999 | An estimate (from the Optimizer) of other costs for the step. |
| CPUtimeNorm | FLOAT | ZZ,ZZZ,ZZ9.999 | Normalized amount of CPU time in seconds used by the step. |
| MaxAmpCPUTimeNorm | FLOAT | ZZ,ZZZ,ZZ9.999 | Normalized maximum CPU Time in seconds for AMP. |
| MaxCPUAmpNumberNorm | INTEGER | --,---,---,--9 | Number of the AMP with highest normalized CPU time for the step. |
| MinAmpCPUTimeNorm | FLOAT | ZZ,ZZZ,ZZ9.999 | Normalized minimum CPU Time in seconds for AMP. |
| NumCombinedPartitions | BIGINT | --,---,---,---,---,---,--9 | Number of combined partitions accessed (not eliminated). |
| NumContexts | INTEGER | --,---,---,--9 | Number of contexts allocated to simultaneously access partitions of a source or target table with column partitioning. |
| NumCPReferences | INTEGER | --,---,---,--9 | Number of column partitions referenced in a source or target table that has column partitioning. |
| StepInstance | INTEGER | --,---,---,--9 | Step instance number for iterative steps in order of dispatch. If a step is dispatched 3 times, there are 3 steps logged with the same step number and step instance 1, 2, 3 to distinguish them. |
| StepStatus | CHAR(10) LATIN NOT CASESPECIFIC | X(10) | Step status, indicating dispatcher and AMP step disposition. |
| DispatchSeq | INTEGER | --,---,---,--9 | Dispatch sequence, the order in which the step was "handled by the dispatcher itself" or dispatched to the AMPS beginning with 1. |
| StatementNum | INTEGER | --,---,---,--9 | Statement number with which the step is associated, starting with 1. The highest related statement number if step is related to multiple statements. |
| TriggerNestLevel | SMALLINT | -(5)9 | Trigger nesting level. |
| TriggerKind | VARCHAR(128) LATIN NOT CASESPECIFIC | X(128) | Trigger kind, space separated string of abbreviated values for the bit flags. |
| FragmentNum | INTEGER | --,---,---,--9 | Fragement number to which the step belongs in a IPE plan execution of request. |
| IOKB | FLOAT | ----,---,---,---,--9.999 | Logical AMP I/Os in KB generated by the step, or set of parallel steps if the second step level is 1. |
| VHLogicalIO | FLOAT | ----,---,---,---,--9.999 | Number of Very Hot Logical AMP I/Os generated by the step, or set of parallel steps if the second step level is 1. |
| VHPhysIO | FLOAT | ----,---,---,---,--9.999 | Number of Very Hot Physical AMP I/Os generated by the step, or set of parallel steps if the second step level is 1. |
| VHLogicalIOKB | FLOAT | ----,---,---,---,--9.999 | Very Hot Logical AMP I/Os in KB generated by the step, or set of parallel steps if the second step level is 1. |
| VHPhysIOKB | FLOAT | ----,---,---,---,--9.999 | Very Hot Physical AMP I/Os in KB generated by the step, or set of parallel steps if the second step level is 1. |
| PhysIO | FLOAT | ----,---,---,---,--9.999 | Number of Physical AMP I/Os generated by the step, or set of parallel steps if the second step level is 1. |
| PhysIOKB | FLOAT | ----,---,---,---,--9.999 | Physical AMP I/Os in KB generated by the step, or set of parallel steps if the second step level is 1. |
| LockDelay | FLOAT | ----,---,---,---,--9.999 | Maximum wait time to get a lock on object in centi-seconds. |
| SSRReceiverCount | INTEGER | --,---,---,--9 | Total number of SSR receiver AMP that the step uses. |
| ServerByteCount | BIGINT | --,---,---,---,---,---,--9 | Total bytes sent and received from the foreign server by the step. |
| PersistentSpool | BIGINT | --,---,---,---,---,---,--9 | Persistent part of SpoolUsage. |
| OneMBRowCount | FLOAT | ----,---,---,---,--9 | Number of 1MB rows (1MB > size > 64KB) in the set of rows returned by the step. |
| MaxOneMBRowSize | INTEGER | --,---,---,--9 | The largest row size among 1MB rows returned by step RET, JIN, SAMP, STATFN. |
| MaxNumMapAMPs | INTEGER | --,---,---,--9 | Number of AMPs in the largest map used by the step. |
| MinNumMapAMPs | INTEGER | --,---,---,--9 | Number of AMPs in the smallest contiguous map used by this step. |
| SysDefNumMapAMPs | INTEGER | --,---,---,--9 | Number of AMPs in the system-default map. |
| SourceMapNo | INTEGER | --,---,---,--9 | The map number for the source table in the step. |
| DestMapNo | INTEGER | --,---,---,--9 | The map number for the output table in the step. |
| StepObjectInfo | VARBYTE(1024) | X(2048) | Contains binary encoded information about tables, spools, and join indexes accessed by the step and is intended for use by Advisor procedures. |
| UsedIota | FLOAT | ----,---,---,---,--9.999 | The IO Tokens used by the step. |
| PermUsage | BIGINT | --,---,---,---,---,---,--9 | The permanent space in bytes added or deleted by the step. |
| MaxAMPPerm | BIGINT | --,---,---,---,---,---,--9 | Maximum permanent space in bytes added or deleted by an AMP in the step. |
| MaxPermAmpNumber | INTEGER | --,---,---,--9 | The AMP number that added or deleted the maximum permanent space in the step. |
| SpaceDelay | FLOAT | ----,---,---,---,--9.999 | Maximum wait time in centi-seconds to get space from the global space accounting system. |
| MaxSpaceDelayAmpNumber | INTEGER | --,---,---,--9 | The AMP number that waited the maximum to get space. |
| UAFName | CHAR(10) LATIN NOT CASESPECIFIC | X(10) | Name of an Analytic Function being run by EXECUTE FUNCTION in this step. The default is NULL. |
| InMemBulkQualStatus | BYTEINT | -(3)9 | The bulk qualification status of a step. |
| NosRecordsReturned | BIGINT | --,---,---,---,---,---,--9 | Number of records returned by a Native Object Store step. |
| NosRecordsSkipped | BIGINT | --,---,---,---,---,---,--9 | Number of records skipped by a Native Object Store step. |
| NosPhysReadIO | BIGINT | --,---,---,---,---,---,--9 | Total physical IOs for Native Object Store files for this step. |
| NosPhysReadIOKB | FLOAT | ----,---,---,---,--9.999 | Total KB of physical IOs for Native Object Store files in this step. |
| NosRecordsReturnedKB | FLOAT | ----,---,---,---,--9.999 | Total KB of records returned for Native Object Store files in this step. |
| NosTotalIOWaitTime | FLOAT | ----,---,---,---,--9.999 | Total of the Native Object Store IO wait time in seconds in this step. |
| NosCPUTime | FLOAT | ----,---,---,---,--9.999 | CPU time in seconds for reading Native Object Store files in this step. This time is already included in other non-NOS CPU fields. |
| NosMaxIOWaitTime | FLOAT | ----,---,---,---,--9.999 | Max Native Object Store IO wait time for any individual IO in seconds. |
| NosFiles | INTEGER | --,---,---,--9 | Number of file reads attempted by Native Object Store in this step. |
| NosFilesSkipped | INTEGER | --,---,---,--9 | Number of Native Object Store files that were skipped in this step. |
| AWTTime | FLOAT | ----,---,---,---,--9.999 | AWT elapsed time in seconds for the step. |
| MaxAWTTime | FLOAT | ----,---,---,---,--9.999 | Max AWT elapsed time in seconds for the step. |
| MaxAWTTimeAmpNum | INTEGER | --,---,---,--9 | The AMP number that had max AWTTime for the step. |
| MinAWTTime | FLOAT | ----,---,---,---,--9.999 | Min AWT elapsed time in seconds for the step. |
| UDFMemUsage | FLOAT | ----,---,---,---,--9.999 | Memory used by UDF for this step. |
| MaxUDFMemUsage | FLOAT | ----,---,---,---,--9.999 | Max memory in bytes used by UDF for this step. |
| MaxUDFMemUsageAmpNum | INTEGER | --,---,---,--9 | AMP number that had max memory used by UDF for this step. |
| UDFVMPeak | FLOAT | ----,---,---,---,--9.999 | UDF Virtual memory peak in bytes for the step. |
| UDFVMData | FLOAT | ----,---,---,---,--9.999 | UDF Virtual memory data size in bytes for the step. |
| NosPhysWriteIO | BIGINT | --,---,---,---,---,---,--9 | Total physical write IOs for Native Object Store files for this step. |
| NosPhysWriteIOKB | BIGINT | --,---,---,---,---,---,--9 | Total KB of physical write IOs for Native Object Store files for this step. |
| NosFilesWritten | BIGINT | --,---,---,---,---,---,--9 | Number of file writes attempted by Native Object Store in this step. |
| MaxPSFWDID | INTEGER | --,---,---,--9 | Max PSF WDID seen by this step. |
| MaxPSFWDIDAmpNum | INTEGER | --,---,---,--9 | Number of Max PSF WDID for this step. |
| PhysLocIO | FLOAT | ----,---,---,---,--9 | Total local physical IO count for this step. |
| PhysLocIOKB | FLOAT | ----,---,---,---,--9.999 | Total local physical IO for this step in kilobytes. |
| LocSpoolUsage | BIGINT | --,---,---,---,---,---,--9 | Local spool usage part of the SpoolUsage for this step in bytes. |
| NosPhysDataReadIO | BIGINT | --,---,---,---,---,---,--9 | Total physical data read IOs for Native Object Store files for this step. |
| NosPhysDataReadIOKB | BIGINT | --,---,---,---,---,---,--9 | Total KB of physical data read IOs for Native Object Store files for this step. |
| NosCacheReadIO | BIGINT | --,---,---,---,---,---,--9 | Total Cache Read IOs for Native Object Store files for this step. |
| NosCacheReadIOKB | BIGINT | --,---,---,---,---,---,--9 | Total KB of Cache Read IOs for Native Object Store files for this step. |
| NosPrefetchReadIO | BIGINT | --,---,---,---,---,---,--9 | Total Read Ahead IOs for Native Object Store files for this step. |
| NosPrefetchReadIOKB | BIGINT | --,---,---,---,---,---,--9 | Total KB of Read Ahead IOs for Native Object Store files for this step. |
| NosFilesDeleted | BIGINT | --,---,---,---,---,---,--9 | Total files deleted for Native Object Store files for this step. |
| NosDeleteIO | BIGINT | --,---,---,---,---,---,--9 | Total delete IOs for Native Object Store files for this step. |
| NosDeleteIOKB | BIGINT | --,---,---,---,---,---,--9 | Total KB of delete IOs for Native Object Store files for this step. |
| NosNumDeleteSuccess | INTEGER | --,---,---,--9 | Number of files successfully deleted by Native Object Store for this step. |
| NosNumDeleteFailure | INTEGER | --,---,---,--9 | Number of files failed to be deleted by Native Object Store for this step. |
| PeakAmpStpPrvMem | FLOAT | ----,---,---,---,--9.999 | Peak private memory in MB based on requested size used by this step. |
| PeakAmpStpPrvMemAmpNum | INTEGER | --,---,---,--9 | AMP Number of peak private memory based on requested size used by this step. |
| PeakAmpStpShrMem | FLOAT | ----,---,---,---,--9.999 | Peak shared memory in MB based on requested size used by this step. |
| PeakAmpStpShrMemAmpNum | INTEGER | --,---,---,--9 | AMP number of peak shared memory based on requested size used by this step. |
| HPPCSRatio | FLOAT | ----,---,---,---,--9.999 | The producer-consumer speed ratio for this step. |
| HPNumBuffers | INTEGER | --,---,---,--9 | The number of buffers used by the step as a producer to write the rows. |
| NosSpCIsReturned | BIGINT | --,---,---,---,---,---,--9 | Number of NOS Spool CIs returned by a Native Object Store spool for this step. |
| NosSpCIsReturnedKB | BIGINT | --,---,---,---,---,---,--9 | Total KB of NOS Spool CIs returned by a Native Object Store spool for this step. |
| NosSpDBChunksReturned | BIGINT | --,---,---,---,---,---,--9 | Number of NOS Spool Datablock chunks returned by a Native Object Store spool for this step. |
| NosSpDBChunksReturnedKB | BIGINT | --,---,---,---,---,---,--9 | Total KB of NOS spool datablock chunks returned by a Native Object Store spool for this step. |
| NosSpDBsReturned | BIGINT | --,---,---,---,---,---,--9 | Number of NOS Spool Datablocks returned by a Native Object Store spool for this step. |
| NosSpDBsReturnedKB | BIGINT | --,---,---,---,---,---,--9 | Total KB of NOS spool datablocks returned by a Native Object Store spool for this step. |
| NosSpBlksFSGAcqs | BIGINT | --,---,---,---,---,---,--9 | Number of NOS spool datablocks read from FSG for this step. |
| NosSpBlksFSGAcqsKB | BIGINT | --,---,---,---,---,---,--9 | Total KB of the Number of NOS spool datablocks read from FSG for this step. |
| NosSpCPUTime | FLOAT | ----,---,---,---,--9.999 | CPU time for reading Native Object Store spool blocks (MI, CI, DBChunks). Units of seconds for this step. |
| NosSpMaxIOWaitTime | FLOAT | ----,---,---,---,--9.999 | Max Native Object Store spool IO wait time for any individual IO for this step. Units of seconds. Both read and write. |
| NosSpTotalIOWaitTime | FLOAT | ----,---,---,---,--9.999 | Total of the Native Object Store spool IO wait time for this step. Units of seconds. Both read and write |
| NosSpTablesWritten | INTEGER | --,---,---,--9 | Number of NOS spool tables written. This corresponds to the number of TMIs written for this step. |
| NosSpCIsWritten | BIGINT | --,---,---,---,---,---,--9 | Number of NOS Spool CIs written for this step. |
| NosSpCIsWrittenKB | BIGINT | --,---,---,---,---,---,--9 | Total KB of NOS Spool CIs written for this step. |
| NosSpDBChunksWritten | BIGINT | --,---,---,---,---,---,--9 | Number of NOS spool DB chunks written for this step. |
| NosSpDBChunksWrittenKB | BIGINT | --,---,---,---,---,---,--9 | Total KB of NOS spool DB chunks written for this step. |
| NosSpDBsWritten | BIGINT | --,---,---,---,---,---,--9 | Number of NOS DBs written for this step. |
| NosSpDBsWrittenKB | BIGINT | --,---,---,---,---,---,--9 | Total KB Number of NOS spool DBs written for this step. |
| ParentReqStartTime | TIMESTAMP(6) | YYYY-MMDDBHH:MI:SS.S(6) | The time when the parent request was submitted. |
| ParentQueryID | DECIMAL(18,0) | --Z(17)9 | The parent system generated query id for this query. |
| SpoolProd | BIGINT | --,---,---,---,---,---,--9 | Spool produced by this step in bytes. |
| SpoolCons | BIGINT | --,---,---,---,---,---,--9 | Spool consumed by this step in bytes. |