Only users with DBC or SystemFE privileges are able to use this view.
LockDelay
The LockDelay column returns the minimum elapsed time of a lock contention in centiseconds. Any lock contention greater than this time will be recorded in the DBC.DBQLXMLLockTbl table as specified in the BEGIN QUERY LOGGING WITH LOCK statement. The minimum LockDelay value is 5 centiseconds.
Possible Values for DetailedStats
| Value |
Description |
| T |
Detailed statistics are provided. |
| F |
Detailed statistics are not provided. |
Possible Values for ExplainFlag
| Value |
Description |
| T |
EXPLAIN text is logged. |
| F |
EXPLAIN text is not provided. |
Possible Values for FeatureUsage
| Value |
Description |
| T |
Feature usage information is collected. |
| F |
Feature usage information is not collected. |
Possible Values for NoColumns
The NoColumns column indicates if columns are logged as part of object logging. When query logging is enabled with the OBJECTS option, a separate row for each table and column referenced is added to the DBQL object table. With NoColumns set to T, the columns are not logged.
| Value |
Description |
| T |
Query logging is enabled without column logging. |
| F |
Query logging is enabled with column logging. |
Possible Values for ParamFlag
ParamFlag shows whether parameters and values are stored for parameterized requests.
| Value |
Description |
| T |
Query parameters and values are logged. |
| F |
Query parameters and values are not logged. |
Possible Values for ObjFlag
ObjFlag shows whether data (columns and indexes) are stored.
| Value |
Description |
| T |
Object data is logged. |
| F |
Object data is not logged. |
Possible Values for ObjectUsage
| Value |
Description |
| T |
Object use counts are logged. |
| F |
Object use counts are not logged. |
Possible Values for SQLFlag
| Value |
Description |
| T |
SQL text is logged. |
| F |
SQL text is not provided. |
Possible Values for StatsUsageFlag
| Value |
Description |
| T |
Statistics usage is logged. |
| F |
Statistics usage is not logged. |
Possible Values for StepFlag
| Value |
Description |
| T |
Step-level data is logged. |
| F |
Step-level data is not provided. |
Possible Values for SummaryFlag
| Value |
Description |
| T |
Summary information is logged. |
| F |
Summary information is not provided. |
Possible Values for ThresholdFlag
| Value |
Description |
| T |
Counts the queries that are shorter or equal to SummaryVal1 in DBC.DBQLSummaryTbl. Provides detailed data on longer queries in DBC.DBQLogTbl. |
| F |
Provides detailed data for all queries in DBC.DBQLogTbl unless the SummaryFlag is True. |
Possible Values for TypeOfCriterion
| Value |
Description |
| 0 |
ElapsedSec (Elapsed seconds) |
| 1 |
CPUTime (CPU time in centiseconds) |
| 2 |
IOCount (I/O count) |
| 3 |
CPUTimeNorm (Normalized CPU time in centiseconds for coexistence systems) |
| 4 |
ElapsedTime (Elapsed time in centiseconds) |
| 5 |
No logging criterion. |
Possible Values for TypeOfRule
- Logging enabled
- WITH NONE (No logging)
Possible Values for UtilityInfoFlag
| Value |
Description |
| T |
TASM utility statistics are logged. |
| F |
TASM utility statistics are not logged. |
Possible Values for Verbose
| Value |
Description |
| T |
Verbose EXPLAIN and related information in XML format are provided. |
| F |
Verbose EXPLAIN and related information in XML format are not provided. |
Possible Values for XMLPlanFlag
| Value |
Description |
| T |
XML query plans are logged. |
| F |
XML query plans are not logged. |
SummaryVal1, SummaryVal2, and SummaryVal3
| Column |
Description |
| SummaryVal1 |
Returns the high value for interval 1 if the SummaryFlag or ThresholdFlag columns are T. This value can be in seconds, CPU centiseconds, or I/Os.
|
| SummaryVal2 |
Returns the high value for interval 2 if the SummaryFlag or ThresholdFlag columns are T. This value can be in seconds, CPU centiseconds, or I/Os (see TypeOfCriterion).
|
| SummaryVal3 |
Returns the high value for interval 3 if the SummaryFlag or ThresholdFlag columns are T. The same value is used for interval 4.
This value can be in seconds, CPU centiseconds, or I/Os (see TypeOfCriterion).
|