DB2 UDB commands
We use the following commands:
set write suspend
The suspend command (db2 set write suspend for database) suspends all write operations to the DB2 UDB database (i.e., to tablespaces and log files). Read operations are not suspended and are thus allowed to continue. Applications can continue to process insert, update, and delete operations utilizing the DB2 bufferpools. A database connection is required for issuing the suspend command. It is recommended that you maintain the current session for executing the subsequent resume command.
set write resume
The resume command (db2 set write resume for database) resumes all write operations to the suspended DB2 UDB database. A database connection is required for issuing the resume command.
db2inidb
The db2inidb command (db2inidb <db_alias> as < snapshot standby mirror >) is required to initialize the copy of the suspended database. You do not require a database connection prior to executing this command. It can be used in the following three cases:
•snapshot can be applied to the secondary copy, putting it into a transactionally consistent state.
•standby can be applied to the secondary copy, putting it into a rollforward pending state. DB2 logs from the primary database can then be applied to the secondary database.
•mirror can be applied to the primary copy after it has been restored from the secondary copy. The primary database will be placed into a rollforward pending state and then DB2 logs can be applied to the primary database.
restart write resume
The restart write resume command (db2 restart db <db_alias> write resume) can be utilized to resume write operations on a suspended database that experienced an abnormal termination.
For further information regarding DB2 UDB’s suspended I/O functionality, see the DB2 UDB documentation and Release Notes provided with V7.2 or V7.1 Fixpack 3 at http://www.ibm.com/cgi- bin/db2www/data/db2/udb/winos2unix/support/v7pubs.d2w/en_main. In addition, see the DB2 Developer Domain article entitled Split Mirror Using Suspended I/O in DB2
DB2 UDB commands | 2 |
