Migrating from Derby to DB2

Steps to change the Jazz™ Team Server database from Derby to DB2®.
About this task
This assumes 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.
  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.

Feedback

Did this help? You can provide feedback at Jazz.net (registration required): Comment in the forums or submit a bug