Category: Query
Database: DBC
| View Column | Data Type | Format | Comment |
|---|---|---|---|
| ProcID | DECIMAL(5,0) NOT NULL | -(5)9 | Returns 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) | Returns the ID of the user. |
| AcctString | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the user unexpanded logon account string. |
| LogicalHostID | SMALLINT | -(5)9 | Returns a 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) | Returns the application ID. |
| ClientID | CHAR(30) UNICODE NOT CASESPECIFIC | X(30) | Returns the client ID. |
| ClientAddr | CHAR(45) LATIN NOT CASESPECIFIC | X(45) | Returns the IP address of the client who submitted the query. |
| ProfileID | BYTE(4) | X(8) | Returns the unique number assigned to the cost profile instance in the system. |
| SessionID | INTEGER NOT NULL | --,---,---,--9 | Returns the session identifier. |
| QueryCount | INTEGER NOT NULL | --,---,---,--9 | Returns the 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) | Returns the type that was used to determine the threshold from the values listed below. C = CPU seconds I = IO count S = Elapsed time in seconds. |
| QuerySeconds | FLOAT NOT NULL | ----,---,---,---,--9.999 | Returns the total number of seconds used by QueryCount. QuerySeconds can be used to obtain an average. |
| AverageTime | FLOAT | ZZZ,ZZZ.999 | Returns the average elapsed time (to the nearest hundredth of a second). |
| TotalIOCount | FLOAT | ----,---,---,---,--9 | Returns the number of IOs from AMPs that were generated by the query. |
| AverageIO | FLOAT | Z(10) | Returns the average Logical IO Count. |
| AMPCPUTime | FLOAT | ZZZ,ZZZ.999 | Returns the total AMP CPU time in seconds used for query. |
| AverageAmpCPU | FLOAT | ZZZ,ZZZ.999 | Returns the average number of AMP CPU seconds used by QueryCount. |
| ParserCPUTime | FLOAT | ZZZ,ZZZ.999 | Returns the total parser and dispatcher CPU time in seconds used for the query. |
| AverageParserCPU | FLOAT | ZZZ,ZZZ.999 | Returns the average number of CPU seconds used in the parser by QueryCount. |
| AMPCPUTimeNorm | FLOAT | ZZZ,ZZZ.999 | Returns the 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 | Returns the 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 | Returns 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 | Return IO Tokens used by the requests that are logged in summary mode. |
| ReqPhysIO | FLOAT | ----,---,---,---,--9.999 | Returns the total number of Physical I/Os for the whole request in summary mode. |
| ReqPhysIOKB | FLOAT | ----,---,---,---,--9.999 | Returns the total Physical I/Os in kilobytes for the whole request in summary mode. |
| StartTime | TIMESTAMP(6) | YYYY-MM-DDBHH:MI:SS.S(6) | Records the timestamp of the first query included for this summary row. |
| StopTime | TIMESTAMP(6) | YYYY-MM-DDBHH:MI:SS.S(6) | Record the timestamp of the last query included for this summary row. |
| UserName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the name of the userid, if any, under which the user submitted the query. |
| ProfileName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the name of the profile, if any, under which the user submitted the query. |