Database connections from Rational Team Concert

Technote (FAQ)


Question

How does IBM Rational Team Concert (RTC) initiate connections to the database?

Cause

It is important to understand how connections are being made from the application to the database when implementing database tuning.

Answer

Activities like opening a work item will create a connection to the DB, but ultimately, it is the services within the server that will initiate the database connections.

A task that the user does might use a number of services, which in turn might use a number of transactions, thus making a connection for each transaction. Connections are not made to the database when a user logs in, but rather when a service requests a connection.

The database connections will wait a maximum of 3000 ms before becoming idle. In RTC versions pre 4.0, the idle connections are not dropped. New connections are added until the JDBC Connection pool is full, and at that point, the idle connections are reused by new services. The JDBC Connection Pool Size is by default 128 as per RTC Advanced properties.

As of RTC 4.0, connections will be dropped automatically instead of just being reused. This feature was addressed in Enhancement 187509 and Enhancement 158197.

To learn more about Tuning the RTC Server JDBC Connection settings, review the following articles:

Tuning the RTC 4.0 Server
Tuning the RTC 3.0 Server


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.


Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Rational Team Concert
Repository

Software version:

3.0.1

Operating system(s):

Linux, Windows

Reference #:

1587379

Modified date:

2012-11-22

Translate my page

Machine Translation

Content navigation