The default mode for DBQL logging is set to Algorithm 3. If your environment uses a different mode, Teradata recommends switching to Algorithm 3. To switch to Algorithm 3, change DBS Control General field 64 DBQL CPU/IO Collection.
For details about DBQL CPU/IO Collection, see Teradata Vantage™ - Database Utilities, B035-1102.
- Switch the mode to Algorithm 3. Modify General (g) field 64:
dbscontrol m g 64 = 3
- Write the DBS control record for the change to take effect:
write