IBM Rational Integration Tester can be configured with multiple databases for storing various information / Test Data / Performance Metric data which is received from multiple Probes and Agent components.
So, in order to store this historical data, its a good practice to create specific DB containing respective table and stored procedure information. However, there are not real specifications insisted, in terms of allocating space for this result database. The general practice is to have a 50GB starting point.
IBM Rational Integration Tester supports four types of the database from
- IBM DB2
- Microsoft SQL server
- MySQL databases
Note: For information about the supported versions of the database, see the Supported Software > Database section in the System Requirements page.
For Example, if you would like to create a project result database using IBM DB2, then you may follow the instructions outlined here. RIT by default does ship the requires scripts for creating the specific supported database. These scripts are located in the scripts folder of the Rational Integration Tester installation directory (for example, C:\Program Files\IBM\RationalntegrationTester\scripts)
These are some generic information when you consider the result databases to be associated or part of RIT. In some specific scenarios, you might be able to create the respective tables being part of the RIT result database, but during the course of creating stored procedures, you might encounter errors like below..
Error 2/16/2016 4:23:01 PM 0:00:00.124 <link> - DB2 Database Error: ERROR  [IBM][DB2/NT64] SQL0104N An unexpected token "CREATE OR REPLACE PROCEDURE INSERT_FLEX_COL" was found following "BEGIN-OF-STATEMENT". Expected tokens may include: "<space>". 5255 0
Error 2/16/2016 4:24:16 PM 0:00:00.000 <link> - DB2 Database Error: ERROR  [IBM][DB2/NT64] SQL0206N "P_PK" is not valid in the context where it is used. 5266 4
Probably in such case, you may explicitly launch the DB2 command line editor and connect to the RIT database which you have created. Once you are connected to this RIT DB, you may execute the respective script (Example: ghtester_db2_9.5.sql) . For more information on this approach of executing the scripts via DB2 Command editor, refer here.