Category: Query
Database: DBC
| View Column | Data Type | Format | Description |
|---|---|---|---|
| ProcID | DECIMAL(5,0) NOT NULL | -(5)9 | The process ID of the dispatcher. |
| CollectTimeStamp | TIMESTAMP(6) NOT NULL | YYYY-MM-DDBHH:MI:SS.S(6) | (Prime Key) Time and date when the DBQL summary cache was written. |
| UserID | BYTE(4) | X(8) | The ID of the user. |
| AcctString | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The user unexpanded logon account string. |
| LogicalHostID | SMALLINT | -(5)9 | Unique identifier of the logon source for the logged query. A value of zero indicates an internal session. |
| AppID | CHAR(30) UNICODE NOT CASESPECIFIC | X(30) | The application ID. |
| ClientID | CHAR(30) UNICODE NOT CASESPECIFIC | X(30) | The client ID. |
| ClientAddr | CHAR(45) LATIN NOT CASESPECIFIC | X(45) | IP address of the client who submitted the query. |
| ProfileID | BYTE(4) | X(8) | Unique number assigned to the cost profile instance in the system. |
| SessionID | INTEGER NOT NULL | --,---,---,--9 | The session identifier. |
| QueryCount | INTEGER NOT NULL | --,---,---,--9 | Number of queries run in a 10-minute interval. Used with the "SUMMARY" or "THRESHOLD" SQL option only. |
| ValueType | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | The type that was used to determine the threshold from the following values: C = CPU seconds I = IO count S = Elapsed time in seconds. |
| QuerySeconds | FLOAT NOT NULL | ----,---,---,---,--9.999 | Total number of seconds used by QueryCount. QuerySeconds can be used to get an average. |
| AverageTime | FLOAT | ZZZ,ZZZ.999 | The average elapsed time (to the nearest hundredth of a second). |
| TotalIOCount | FLOAT | ----,---,---,---,--9 | Number of IOs from AMPs that were generated by the query. |
| TotalIOKB | FLOAT | ----,---,---,---,--9.999 | Total I/Os in kilobytes used by the requests in summary mode during the collection period. |
| AverageIO | FLOAT | Z(10) | The average Logical IO Count. |
| AMPCPUTime | FLOAT | ZZZ,ZZZ.999 | Total AMP CPU time in seconds used for query. |
| AverageAmpCPU | FLOAT | ZZZ,ZZZ.999 | Average number of AMP CPU seconds used by QueryCount. |
| ParserCPUTime | FLOAT | ZZZ,ZZZ.999 | The total parser and dispatcher CPU time in seconds used for the query. |
| AverageParserCPU | FLOAT | ZZZ,ZZZ.999 | Average number of CPU seconds used in the parser by QueryCount. |
| AMPCPUTimeNorm | FLOAT | ZZZ,ZZZ.999 | Normalized AMP CPU time in seconds for co-existence systems. |
| AverageAmpCPUNorm | FLOAT | ZZZ,ZZZ.999 | Average number of normalized AMP CPU seconds used by QueryCount. |
| ParserCPUTimeNorm | FLOAT | ZZZ,ZZZ.999 | Normalized parser CPU time in seconds for co-existence systems. |
| AverageParserCPUNorm | FLOAT | ZZZ,ZZZ.999 | Average number of normalized CPU seconds used in the parser by QueryCount. |
| LowHist | FLOAT NOT NULL | ----,---,---,---,--9.999 | For SUMMARY option, lowest value specified as query execution differentiation. For THRESHOLD option, threshold specified by the user. |
| HighHist | FLOAT NOT NULL | ----,---,---,---,--9.999 | The highest value specified as a query execution time differentiation. Used with the "SUMMARY" SQL option only. If THRESHOLD is used, HighHist is 0. |
| UsedIota | FLOAT | ----,---,---,---,--9.999 | IO Tokens used by the requests that are logged in summary mode. |
| ReqPhysIO | FLOAT | ----,---,---,---,--9.999 | Total number of Physical I/Os for the whole request in summary mode. |
| ReqPhysIOKB | FLOAT | ----,---,---,---,--9.999 | Total Physical I/Os in kilobytes for the whole request in summary mode. |
| StartTime | TIMESTAMP(6) | YYYY-MM-DDBHH:MI:SS.S(6) | The timestamp of the first query included for this summary row. |
| StopTime | TIMESTAMP(6) | YYYY-MM-DDBHH:MI:SS.S(6) | The timestamp of the last query included for this summary row. |
| UserName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The name of the userid, if any, under which the user submitted the query. |
| ProfileName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The name of the profile, if any, under which the user submitted the query. |