Another way to reduce recovery time for all types of recovery operations is to force the writing of an ENDJ checkpoint instead of a COMT for long-running database sessions that periodically commit their changes. This is especially useful for long running sessions that infrequently perform a burst of updates and then issue a commit. Forcing an ENDJ reduces recovery time because less data has to be examined to locate the start of a recovery unit. This can benefit all types of recovery: warmstart, automatic recovery, and manual recovery.
To force the writing of an ENDJ during commit operations, specify ON COMMIT WRITE ENDJ on the SYSTEM or TASK statement in the system definition or specify this dynamically using the DCMT VARY TASK or DCMT VARY DYNAMIC TASK commands.
Note: There is no need to specify this for system run units, since an ENDJ checkpoint is always written when they are committed.
|
Copyright © 2014 CA.
All rights reserved.
|
|