RTCz: Migrating from Derby to DB2

Steps to change the Jazz™ Team Server for System z database from Derby to DB2®.
These instructions assume 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 you use the repotools version that matches your target server.
  1. Stop the Jazz Team Server for System z.
  2. Backup the database using the database commands. This 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®, and repotools.bat for Windows® are packaged in the directory JazzInstallDir/server. The following is an example 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.
These steps are completed on z/OS and assume that you have already created the Jazz Team Server for System z DB2 database and you are using Tomcat.
  1. Stop the Jazz Team Server for System z.
  2. Edit the sample member BLZEXPO2 in hlq.SBLZSAMP following the instructions contained in the JCL. The output .tar file from this step will serve 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