Configuring the physical database resource

After a physical database is created, you can configure the details of the physical database.

Procedure

  1. Open the Physical View of IBM® Rational® Integration Tester’s Architecture School perspective.
  2. Double-click the database to configure. The Database dialog is displayed.
  3. Configure the Connection details, as follows:
    Table 1. Fields for database connection details
    Field Description
    Maximum Number of Connections Enter the maximum number of database connections from Rational Integration Tester that are to be available in the pool. If you leave this field blank, it defaults to 1. You might increase the value if you run multiple tests that use the same database resource concurrently.
    Driver Enter the driver details for the specified database type, or select one of the included drivers from the drop-down list if listed.
    Note: The list displays only some of the common drivers and is not listed based on the drivers that you add to the database libraries in the Library Manager.
    Database URL Enter the connection URL for the database, or modify the default URL after you select one of the included drivers. For more information on the specification of database URLs when using IP literal addresses, see IP literal address.
    The following table lists the connection URL patterns that are supported by Rational Integration Tester:
    Table 1. Supported URL patterns
    Database driver URL pattern
    IBM DB2 Universal jdbc:db2://hostName:port/databaseName
    IBM DB2 Alias jdbc:db2:db_alias
    IBM DB2 iSeries jdbc:as400://hostName/defaultSchema
    Derby jdbc:derby://hostName:port/databaseName
    Composite Software JDBC jdbc:compositesw:dbapi@hostName:port?domain=composite&dataSource=system&registerOutputCursors=true
    JDBC-ODBC Bridge jdbc:odbc:dataSourceName
    Microsoft SQL Server jdbc:sqlserver://hostName:port;databasename=databaseName
    Microsoft SQL Server jdbc:jtds:sqlserver://hostName:port/databaseName
    MySQL Connector/J jdbc:mysql://hostName:port/databaseName
    Oracle jdbc:oracle:thin:@hostName:port:sid
    Oracle jdbc:oracle:thin:@//hostName:port/sid
    Oracle jdbc:oracle:thin:@ldap(s)://hostName:port/[dn][attributes][scope][filter][extensions]
    Oracle jdbc:oracle:thin:@connectionDescriptor
    Example connection descriptor:
    (DESCRIPTION=           
    (LOAD_BALANCE=on)
    (ADDRESS_LIST=           
    (ADDRESS=(PROTOCOL=TCP)(HOST=host1) (PORT=1521))           
    (ADDRESS=(PROTOCOL=TCP)(HOST=host2)(PORT=1521)))           
    (CONNECT_DATA=(SERVICE_NAME=service_name)))
    PostgreSQL jdbc:postgresql://hostName:port/databaseName
    SQL Lite jdbc:sqlite:databaseName
    Sybase jTDS jdbc:jtds:sybase://hostName:port/databaseName
    Sybase jConnect jdbc:sybase:Tds:hostName:port/databaseName
    Username/Password Enter a valid user name and password combination to send when you are connecting to the database. Both fields support tags, but the menu is not supported in the Password field.
    Note: Click Test Connection to verify the connection details.
  4. If required, configure z/OS details, as follows:
    Note: The zOS tab is enabled only if the Database driver chosen is IBM DB2 Universal. For more information on the recording and virtualization of COBOL DB2® programs on z/OS®, see Testing with DB2 on z/OS systems.
    Table 3. Tabs for z/OS configuration
    Field Environments Description
    Subsystem - Host Alias Mappings CICS and MVS batch The entries added provide additional information that is needed to map compiled language DB2 events from a z/OS source to the appropriate JDBC connection.
    Each entry corresponds to a mapping between a Host Name Alias and a Subsystem ID.
    • The Host Name Alias is the fully qualified hostname of the z/OS machine where the database resides. Generally speaking, the Alias corresponds to the hostname in the Database URL for the JDBC connection.
    • The Subsystem ID is the unique identifier of the DB2 subsystem on the z/OS machine. This identifier does not correspond with the JDBC 'database' name in the Database URL. The DB2 subsystem roughly corresponds to an installed DB2 instance.
    DBRM locations CICS only The entries specify the locations of the DBRM files. For example, USER1.COBOL.DBRM.
    CADP Web URLs CICS only The entries added provide RIT with information to connect to the CADP Web application, for automatic configuration of CADP profiles needed for recording and virtualization of COBOL DB2 programs on z/OS. Select the Test Connection(s) button to validate the URLs.
    Recording/Stubbing Filters CICS only Specify the transaction ID, program name, compile unit, user ID, and application ID to be matched when you are recording the CICS region.
    • Rule matching is manged by using CADP profiles on the CICS region.
    • A CADP profile for each rule will be generated for each CICS regions listed in the CADP WebURLs tab.
    • Each rule must be specified on a new line.
    • The wildcard character * can be used at the end of any field value.
    • If a value for one of the fields is unspecified, it defaults to the * character.
    • The values of the Transaction ID and Compile Unit are case-sensitive.
    • Rules define the name of the generated CADP profile using ProfileName. If not specified a profile name will be automatically generated.
    • Each CADP Profile on the CICS region must have a unique name. Existing profiles of the same name on the region will be overwritten.
      Examples of rules are:
      ProfileName=PROF1,Program=RITSTATS,Transaction=*,CompileUnit=CmpA,UserID=USER1,APPLID=*
ProfileName=PROF2,Program=RITSTATS,Transaction=*,CompileUnit=CmpA,UserID=USER2,APPLID=*
Program=*,Transaction=RITL
Transaction=SSC1
Program=RIT*
    You can do the following actions in each field described in the table, except for Recording/Stubbing Filters:
    • To add a new entry, click Add.
    • To update an entry, select it, make changes to the values, and then click Update.
    • To delete an entry, select it and click Remove.
  5. For more information about the settings available under the Stub tab, see Setting up the schema used for stubbing a physical database.
  6. Configure the schemas and stored procedure filters, under Advanced tab, as follows:
    Table 4. Fields for Advanced details
    Field Description
    Schema Enter the name of a schema to limit retrieval to that schema (available only if the next option is disabled).
    Use Connection Username Enable this option to retrieve procedures only from the user’s schema (based on the user name/password supplied under the Settings tab).
    Catalog/Package Enter a catalog/package name to limit retrieval to only the procedures that are contained by the catalog/package.
    Procedure Enter a procedure name to retrieve only that specific procedure.
Feedback