Configuring a remote repository database for OS/400 and i5/OS
When you use a remote InterChange Server express repository
database on OS/400 or i5/OS, you must change certain settings for
tools that access the database. These changes include:
- Setting the database URL for Relationship Designer Express
- Setting the DBMS Type for the relationship
- Selecting the remote database driver for System Manager and
Database Connection Pools
Relationship Designer Express must know the URL location of the
database being used. To specify that, do the following:
- Open Relationship Designer Express.
- Select and right-click a relationship, or create a new relationship.
- Click Advanced Settings.
- Revise the DBMS string in the URL setting, as indicated in the
following:
- Original string: jdbc: db2: localhost/QWBIDFT44
- Revised string: jdbc: as400: <hostname>/QWBIDFT44
where <hostname> should be replaced with the actual
host name of the remote system where the remote repository resides.
- In the Type field for DBMS Settings, select IBM Toolbox for iSeries.
Finally, you must set the database driver for Database Connection
Pools. To do this, when creating or revising a database driver for
a connection pool residing on a remote database on iSeries, choose
IBM Toolbox for iSeries (Type 4) from the "Database driver" drop-down
menu in the Create new database connection dialog.
