Backup and Recovery of the DB2 Catalog and Directory

Since the DB2 catalog and directory are also comprised of table spaces and index spaces, they can fall subject to failures, such as a media failure. There may be instances where these objects need to be recovered.

There is a specific order to recovering catalog data sets, due to relationships and dependencies in the catalog. This order is as follows:

  1. DSNDB01.SYSUTILX

  2. SYSUTILX indexes

  3. DSNDB01.DBD01

  4. DSNDB06.SYSCOPY

  5. SYSCOPY (3) indexes (IBM only)

  6. DSNDB01.SYSLGRNX

  7. SYSLGRNX Indexes

  8. DSNDB06.SYSDBAUT

  9. SYSDBAUT (3) indexes (IBM only)

  10. DSNDB06.SYSUSER

  11. DSNDB06.SYSDBASE

  12. SYSDBASE indexes (IBM only)

  13. SYSUSER (3) indexes (IBM only)

  14. All other catalog and directory table spaces and indexes

  15. Catalog indexes (user-defined)

  16. System ...

Get DB2® Universal Database for OS/390® Version 7.1 Certification Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial