Historical test data and performance results from agents and probes
are stored in the 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 are:
- IBM®
Db2®
- Oracle
- Microsoft SQL Server
- MySQL
For information about the supported versions of the database, see the section in Software Product Capability Reports.
Note: Multiple projects can reside in the same database schema without impacting one
another 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\RTCP\usr\servers\defaultServer\apps\RTCP.war\WEB-INF\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\RationalIntegrationTester\scripts).
A script is provided for some of the supported database providers:
- IBM
Db2:
ghtester_db2.sql
- Oracle: ghtester_oracle.sql
- Microsoft SQL Server:
ghtester_mssql.sql
- MySQL: ghtester_mysql.sql
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:
- INSERT, UPDATE, DELETE, SELECT on all the Rational
Integration Tester tables
- EXECUTE PROCEDURE
- SELECT SEQUENCE on the Rational
Integration Tester sequences for the Oracle databases
Note: To ensure that the Rational
Integration Tester results
database handles Unicode characters correctly, it must be configured to use UTF-8. Details on how to
do this are included in the instructions on creating the results database for each database
provider.
For managing test cycles, you must configure a project results database. For details on test
cycles, see Test cycles overview and management.