IBM Support

Creating a DB2 temporary tablespace for use with Rational Team Concert 2.0

Troubleshooting


Problem

This technote provides information about the creation of IBM DB2 tablepaces used by IBM Rational Team Concert 2.0.

Symptom

When running the repotools -createTables command after installing Rational Team Concert 2.0 with an IBM DB2 database, the command fails with an InternalRepositoryException error. The following stack trace is in the repotools command log:


    Caused by: com.ibm.team.repository.common.InternalRepositoryException:
    unable to build temp table
    at com.ibm.team.repository.service.internal.db.util
    .InListValueTempTableManager.build(InListValueTempTableManager.java:109)
    at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator
    .doQueryData(RdbRepositoryDataMediator.java:910)
    [...]
    Caused by: java.sql.SQLException: DB2 SQL Error: <b>SQLCODE=-286, SQLSTATE=42727, SQLERRMC=4096</b>;DB2ADMIN, DRIVER=3.53.70

Cause

By default, Rational Team Concert 2.0 server will use the SYSTOOLS temp tablespace if it is already created. Refer to the SYSTOOLSPACE and SYSTOOLSTMPSPACE table spaces topic in the DB2 Information Center, which describes the situations under which the SYSTOOLS temp space is created:
The usage of a pre-existing tablespace (like SYSTOOLS) created by another application could lead to unexpected problems or performance issues in Rational Team Concert due to differences in configuration and application usage needs.

To solve the problem, we need to have Rational team Concert use its own tablespace.

Diagnosing The Problem

  • Rational Team concert is version 2.0
  • Database is DB2
  • The message unable to build temp table appears in the log file.
  • The Database Administrator did not create a specific temporary tablespace for Rational Team Concert in DB2.

Resolving The Problem

To solve the problem, you can either migrate to a newer version than 2.0 or create a tablespace for Rational Team Concert.

Migration


The Jazz user temporary table space will be created automatically if you migrate to a newer version than 2.0 or if you are starting with a new installation.

Creating a new tablespace

If you are using Rational Team Concert 2.0 then you need to create a user temporary tablespace for Jazz to use with the name JAZZTMPSPACE.


Refer to the CREATE TABLESPACE topic in the DB2 Information Center for detailed instructions on creating a tablespace.

In the most simple situation (assuming automatic storage is enabled), the following DB2 command can be run:


    "create user temporary tablespace jazztmpspace managed by automatic storage"

Information for advanced Database Administrators


If you are only upgrading Rational Team Concert to a newer version than 2.0 and not migrating your data OR If you have already created the user temporary tablespace for Jazz:

Then you will need to create a user temporary tablespace with the name JAZZTMPSPACE as explained above, or you will need to use the new configuration property:
    "com.ibm.team.repository.db.db2.temp.tablespace.name" in the file teamserver.properties to set the name of your user temporary tablespace.

    Example: com.ibm.team.repository.db.db2.temp.tablespace.name=RTCTMPSPACE


Leverage the Jazz Community

Jazz and Rational Team Concert 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.


[{"Product":{"code":"SSUC3U","label":"IBM Engineering Workflow Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Repository","Platform":[{"code":"PF033","label":"Windows"},{"code":"PF016","label":"Linux"}],"Version":"2.0","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSUC3U","label":"IBM Engineering Workflow Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":null,"Platform":[{"code":"","label":null}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Product Synonym

Rational Team Concert

Document Information

Modified date:
16 June 2018

UID

swg21391062

Page Feedback