Repository tools command to drop database tables

Edit online

Use the dropTables command to drop the database tables.

Purpose

The dropTables command is used to drop the database tables.

Important: You must shut down the server before you run the command.

Parameters

Attribute Description Required Default
teamserver.properties The file system 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_dropTables.log

where application is jts, ccm, rm, qm, gc, dcc, or relm.
noPrompt Causes the database tables to be dropped without confirmation from the user. This option is useful when writing automated scripts. 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 -dropTables teamserver.properties=conf/jts/teamserver.propertie

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

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