DB2 Write Suspend

When doing a snapshot from a storage array, if the server contains a DB2 instance running, there is no certainty that the snapshot contains a consistent copy of the database.

To launch a snapshot and ensure consistent copy in DB2 is possible to put the database at “write suspend”, that is, it overrides the disk access in write mode, and work in the buffer pool memory. Queries whether it will record but writes are performed only in memory.

> db2 set write suspend for database

Once launched this command, you can make a snapshot that guarantees consistency.
To return to leave the database without “write suspend”:

> db2 set write resume for database

Although it would enter into another discussion, to recover the snapshot you should use db2initdb instruction:

> db2inidb database as snapshot