Updating the BSDS with the new qualifier

Update the first BSDS with the new alias and correct data set names for the active logs. In this step, you do not attempt to change the names of existing archive log data sets.

Before you begin

If these catalog entries or data sets will not be available in the future, copy all the table spaces in the Db2 subsystem to establish a new recovery point. You can optionally delete the entries from the BSDS. If you do not delete the entries, they will gradually be replaced by newer entries.

Procedure

To update the BSDS:

  1. Run the change log inventory utility (DSNJU003).
    Use the new qualifier for the BSDS because it has now been renamed. The following example illustrates the control statements required for three logs and dual copy is specified for the logs. This is only an example; the number of logs can vary and dual copy is an option. The starting and ending log RBAs are from the print log map report.
    NEWCAT VSAMCAT=newcat
    DELETE DSNAME=oldcat.LOGCOPY1.DS01
    DELETE DSNAME=oldcat.LOGCOPY1.DS02
    DELETE DSNAME=oldcat.LOGCOPY1.DS03
    DELETE DSNAME=oldcat.LOGCOPY2.DS01
    DELETE DSNAME=oldcat.LOGCOPY2.DS02
    DELETE DSNAME=oldcat.LOGCOPY2.DS03
    NEWLOG DSNAME=newcat.LOGCOPY1.DS01,COPY1,STARTRBA=strtrba,ENDRBA=endrba
    NEWLOG DSNAME=newcat.LOGCOPY1.DS02,COPY1,STARTRBA=strtrba,ENDRBA=endrba
    NEWLOG DSNAME=newcat.LOGCOPY1.DS03,COPY1,STARTRBA=strtrba,ENDRBA=endrba
    NEWLOG DSNAME=newcat.LOGCOPY2.DS01,COPY2,STARTRBA=strtrba,ENDRBA=endrba
    NEWLOG DSNAME=newcat.LOGCOPY2.DS02,COPY2,STARTRBA=strtrba,ENDRBA=endrba
    NEWLOG DSNAME=newcat.LOGCOPY2.DS03,COPY2,STARTRBA=strtrba,ENDRBA=endrba 

    During startup, Db2 compares the newcat value with the value in the system parameter load module, and they must be the same.

  2. Using the IDCAMS REPRO command, replace the contents of BSDS2 with the contents of BSDS01.
  3. Run the print log map utility (DSNJU004) to verify your changes to the BSDS.
  4. At a convenient time, change the DD statements for the BSDS in any of your offline utilities to use the new qualifier.