IBM Support

How to Run Repotools with a SQL Trace Turned on

Technote (FAQ)


How can you setup a SQL trace when running repotools in IBM Rational Team Concert (RTC)?


The upgrade script may have failed, or you need to run additional trace to debug repotools commands. Enabling trace may also be helpful if repotools crashes or hangs when running a command.


To setup a SQL trace when running repotools:

  1. Copy the following text file into your environment. For example, copy it into C:\Temp.

  2. Run the repotools command with the following parameters. This example is for the -createTables function, and the log4j file has been copied to C:\Temp:

    repotools -createTables logFile=C:\temp\repotools.log\Temp\
  3. Running repotools with the above log4j settings will produce a repotools_create.log including tracing details.

NOTE: In RTC 4.0.5, Online migration not logging messages (278570) made the used by repotools easier to find. As of 4.0.5, it is in conf/ At the time of publishing this article, 4.0.5 has not yet been released. Check the Downloads page for 4.0.5 once it has been released.

Leverage the Jazz Community

The Jazz based products have an active community that can provide you with additional resources. Browse and contribute to the User forums, contribute to the Team Blog and review the Team wiki.
Refer to technote 1319600 for details and links.

Cross reference information
Segment Product Component Platform Version Edition
Software Development Rational Quality Manager 1.0,,, 1.0.1,,, 2.0,,, 2.0.1,, 3.0.1,,,,,,, 4.0,,, 4.0.1, 4.0.2, 4.0.3
Software Development Rational Requirements Composer 1.0, 2.0,,,,, 3.0.1,,,,,,, 4.0,,, 4.0.1, 4.0.2, 4.0.3

Document information

More support for: Rational Team Concert

Software version: 1.0, 1.0.1,, 2.0,,, 3.0, 3.0.1,,,,,,, 4.0,,, 4.0.1, 4.0.2, 4.0.3

Operating system(s): Linux, Windows

Reference #: 1322003

Modified date: 25 November 2008