Quiescing a table space set

Use the Quiesce Table Space Set window to quiesce one or more table space sets. All of the referentially related table spaces, and LOB table spaces and base table spaces that are not part of the referential integrity set are quiesced.

A quiesce point is a valid point of consistency for recovery. You use this window to establish a quiesce point (the current log RBA) for one or more table spaces. When a quiesce point is taken, changed pages can be written to DASD and catalog table SYSIBM.SYSCOPY records the current RBA and the timestamp of the quiesce point. You use the quiesce point in other windows, such as recovering a table space. You can use the window to determine whether table spaces are in check pending, copy pending, or recovery pending status, and whether any I/O errors occur while accessing the table space data sets. A successful execution of quiesce usually indicates that you can create valid image copies of those table spaces. You can use the results of quiescing a table space to decide whether to execute the COPY utility step, or to obtain a common quiesce point for a set of referentially-related table spaces.

Authorities and privileges

To quiesce a table space:

  1. Open the Quiesce a Table Space window.

  2. Specify whether to write the changed pages from the table spaces to DASD. The default is yes, which means when you establish a quiesce point, DB2 writes the changed pages to DASD. If you select No, only the quiesce occurs. The changed pages are not written to DASD.

  3. Click OK to quiesce the table space.

Related information

Tips:

  1. If quiesce is run on a table space in copy pending, check pending, or recovery pending status, it terminates.
  2. The output of the quiesce is in the form of DSNUxxxI utilities information messages.
  3. Sample output:

    4.   
           DSNU000I   DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = TSLQ.STEP1
           DSNU050I   DSNUGUTC - QUIESCE TABLESPACE DSN8D51A.DSN8S51E
                                         TABLESPACE DSN8D51A.DSN8S51D
           DSNU477I . DSNUQUIA - QUIESCE SUCCESSFUL FOR TABLESPACE DSN8D51A.DSN8S51E
           DSNU477I . DSNUQUIA - QUIESCE SUCCESSFUL FOR TABLESPACE DSN8D51A.DSN8S51D
           DSNU474I . DSNUQUIA - QUIESCE AT RBA 000000052708
           DSNU475I   DSNUQUIB - QUIESCE UTILITY COMPLETE, ELAPSED TIME= 00:00:25
           DSNU010I   DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
     
  4. Running other utilities with quiesce:

    5.    | Action                                               | QUIESCE         |
       |______________________________________________________|_________________|
       | CHECK DATA                                           | No              |
       |______________________________________________________|_________________|
       | CHECK INDEX                                          | Yes             |
       |______________________________________________________|_________________|
       | COPY SHRLEVEL REFERENCE                              | Yes             |
       |______________________________________________________|_________________|
       | COPY SHRLEVEL CHANGE                                 | No              |
       |______________________________________________________|_________________|
       | LOAD                                                 | No              |
       |______________________________________________________|_________________|
       | MERGECOPY                                            | Yes             |
       |______________________________________________________|_________________|
       | MODIFY                                               | Yes             |
       |______________________________________________________|_________________|
       | QUIESCE                                              | Yes             |
       |______________________________________________________|_________________|
       | RECOVER                                              | No              |
       |______________________________________________________|_________________|
       | REORG INDEX                                          | No              |
       |______________________________________________________|_________________|
       | REORG TABLESPACE                                     | No              |
       | UNLOAD CONTINUE or PAUSE                             |                 |
       |______________________________________________________|_________________|
       | REORG TABLESPACE                                     | Yes             |
       | UNLOAD ONLY                                          |                 |
       |______________________________________________________|_________________|
       | REPORT                                               | Yes             |
       |______________________________________________________|_________________|
       | RUNSTATS                                             | Yes             |
       |______________________________________________________|_________________|
       | STOSPACE                                             | Yes             |
       |______________________________________________________|_________________|
     
     

[Return to main task]