Renaming Db2 system data sets

Occasionally, you might want to rename the Db2 system table spaces

Procedure

To rename Db2 system data sets:

  1. Stop Db2 in a consistent state.
  2. Create a full system backup so that you can recover from operational errors.
  3. Execute the change log inventory utility with NEWCAT.
  4. Rename the BSDS and all Db2 directory and catalog table spaces and index spaces with IDCAMS.
  5. Reassemble DSNZPARM to redefine the high-level qualifier for the system table spaces.
  6. Update the BSDS name in the Db2 startup procedure.
  7. Start Db2.
  8. Drop and re-create the work file database.
  9. Optionally use the ALTER command for table spaces in DSNDB04 and user databases.