Creating recovery points and keeping the database quiesced

The UPDATE DB START(QUIESCE) OPTION(HOLD) command causes the database to become quiesced and keeps the database quiesced until an UPDATE DB STOP(QUIESCE) command is issued that releases the quiesce. While the database is quiesced, you can create image copies of the database data sets.

To create recovery points for low-activity databases:

Procedure

  1. Enter one of the following commands from IMS SPOC:
    Option Description
    UPDATE AREA NAME(area_name) START(QUIESCE) OPTION(HOLD) To quiesce a Fast Path area and establish a new recovery point and keep the area quiesced.
    UPDATE DB NAME(db_name) START(QUIESCE) OPTION(HOLD) To quiesce a full-function database and establish a new recovery point and keep the database quiesced.
    UPDATE DB NAME(HALDBmaster_name) START(QUIESCE) OPTION(HOLD) To quiesce a HALDB and establish a new recovery point and keep the HALDB quiesced.
    Note: When the quiesce function is invoked on a full-function HALDB, it affects all of the partitions of the HALDB. The command does not set the quiesce in progress flag on in the RECON data sets for the HALDB master. Instead it sets the quiesce in progress flag on in each HALDB partition.
    UPDATE DB NAME(DEDB_name) START(QUIESCE) OPTION(HOLD) To quiesce a Fast Path DEDB and establish a new recovery point and keep the database quiesced.
    UPDATE DATAGRP NAME(dbgrp_name) START(QUIESCE) OPTION(HOLD) To quiesce a database group and establish a new recovery point and keep the database group quiesced.
    The following IMS SPOC output is returned:
    DBName   MbrName    CC
DBXYZ    IM02        0
DBXYZ    IM01        0
DBXYZ    IM03        0
  2. Check that the command executed successfully. Enter the following command from IMS SPOC: QRY DB NAME(DBXYZ) SHOW(STATUS)
    IMS returns the following results:
    IMS SPOC output:
DBName    MbrName    CC TYPE     LclStat                                
DBXYZ     IM03        0 DLI      ALLOCS,OPEN,QUIESCED 
DBXYZ     IM01        0 DLI      ALLOCS,OPEN,QUIESCED
DBXYZ     IM02        0 DLI      ALLOCS,OPEN,QUIESCED
  3. Create an image copy of the database.
    Verify that the image copy completes successfully.
    The database should be successfully backed up.
  4. Enter one of the following commands to release the quiesce on the database, which is now successfully backed up.
    Option Description
    UPDATE AREA NAME(area_name) STOP(QUIESCE) To release the quiesce on a Fast Path area that was previously quiesced.
    UPDATE DB NAME(db_name) STOP(QUIESCE) To release the quiesce on a database that was previously quiesced.
    UPDATE DB NAME(HALDBmaster_name) STOP(QUIESCE) To release the quiesce on a HALDB that was previously quiesced.
    UPDATE DB NAME(DEDB_name) STOP(QUIESCE) To release the quiesce on a Fast Path DEDB that was previously quiesced.
    UPDATE DATAGRP NAME(dbgrp_name) STOP(QUIESCE) To release the quiesce on a database group that was previously quiesced.
    IMS SPOC returns the following output:
    DBName   MbrName    CC
DBXYZ    IM03        0
DBXYZ    IM02        0
DBXYZ    IM01        0
  5. Enter the following command to ensure that the quiesced database has been released successfully: QRY DB NAME(DBXYZ) SHOW(STATUS)
    IMS SPOC returns the following output:
    DBName    MbrName    CC TYPE     LclStat    
DBXYZ     IM03        0 DLI      ALLOCS,OPEN
DBXYZ     IM01        0 DLI      ALLOCS,OPEN
DBXYZ     IM02        0 DLI      ALLOCS,OPEN