A DB2/400 Data Server corresponds to one DB2 Database installed on an AS/400 system, connected with a specific user account. This user will have access to libraries in this system that corresponding to Oracle Data Integrator's Physical Schemas created under the data server.
It is preferable to use a Type 4 JDBC Driver for DB2/400. Two drivers are recommended : The IBM JT/400, or the HiT JDBC/400 Driver. These drivers directly use the TCP/IP network layer and require no other components installed on the client machine.
It is also possible to connect through ODBC with the IBM Client Access component installed on the machine. This method does not have very good performance and does not support the reverse engineering and some other features. It is therefore not recommended.
This driver appears as a jt400.zip file you must copy into your Oracle Data Integrator installation directory's /drivers sub-directory. Oracle Data Integrator installs a default version of this driver, which is tested and validated with Oracle Data Integrator. This driver is free of charge.
To connect DB2/400 with a Java application installed on the AS/400 machine, IBM recommends that you use the JT/400 Native driver (jt400native.jar) instead of the JT/400 driver (jt400.jar). The Native driver provides optimized access to the AS/400, but works only from the AS/400.
To support seamlessly both drivers with one connection, Oracle Data Integrator provides the Oracle Data Integrator Driver Wrapper for AS/400. This wrapper connects through the Native driver if possible, otherwise it uses the JT/400 driver. It is recommended that you use this wrapper if running agents installed on AS/400 systems.
To install and configure the driver wrapper:
Check that the snpsdb2.jar file (The wrapper package) is installed as a driver for all machines. See Installing JDBC / JMS drivers for more information.
In Topology Manager, change the driver and URL to your AS/400 server with the following information:
Driver: com.sunopsis.jdbc.driver.wrapper.SnpsDriverWrapper
URL: jdbc:snps400:<machine_name>[;param1=valeur1[;param2=valeur2...]]
For the Oracle Data Integrator installations on AS/400 systems, set the following java properties in the agent startup command, then restart the agent:
HOST_NAME: comma separated list of AS/400 host names for the current machine.
HOST_IP: IP Address of the current machine.
To set properties for an agent started with the JAVA CL command, you can take example from the following syntax example.
JAVA CLASS('oracle.odi.Agent') +
PARM('-SECU_DRIVER=com.ibm.as400..access.AS400JDBCDriver' ... '-PORT=20910') +
CLASSPATH('/ODI/LIB/odi.zip:/ODI/DRIVERS/snpsdb2.jar:/ODI/DRIVERS/jt400native.jar'...) +
... +
PROP((HOST_NAME 'HAL,HALM,HALW,HALE') (HOST_IP '192.168.0.13'))
Note that the snpsdb2.jar (driver wrapper) and jt400native.jar (Native Driver) files are in the classpath, and we have specified the properties in the last line.
If starting the agent using the UNIX shell script, just edit the odiparams.sh as below:
ODI_ADDITIONAL_JAVA_OPTIONS="-DHOST_NAME=HAL,HALM,HALW,HALE -HOST_IP=192.168.0.13"
For all driver parameters, refer to JDBC Drivers Samples.
This driver is similar to the JT/400 driver. It is licensed separately from Oracle Data Integrator. For more information, see www.hitsw.com.
You must ask the system administrator the following information:
Network Name or IP address of the AS/400 system.
Login and password of an AS/400 User.
To create a DB2/400 Data Server:
Connect to Topology Manager
Select Topology > Physical Architecture > Technologies > IBM DB2/400 in the tree.
Right click and select Insert Data Server
Fill in the following fields in the Definition tab:
Name: Name of the Data Server that will appear in Oracle Data Integrator.
User/Password: AS/400 user (with its password), having at least select privileges on the data libraries, and select/insert/object creation on the work libraries that will be indicated in the Physical Schemas created under this data server.
Fill in the following fields in the JDBC tab, according to the driver used:
If using IBM JT/400 Driver
JDBC Driver: com.ibm.as400.access.AS400JDBCDriver
JDBC URL: jdbc:as400://<network name or IP address of the AS/400 machine>
If using HiT JDBC/400 Driver
JDBC Driver: hit.as400.As400Driver
JDBC URL: jdbc:as400://<network name or IP address of the AS/400 machine>
Click Test.
Click Test in the Test Connection windows.
A window indicating a Successful Connection appears. Click OK. If the connection is not successful, please refer to Common Errors with DB2/400.
Click OK to validate the creation of the data server
The creation window for the first Physical Schema
for this data server appears.
See Creating a DB2/400 Physical Schema