Configuring the project results database for Rational Integration Tester

Historical test data and performance results from agents and probes are stored in the IBM® Rational® Integration Tester project results database. It is difficult to estimate the space that is required as the number and type of tests to be run varies. For example, lengthy performance tests can generate large amounts of data. When you create the project results database, 50GB is probably a good starting point.
The supported databases that can be configured and used as the project results database for IBM Rational Integration Tester are:

For information about the supported versions of the database, see the Supported Software > Database section in the System Requirements page.

Note: Multiple Rational Integration Tester projects can reside in the same database schema without impacting one other since the projects (and their artifacts) have unique keys.

After you install Rational Integration Tester, you can create the project results database in an existing, empty, and supported database. The required IBM DB2 and the Oracle JDBC drivers are installed with Rational Integration Tester, and connectivity is established later from all clients, including agents and probes.

Note: Some databases require that you configure JAR files in the database (JDBC) section of Library Manager. In addition, if you plan to view the project results database in IBM Rational Test Control Panel, copy the JAR files to the lib folder of the Rational Test Control Panel installation directory (for example, C:\Program Files\IBM\RationalTestControlPanel\lib).

The database creation scripts can be found in the scripts folder of the Rational Integration Tester installation directory (for example, C:\Program Files\IBM\RationalntegrationTester\scripts).

A script is provided for some of the supported database providers:

The appropriate script can be run against an empty database by a database administrator.

If you are a user of a project results database that is created by someone else, you must have the following permissions to work with the database:
Note: Rational Integration Tester provides full Unicode support. For example, test results (such as messages) that are stored in the results database can be in Unicode. When you create results databases, you must ensure that they support the storage of Unicode artifacts. Instructions for providing Unicode support are included in the instructions for creating Rational Integration Tester results databases.
  1. Creating the project results database by using IBM DB2
    You can create project results databases that are based on IBM DB2.
  2. Creating the project results database by using Oracle
    You can create a project results database that uses Oracle.
  3. Creating the project results database by using Microsoft SQL Server
    You can create project results databases by using Microsoft SQL Server.
  4. Creating the project results database by using MySQL
    You can create project results databases by using MySQL.
  5. Upgrading the project results database schema
    The following provides information about upgrading the schema version of your IBM Rational Integration Tester project results database, and illustrates the process with an example.
Feedback