Managing Db2 for z/OS databases before upgrading IBM Engineering Lifecycle Management

Each new Engineering Lifecycle Management (ELM) version or release updates the data model to change the database schema for Jazz® Team Server and the ELM applications by using the repository tools addTables command. The upgrade process tags the repository with a version and release number, which means that it can be used only with that version and release. You must ensure that you have adequate backups for the tables in case there is an error and you must roll back the data. In addition to any tools you might have, IBM also provides tools for using Db2 for z/OS UNLOAD and LOAD to create a backup copy. It is important to understand that just generating the DDL from the existing tables and loading the current data into them might not be sufficient, as the repository tools -createTables process creates the tables, inserts data into some tables, and establishes links between tables. Table owner names might be different between instances of the database.

About this task

It is critical that the backup and restore process for the data is understood and tested before any upgrade. Testing the backup and restore process also creates a set of duplicate tables that can be used to test the upgrade process itself, preferably in a separate subsystem.

The upgrade cannot be rolled back without a repository backup.

Procedure

  1. To back up your ELM database with the Db2 for z/OS utilities, you can use the created backup database to restore your database if you have any problems during an upgrade from one version of ELM to another.
    1. Unload the database and use the unloaded data sets to create a backup database.
      1. Run the UNLOAD process. To do so, follow the instructions in Running UNLOAD and LOAD processes on Db2 to create a backup database.
      2. Ensure that you meet your database prerequisites.

        You must have the correct user name and password and your user ID must have correct Db2 for z/OS authority. Test the addTables process on a system with an ID that has the same authority and is configured in the same way from a Db2 perspective. The DBADM authority is not sufficient because the addTables process runs DROP VIEW, which requires additional authority. See Setting up Db2 for z/OS to use with Jazz Team Server.

    2. Back up any other Db2 or third-party programs, if necessary.
      Important: Use the programs and JCL samples that are provided in the HRCC703 FMID to back up all the required programs. If you do not, some required programs might be missing from the backup.
  2. To restore your ELM database with the Db2 for z/OS utilities, complete the following tasks:
    1. Reload the database to a different Db2 subsystem or a different database name and schema prefix.

      Run the LOAD process to reload a new or existing set of Db2 for z/OS tables. To do so, follow the instructions in Running UNLOAD and LOAD processes on Db2 to create a backup database.

    2. Restore any other Db2 or third-party programs, if necessary.
      Important: Use the JCLs that are provided in the HRCC703 FMID to restore all the required programs. If you do not, some required programs might be missing.

Results

You are now ready to upgrade the ELM version. See Upgrading IBM Engineering Lifecycle Management and all its embedded pages.