Category: Query
Database: DBC
| View Column | Data Type | Format | Comment |
|---|---|---|---|
| ProcID | DECIMAL(5,0) NOT NULL | -(5)9 | Returns (Prime Key) ID of the Processing Engine from which the query was executed. |
| CollectTimeStamp | TIMESTAMP(6) NOT NULL | YYYY-MM-DDBHH:MI:SS.S(6) | Returns (Prime Key) Time and date when the DBQL steps cache was written. |
| QueryID | DECIMAL(18,0) NOT NULL | --Z(17)9 | Returns (Foreign Key) Systemwide unique value to join DBQL tables. |
| StepLev1Num | SMALLINT NOT NULL | ---,--9 | Returns Level 1 step number. |
| StepLev2Num | SMALLINT | ---,--9 | Returns Level 2 step number for parallel steps. |
| StepName | CHAR(6) LATIN NOT CASESPECIFIC NOT NULL | X(6) | Returns an abbreviation of the step name. For example: DEL for delete step. |
| 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. |
| ElapsedTime | HS | -h(4):mm:ss.s(6) | Returns the difference between last response time and start time (to the nearest microsecond) |
| EstProcTime | FLOAT | ----,---,---,---,--9.999 | Returns the estimated processing time in seconds from the Optimizer. |
| EstCPUCost | FLOAT | ZZ,ZZZ,ZZ9.999 | Returns 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 | Returns the estimated row count from the Optimizer; For PRPD step, the total estimated row count. |
| EstRowCountSkew | FLOAT | ----,---,---,---,--9 | For PRPD step, returns the estimated row count of skew spool. |
| EstRowCountSkewMatch | FLOAT | ----,---,---,---,--9 | For PRPD step, returns the estimated row count of skewmatch spool. |
| RowCount | FLOAT | ----,---,---,---,--9 | Returns the 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 | Returns the 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 | Returns the number of AMPS that were active for this query. |
| MaxAmpCPUTime | FLOAT | ZZ,ZZZ,ZZ9.999 | Returns the CPU time of the highest CPU utilized AMP in the query in seconds. |
| MaxCPUAmpNumber | INTEGER | --,---,---,--9 | Returns the number of the AMP with the highest CPU activity. |
| MinAmpCPUTime | FLOAT | ZZ,ZZZ,ZZ9.999 | Returns the CPU time of the lowest CPU utilized AMP in the step in seconds. |
| MaxAmpIO | FLOAT | ----,---,---,---,--9 | (renamed from HotAmpIO) Returns the I/O count of the highest I/O utilized AMP in the step. |
| MaxIOAmpNumber | INTEGER | --,---,---,--9 | Returns the number of the AMP with the highest IO usage for this step. |
| MinAmpIO | FLOAT | ----,---,---,---,--9 | (renamed from LowAmpIO) Returns the I/O count of the lowest I/O utilized 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 | Returns the highest spool usage on an AMP. This is the number of bytes of spool at the step level. |
| MaxSpoolAmpNumber | INTEGER | --,---,---,--9 | Returns the number of the AMP with high spool usage. |
| MinAMPSpool | BIGINT | --,---,---,---,---,---,--9 | Returns the lowest Spool usage on an AMP. This is the number of bytes of spool at the step level. |
| StepWD | INTEGER | --,---,---,--9 | Returns the identifier of the workload for the step. |
| LSN | INTEGER | --,---,---,--9 | Logon Sequence Number used by the load utility. |
| UtilityTableID | BYTE(4) | X(8) | Returns the table ID for the load utilities. |
| RowsWComprColumns | FLOAT | ----,---,---,---,--9 | For each step, the system returns the number of rows which contains at least one compressed column. |
| EstIOCost | FLOAT | ZZ,ZZZ,ZZ9.999 | Returns an estimate (from the optimizer) of service time in milliseconds for IO for the step. |
| EstNetCost | FLOAT | ZZ,ZZZ,ZZ9.999 | Returns an estimate (from the optimizer) of the BYNET service time in milliseconds for the step. |
| EstHRCost | FLOAT | ZZ,ZZZ,ZZ9.999 | Returns 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 | Returns the normalized maximum CPU Time in seconds for AMP. |
| MaxCPUAmpNumberNorm | INTEGER | --,---,---,--9 | Returns the number of the AMP with highest normalized CPU time for the step. |
| MinAmpCPUTimeNorm | FLOAT | ZZ,ZZZ,ZZ9.999 | Returns the normalized minimum CPU Time in seconds for AMP. |
| NumCombinedPartitions | BIGINT | --,---,---,---,---,---,--9 | Returns the number of combined partitions accessed (not eliminated). |
| NumContexts | INTEGER | --,---,---,--9 | Returns the number of contexts allocated to simultaneously access partitions of a source or target table with column partitioning. |
| NumCPReferences | INTEGER | --,---,---,--9 | Returns the 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 will be 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 | The total number of SSR receiver AMP that the step uses. |
| DMLLoadID | INTEGER | --,---,---,--9 | Returns the load value used by the CLDI modification step performed on LDI table/join index. |
| 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 | The 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 | The 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 | Return IO Tokens used by the step. |
| PermUsage | BIGINT | --,---,---,---,---,---,--9 | Returns the permanent space in bytes added or deleted by the step. |
| MaxAMPPerm | BIGINT | --,---,---,---,---,---,--9 | Returns the maximum permanent space in bytes added or deleted by an AMP in the step. |
| MaxPermAmpNumber | INTEGER | --,---,---,--9 | Returns the AMP number that added or deleted the maximum permanent space in the step. |
| SpaceDelay | FLOAT | ----,---,---,---,--9.999 | Returns the maximum wait time in centi-seconds to get space from the global space accounting system. |
| MaxSpaceDelayAmpNumber | INTEGER | --,---,---,--9 | Returns the AMP number that waited the maximum to obtain space. |
| UAFName | CHAR(10) LATIN NOT CASESPECIFIC | X(10) | Name of an Analytic Function being executed by EXECUTE FUNCTION in this step. The default is NULL. |
| InMemBulkQualStatus | BYTEINT | -(3)9 | Returns 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. |
| 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 | Returns AWT elapsed time in seconds for the step. |
| MaxAWTTime | FLOAT | ----,---,---,---,--9.999 | Returns Max AWT elapsed time in seconds for the step. |
| MaxAWTTimeAmpNum | INTEGER | --,---,---,--9 | Returns AMP number that had max AWTTime for the step. |
| MinAWTTime | FLOAT | ----,---,---,---,--9.999 | Returns 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 | FLOAT | ----,---,---,---,--9.999 | Total KB of physical write IOs for Native Object Store files for this step. |
| NosFilesWritten | INTEGER | --,---,---,--9 | Number of file writes attempted by Native Object Store in this step. |