Storage Checkpoints can be created by specifying one of the following options: online or offline. To create a Storage Checkpoint with the online option, the instance should be online and you must enable the LOGRETAIN, USEREXIT, and/or LOGARCHMETH1 database configuration parameters. For the offline option, the database should be offline.

During the creation of the Storage Checkpoint, the database is placed in suspended mode. You can roll back the entire database to an online or offline Storage Checkpoint. After the rollback is complete, you may roll the database forward to restore the database if you have used an online Storage Checkpoint.

To allow the easiest recovery, always keep the LOGRETAIN and/or USEREXIT database configuration parameters enabled, regardless of whether the database is online or offline when you create Storage Checkpoints.