Filter
Top Products
DB2 UDB commands
2
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