BACKODUR is the system parameter that controls BACKOUT DURATION (DSNZPxxx: DSN6SYSP BACKODUR). It is specified as a number between 0 and 255, with a default value of 5. The value you specify for BACKOUT DURATION is your indication of how many log records are to be read during restart's backward log scan.
The BACKOUT DURATION field is a multiplier of the value you specify for the number of log records per checkpoint value (the CHECKPOINT FREQ field on DSNTIPN). Use this combination of values to ensure that short-duration URs are handled during restart rather than being postponed.
BACKODUR indicates how much of the log to process for backout when LIMIT BACKOUT = YES or AUTO. During restart, backward log processing continues until both (1) all inflight and inabort URs with update activity against the catalog or directory are backed out and (2) the number of log records processed is equal to the number specified in BACKODUR multiplied by the number of log records per checkpoint. If the checkpoint frequency type is minutes (instead of number of log records), then a default value of 50,000 log records will be used.
So, with that background, specifying a BACKODUR value of 0 will negate the second condition for stopping backward log processing during restart (that is, 0 log records).
Dig Deeper on IBM DB2 management
Related Q&A from Craig S. Mullins
Our expert suggests that the best way to pass the SAP BW exam is to have hands-on job experience. But that's not all he has to say about ... Continue Reading
To export data from a DB2 table to a flat file, you need to run an export specifying the proper file format. The export utility exports data from a ... Continue Reading
Craig Mullins recommends two specific resources for learning how to create and support Binary Large Objects (BLOB) in DB2. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.