Important
If a QUIESCE is needed for the index space, the table space that the index is associated with must be quiesced because the index space cannot be quiesced directly. (STARTRO on an index space and QUIESCE on its table space is used to establish consistency during initialization.) If the table space is COPY-pending status, it will not be quiesced unless it is being copied in the same group.
QUIESCE BEFORE and QUIESCE AFTER syntax diagram
These options are especially useful when you specify SHRLEVEL CHANGE. Quiescing within
Some content is unavailable due to permissions.
execution includes wait and retry logic for the Db2 QUIESCE utility, which results in the less manual intervention than retrying a failed Db2 QUIESCE job step. You can also use the WRITE option when specifying QUIESCE AFTER.
Some content is unavailable due to permissions.
automatically issues a QUIESCE at the beginning of a SHRLEVEL REFERENCE or CONCURRENT copy, unless the space is in COPY-pending status, regardless of whether you otherwise specify a QUIESCE option. The quiesce operation must complete successfully for the COPY phase to begin. For more information, see
Db2-commands-issued-by-BMC-AMI-Copy-for-read-and-write-databases.
For more information, see Using-the-SHRLEVEL-option. Also, Db2-commands-issued-by-BMC-AMI-Copy-for-read-and-write-databases describe table space status changes made by
Some content is unavailable due to permissions.
for various scenarios involving the use of the SHRLEVEL option.
Important
When you use the QUIESCE BEFORE option and the space or partition cannot be quiesced,
Some content is unavailable due to permissions.
issues the warning message BMC30127, continues with the copy processing, and issues a return code 4 if no other issues occur. However, if
Some content is unavailable due to permissions.
needs to issue a quiesce, and the space or partition cannot be quiesced,
Some content is unavailable due to permissions.
issues a return code 12. In cases where
Some content is unavailable due to permissions.
needs to issue a QUIESCE and the space is in COPY-pending status,
Some content is unavailable due to permissions.
first resets COPY-pending status, then issues the QUIESCE.
| |
|---|
| The WRITE option tells Db2 whether to, in addition to establishing a quiesce point, write the changed pages to DASD. | |
|---|
| WRITE YES is the default and tells Db2 to establish a quiesce point and write the changes pages for the table space and index space to DASD. | | Specify WRITE NO to tell Db2 to establish a quiesce point and to not write the changed pages to DASD. Important If QUIESCE BEFORE WRITE NO is coded, it is ignored, BMC47320I is issued, and Some content is unavailable due to permissions. does a QUIESCE BEFORE WRITE YES. |
|