Repository tools command for adding or updating database tables

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.

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

video icon Video

Jazz.net channel
Software Education channel

learn icon Courses

IoT Academy
Skills Gateway

ask icon Community

Jazz.net
Jazz.net forums
Jazz.net library

support icon Support

IBM Support Community
Deployment wiki