Changing qualifiers for other databases and user data sets

You can change qualifiers for Db2 databases other than the catalog and directory.

Before you begin

DSNDB07 is a system database that contains no permanent data, and can be deleted and redefined with the new qualifier. If you are changing the qualifier for DSNDB07, do that before changing the rest of the user databases.

About this task

You can change the databases in the following list that apply to your environment:
  • DSNDB07 (work file database)
  • DSNDB04 (system default database)
  • DSNRLST (resource limit facility database)
  • DSNRGFDB (the database for data definition control)
  • Any other application databases that use the old high-level qualifier

At this point, the Db2 catalog tables SYSSTOGROUP, SYSTABLEPART, and SYSINDEXPART contain information about the old integrated user catalog alias. To update those tables with the new alias, you must use the following procedures. Until you do so, the underlying resources are not available.

Important: Table spaces and indexes that span more than one data set require special procedures. Partitioned table spaces can have different partitions allocated to different Db2 storage groups. Nonpartitioned table spaces or indexes only have the additional data sets to rename (those with the lowest level name of A002, A003, and so on).