Additional information and resources for IBM i DB2

• Refer also to Additional Considerations for Transformation Maps Using IBM i DB2.

• Depending which driver version you are using, the IBM JDBC Driver is implemented in the file jt400.jar or jt400Native.jar.  If it is not already present, you may need to copy the file to the /jar directory of your JSM instance and restart the Java Service Manager before using the driver with Transformation Maps in LANSA Composer.  The jt400.jar is supplied with the IBM i operating system can usually and can usually be found in an IFS folder such as //QIBM/ProdData/OS400/jt400/lib

• Refer to relevant IBM reference materials for more information on the JDBC drivers available for IBM i DB2 and the keywords and values that can be specified in the JDBC connection.  Following are some useful references. Note that some of these references relate to specific versions of IBM i and associated software. You should refer to the equivalent pages for the software versions you are using.

• IBM Toolbox for Java JDBC

• IBM Toolbox for Java JDBC properties

• IBM i - IBM Toolbox for Java: JDBC FAQ

• ConnectionStrings.com - Forgot that connection string? Get it here!

• IBM i Access Client Solutions

• Steps to download ACS Optional Package

Note:  When downloading ACS, an optional download is the IBM i Access Client Solutions - Win AP.  You must select, download and install this component as it contains the ODBC driver for Windows.