DB2® Universal Database for OS/390® Version 7.1 Certification Guide

Set Log Suspend/Resume

The -SET LOG SUSPEND/RESUME command can be used to temporarily freeze all DB2 activity. It provides for a fast system level copy of an entire DB2 subsystem. A fast copy can be accomplished via ESS “Shark” FlashCopy or RVA Snapshot. These copies can be used for remote-site recovery or point-in-time recovery. When a -SET LOG SUSPEND command is executed, a system checkpoint is taken (non-data sharing only), log buffers are flushed, a log-write latch is obtained, the BSDS is updated with the highest written RBA, and a message will be issued to the console that DB2 update activity has been suspended. A -SET LOG RESUME command will release the log-write latch, delete the suspended message, and issue a log-resumed message.