Creating a point of consistency for catalog and directory objects

Full recovery of the catalog and directory table spaces and indexes is strongly recommended. However, if you need to plan for point-in-time recovery of the catalog and directory, you should create a point of consistency for the catalog and directory.

Procedure

To create a point of consistency for catalog and directory objects:

  1. Quiesce all catalog and directory table spaces, except for the following table spaces:
    • DSNDB06.SYSTSCPY
    • DSNDB01.SYSUTILX
    • Start of changeFL 509DSNDB01.SYSTSUTMEnd of change
    • Start of changeFL 509DSNDB01.SYSTSUTXEnd of change

    You can use the LISTDEF utility to group these table spaces into a single list and then specify that list in the QUIESCE statement.

  2. Quiesce DSNDB06.SYSTSCPY.
    Recommendation: Quiesce DSNDB06.SYSTSCPY in a separate utility statement. When you recover DSNDB06.SYSTSCPY to its own quiesce point, it contains the SYSCOPY records with ICTYPE = 'Q' (quiesce) for the other catalog and directory table spaces.
  3. Quiesce the remaining directory table space or spaces as follows:
    • If DSNDB01.SYSUTILX has not been converted to a UTS, quiesce it in a separate job step.
    • FL 509If DSNDB01.SYSUTILX has been converted to a UTS, quiesce DSNDB01.SYSTSUTM and DSNDB01.SYSTSUTX together in one QUIESCE statement.

What to do next

Later, if you need to recover to a point in time, recover the table spaces in steps 2 and 3 to their own quiesce points, and recover other catalog and directory table spaces to their common quiesce point. The catalog and directory objects must be recovered in the prescribed order for your version of Db2 for z/OS®.