How to Run Repotools with a SQL Trace Turned on

Technote (FAQ)


Question

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

Cause

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.

Answer

To setup a SQL trace when running repotools:

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

    log4j.properties.repotools.sqltrace.txt

  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 log4j.properties=C:\Temp\log4j.properties.repotools.sqltrace.txt
  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 log4j.properties used by repotools easier to find. As of 4.0.5, it is in conf/repotools_log4j.properties. At the time of publishing this article, 4.0.5 has not yet been released. Check the jazz.net 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.0.1, 1.0.0.2, 1.0.1, 1.0.1.1, 1.0.1.2, 2.0, 2.0.0.1, 2.0.0.2, 2.0.1, 2.0.1.1, 3.0.1, 3.0.1.1, 3.0.1.2, 3.0.1.3, 3.0.1.4, 3.0.1.5, 3.0.1.6, 4.0, 4.0.0.1, 4.0.0.2, 4.0.1, 4.0.2, 4.0.3
Software Development Rational Requirements Composer 1.0, 2.0, 2.0.0.1, 2.0.0.2, 2.0.0.3, 2.0.0.4, 3.0.1, 3.0.1.1, 3.0.1.2, 3.0.1.3, 3.0.1.4, 3.0.1.5, 3.0.1.6, 4.0, 4.0.0.1, 4.0.0.2, 4.0.1, 4.0.2, 4.0.3

Rate this page:

(0 users)Average rating

Document information


More support for:

Rational Team Concert
Repository

Software version:

1.0, 1.0.1, 1.0.1.1, 2.0, 2.0.0.1, 2.0.0.2, 3.0, 3.0.1, 3.0.1.1, 3.0.1.2, 3.0.1.3, 3.0.1.4, 3.0.1.5, 3.0.1.6, 4.0, 4.0.0.1, 4.0.0.2, 4.0.1, 4.0.2, 4.0.3

Operating system(s):

Linux, Windows

Reference #:

1322003

Modified date:

2008-11-25

Translate my page

Machine Translation

Content navigation