Migrating from Derby to DB2

Steps to change the Jazz™ Team Server database from Derby to DB2®.

About this task

These instructions assume that you are migrating the database and not changing the version of your server at the same time. If you plan to migrate and change the server version, make sure that you use the repotools version that matches your target server.

Procedure

  1. Stop the Jazz Team Server.
  2. Back up the database using the database commands. Backing up the database is a precautionary measure in case something goes wrong.
  3. In the directory JazzInstallDir/server/conf/jazz, edit the file teamserver.db2.properties to ensure that the target properties accurately describe the DB2 database to which you are migrating. Review the contents of the file teamserver.properties and copy over any necessary changes to teamserver.db2.properties.
  4. Run repotools to copy the contents of the Jazz repository from the Derby database described by teamserver.properties to the DB2 database described by teamserver.db2.properties. The scripts, repotools.sh for Linux®, AIX®, and Solaris and repotools.bat for Windows® are packaged in the directory JazzInstallDir/server. The following example is a command using repotools. See the repotools documentation for more information.
    repotools -copy toFile=temp.tar target.teamserver.properties=teamserver.db2.properties
  5. Rename the file teamserver.properties in the directory JazzInstallDir/server/conf/jazz to teamserver.derby.properties.
  6. Rename the file teamserver.db2.properties in the directory JazzInstallDir/server/conf/jazz to teamserver.properties.
  7. Start the server.

What to do next

These steps run on z/OS and assume that you have already created the Jazz Team Server DB2 database and you are using Tomcat.
  1. Stop the Jazz Team Server.
  2. Edit the sample member BLZEXPO2 in hlq.SBLZSAMP following the instructions contained in the JCL. The .tar file output from this step serves as input to import the DB2 database. Submit this job.
  3. Rename the teamserver.properties in the @confPath@/jazz directory to teamserver.derby.properties. Rename teamserver_db2z.properties to teamserver.properties.
  4. Ensure that this teamserver.properties accurately reflects your DB2 configuration.
  5. Edit the sample member BLZIMPOR in hlq.SBLZSAMP following the instructions contained in the JCL. The input .tar file for this step is the output .tar from step 2. Submit this job.
  6. Edit the sample member BLZSRV1 in hlq.SBLZSAMP following the instructions contained in the JCL. Submit this job to start Tomcat using the DB2 database.

Feedback