Purpose
Sets the algorithm used by DBQL to collect CPU and input/output statistics.
DBQL CPU/IO collection captures performance data for the execution of a query at the request level and, optionally, at the step level. It includes several options for specifying the data that is collected. For more information, see BEGIN QUERY LOGGING in SQL Data Definition Language.
Field Group
General
Valid Settings
| Setting | Description |
|---|---|
| 0 | Indicates DBQL CPU/IO Collection has not yet been explicitly set. In this case, DBQL uses the default collection algorithm. |
| 1 | DBQL uses Algorithm 1, the classic algorithm with step adjustments. This is the default. |
| 2 | DBQL uses AMP Algorithm 2. For most situations, this algorithm provides improved collection over Algorithm 1. Algorithm 2 is used primarily for certain types of diagnostic analysis. |
| 3 | DBQL uses Algorithm 3. Captures data for aborted and parallel steps, step instances for iterative steps, and includes additional information and status about step and request execution over Algorithms 1 and 2. |
Default
1
Changes Take Effect
After the DBS Control Record has been written.