If you are in a data sharing environment, and you need to recover the catalog and directory to a point in time before CATMAINT was run or a function level upgrade was performed, you need to follow a special procedure.
Procedure
- Create image copies of the Db2 catalog and directory.
- Determine the point in time to which you need to recover, which is called xxxxxxxx in this procedure.
- Run the following DIAGNOSE utility control statement to clear the catalog
and function level information from an internal control structure:
DIAGNOSE TYPE(0) REPAIR SET DBID(8) PSID(0000) RESET
Important: This control statement should be issued only as part of this procedure.
DBID(8) identifies an internal
control structure for system database information. It is not a Db2 catalog database or any physical database
provided by Db2.
- Stop all
members of the data sharing group, and issue the following SETXCF FORCE command to delete the
coupling facility structures for the data sharing group:
SETXCF FORCE,STRUCTURE,STRNAME=XXXX_SCA(sca-structure-name)
- If xxxxxxxx is prior to execution of the CATMAINT utility or activation of a function level, restore the BSDS from the most recent archived copy of the BSDS after LRSN xxxxxxxx, and before the CATMAINT or function level activation occurred. If that is not possible, take these actions:
- Restore the most recent BSDS prior to xxxxxxxx.
- Run DSNJU003 to update the archive log and active log information to include logs up to xxxxxxxx.
- Create a conditional restart control record (CRCR) with an ENDLRSN value of xxxxxxxx.
- For one member of the data sharing group, set the DEFER and ALL subsystem parameters, and start Db2 on that member with ACCESS(MAINT).
- Recover the catalog and directory table spaces without the TOLOGPOINT option in the RECOVER utility control statements. Rebuild the catalog and directory indexes with the REBUILD INDEX utility.
This step recovers the catalog and directory table spaces to the log truncation point of xxxxxxxx.
- Recover all user objects.
This step keeps the definitions of user objects synchronized with the information on those objects in the catalog or directory after CATMAINT was run or a function level upgrade was performed.
- Stop Db2 on the data sharing member on which you previously started Db2.
- Set the RESTART subsystem parameter, and start Db2 without the ACCESS(MAINT) option on the data sharing member on which you stopped Db2 in the previous step.
- Start Db2 on the other members of the data sharing group.