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. See also the information about the BEGIN QUERY LOGGING statement in SQL Data Definition Language Syntax and Examples, B035-1144.
Field Group
General
Valid Settings
| Setting | Description |
|---|---|
| 0 | Indicates DBQL CPU/IO Collection has not yet been explicitly set. DBQL uses the default collection algorithm. |
| 1 | DBQL uses Algorithm 1, the classic algorithm with step adjustments. |
| 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. This is the default. |
Default
3
Changes Take Effect
After the DBS Control Record has been written.