Installation step 23: Back up the Db2 directory and catalog: DSNTIJIC

For backup purposes, create a copy of the Db2 directory and catalog.

About this task

Attention: If you do not create this copy, Db2 can start. However, if errors that require you to reinstall Db2 occur in the directory or catalog and you do not have backup copies, you lose all your tables and data.
Recommendation: Copy the catalog and directory at least daily if you make any changes in them. Recovery time for these databases is longer if the copies are not current, and the entire subsystem is affected.

Procedure

To create an image copy of the directory and catalog:

  1. Examine job DSNTIJIC for the following information:
    • Start of changeThe device type or unit name.

      The default value is SYSDA. If this is incorrect for your site, correct it.

      End of change
    • Expiration date or retention period. You can add a retention period or an expiration date to the job.
    • The user on the JOB statement. Ensure that the user is authorized. If Db2 is started under ACCESS(MAINT), this must be the same user that you specified for either the SYSTEM ADMIN 1 option or the SYSTEM ADMIN 2 option on installation panel DSNTIPP1.
  2. Run job DSNTIJIC.

    The DSNTIJIC job contains a list of all the Db2 directory and catalog table spaces. Start of changeWhen you run job DSNTIJIC, it invokes the Db2 image copy utility to copy these table spaces to disk or tape, depending on the value that you select for IC DATA SET UNIT NAME field.End of change Having copies of table spaces enables you to recover the Db2 catalog and Db2 directory in case of a failure.

  3. Start of changeIf the DSNTIJIC job fails or abends, verify that no problems exist with the tape or disk setup for image copy. If you find no problems with the setup, examine the utility job output (JOBLOG) or the console log for problems. For example, look for I/O errors or incorrect sizes.End of change

What to do next

Run the DSNTIJIC job periodically, perhaps daily or weekly, to reduce the amount of time required for recovering the directory or catalog. The copied data and log data sets are needed for recovery.