LIMIT BACKOUT field (LBACKOUT subsystem parameter)
The LBACKOUT subsystem parameter specifies whether Db2 postpones backward-log processing for some units of work.
| Acceptable values: | AUTO, YES, LIGHT, LIGHTAUTO, NO |
|---|---|
| Default: | AUTO |
| Update: | option 42 on panel DSNTIPB |
| DSNZPxxx: | DSN6SYSP LBACKOUT |
- AUTO
- Db2 postpones some backout processing, but automatically starts the backout processing when Db2 restarts and begins acceptance of new work. When Db2 is restarted with the LIGHT(YES) or LIGHT(NOINDOUBTS) option, Db2 ignores this setting and behaves as if LBACKOUT is set to NO.
- YES
- Db2 postpones backout processing for some units of work until the RECOVER POSTPONED command is issued. When Db2 is restarted with the LIGHT(YES) or LIGHT(NOINDOUBTS) option, Db2 ignores this setting and behaves as if LBACKOUT is set to NO.
- LIGHT
- Db2 postpones backout processing for some units of work until the RECOVER POSTPONED command is issued. When Db2 is restarted with the LIGHT(YES) or LIGHT(NOINDOUBTS) option, it creates but does not process postponed-abort units of recovery (URs). The URs are not processed until the RECOVER POSTPONED command is issued on a normal Db2 restart.
- LIGHTAUTO
- Db2 postpones some backout processing, but automatically starts the backout processing when Db2 restarts and begins acceptance of new work. When Db2 is restarted with the LIGHT(YES) or LIGHT(NOINDOUBTS) option, it creates but does not process postponed-abort URs. The postponed-abort URs are automatically processed after a normal Db2 restart.
- NO
- Specifies that Db2 backward-log processing should process all inflight and in-abort units of recovery (URs).
If you specify AUTO, YES, LIGHT, or LIGHTAUTO, backout processing runs concurrently with new work. Sets or partitions with pending backout work are unavailable until their backout work is complete.