Category: Query
Database: DBC
| View Column | Data Type | Format | Comment |
|---|---|---|---|
| UserName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Returns the name of the user associated with the rule. |
| AccountString | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Returns the specific account for the user with a DBQL rule, or blank if all account strings apply. |
| ApplName | CHAR(30) LATIN NOT CASESPECIFIC NOT NULL | X(30) | Returns the name of the application. |
| TypeOfRule | VARCHAR(22) UNICODE NOT CASESPECIFIC | X(22) | Indicates whether logging is enabled or disabled by this rule. |
| ExplainFlag | VARCHAR(1) UNICODE NOT CASESPECIFIC | X(1) | The following codes are used: T = Explain text is stored in DBC.DBQLExplainTbl F = No Explain text is provided. |
| ObjFlag | VARCHAR(1) UNICODE NOT CASESPECIFIC | X(1) | are stored in DBC.DBQLObjTbl, F = No object data. |
| SqlFlag | VARCHAR(1) UNICODE NOT CASESPECIFIC | X(1) | SQL text is stored in DBC.DBQLSqlTbl: T (yes), F (no). |
| StepFlag | VARCHAR(1) UNICODE NOT CASESPECIFIC | X(1) | The following codes are used: T = Step-level data is stored in DBC.DBQLStepTbl, F = Step-level data is not provided in DBC.DBQLStepTbl. |
| XMLPlanFlag | VARCHAR(1) UNICODE NOT CASESPECIFIC | X(1) | Indicates whether XML query plan logging is on or off. These are the values: T = On, F = Off. |
| StatsUsageFlag | VARCHAR(1) UNICODE NOT CASESPECIFIC | X(1) | StatsUsage: T = Statistics usage will be stored, F = No statistics usage. |
| Verbose | VARCHAR(1) UNICODE NOT CASESPECIFIC | X(1) | Verbose: T = Verbose details provided, F = No verbose details provided |
| DetailedStats | VARCHAR(1) UNICODE NOT CASESPECIFIC | X(1) | DetailedStats: T = Statistics details provided, F = No Statistics details provided |
| NoColumns | VARCHAR(1) UNICODE NOT CASESPECIFIC | X(1) | NoColumns: T = Column Details are not logged, F = Column Details are logged |
| SummaryFlag | VARCHAR(1) UNICODE NOT CASESPECIFIC | X(1) | The following codes are used: T = Summary information is stored in DBC.DBQLSummaryTbl, F = Data is not summarized. |
| ThresholdFlag | VARCHAR(1) UNICODE NOT CASESPECIFIC | X(1) | T (queries shorter or equal to SummaryVal1 in DBC.DBQLSummaryTbl, detailed data on long queries in DBC.DBQLogTbl), F (detailed data for all queries in DBC.DBQLogTbl unless SummaryFlag is True) |
| ObjectUsage | VARCHAR(1) UNICODE NOT CASESPECIFIC | X(1) | ObjectUsage: T = Object use counts will be collected, F = No Object use count collection. |
| ParamFlag | VARCHAR(1) UNICODE NOT CASESPECIFIC | X(1) | Param: T = Parameters and values will be stored, F = No parameter logging. |
| FeatureUsage | VARCHAR(1) UNICODE NOT CASESPECIFIC | X(1) | FeatureUsage: T = Feature usage will be collected, F = No Feature usage logging. |
| UtilityInfoFlag | VARCHAR(1) UNICODE NOT CASESPECIFIC | X(1) | Indicates whether utility information will be collected. |
| TextSizeLimit | INTEGER | --,---,---,--9 | Returns the number of characters of SQL text to be stored in the DBQLogTbl. |
| SummaryVal1 | SMALLINT | ---,--9 | If Summary or Threshold are T, values <= SummaryVal1 in Elapsed, CPU or IO, |
| SummaryVal2 | SMALLINT | ---,--9 | Group 2: SummaryVal1 < values <= SummaryVal2 in Elapsed, CPU or IO, |
| SummaryVal3 | SMALLINT | ---,--9 | Group 3: SummaryVal2 < values <= SummaryVal3 in Elapsed, CPU or IO, & 4: larger than SummaryVal3 in Elapsed, CPU or IO. |
| LockDelay | INTEGER | --,---,---,--9 | Returns the information if the LockDelay is captured as part of the DBQL query logging rule(renamed to LockDelay). |
| AlgMode | BYTEINT | -(3)9 | The DBQL CPU/IO Collection Algorithm to use for this rule. |
| TypeOfCriterion | VARCHAR(22) UNICODE NOT CASESPECIFIC | X(22) | Returns a criterion used for Summary or Threshold. |
| DetailDiag | INTEGER | --,---,---,--9 | Detail Diagnostic flags |