Repository tools command for adding or updating database tables

Edit online

Use the addTables command to migrate a database to a newer release.

Purpose

The addTables command is used to add or update tables in an existing database. This command is used when a Jazz-based application is migrated to a newer release, or when a component that includes database schemas is provisioned into a Jazz-based application. The addTables command also performs an online migration command in the background for the Change and Configuration Management application. For more information about the online migration command, see Repository tools command to run an online migration.
Important: You must shut down the server before you run the command.
Note:
  • The -addTables command changes the data in your database. Make sure you have a backup before running this command.
  • Should the -addTables command fail for any reason, you must restore your data using the last good backup before rerunning the command.

Parameters

Attribute Description Required Default
teamserver.properties Path to the teamserver.properties file. No conf/application/teamserver.properties

where application is jts, ccm, rm, qm, gc, dcc, or relm.
logFile Path to the log file. No repotools-application_addTables.log

where application is jts, ccm, rm, qm, gc, dcc, or relm.
noPrompt Do not prompt before updating the tables. No N/A
checkOnly Evaluate the migration without making any changes to the database. No N/A

Example

The following example is for Jazz® Team Server. To use this command for other applications, run these options from the server directory:
  • IBM® Engineering Workflow Management (Change and Configuration Management application): repotools-ccm
  • IBM Engineering Requirements Management DOORS® Next (Requirements Management application): repotools-rm
  • IBM Engineering Test Management (Quality Management application): repotools-qm
  • Global Configuration Management: repotools-gc
  • Data Collection Component: repotools-dcc
  • IBM Engineering Lifecycle Optimization - Engineering Insights: repotools-relm

For Windows operating system Open a command prompt and enter this command:

cd C:\Program Files\IBM\JazzTeamServer\server\
repotools-jts.bat -addTables teamserver.properties=conf\jts\teamserver.properties

For Unix operating systems Open a command line and enter this command:

cd /opt/IBM/JazzTeamServer/server/
./repotools-jts.sh -addTables teamserver.properties=conf/jts/teamserver.properties