Example Database Connections for IBM DB2 for i5/OS
Note: example values and screens given in this section are based on particular database and driver software versions and configurations. They are provided for illustration and guidance. Your own environment may require different values and procedures.
You must be able to establish two types of connectivity to your IBM DB2 for i5/OS database for use with the mapping tool and the maps it generates:
- ODBC connection from the LANSA Composer client computer
While defining your map you need to be able to establish an ODBC connection to the IBM DB2 for i5/OS database on your IBM i server. . This connection is initiated from the client computer running MapForce. Refer to:
Connecting to IBM DB2 for i5/OS to define a Transformation Map
- JDBC connection from the LANSA Composer server computer
When the Transformation map runs, it will use a JDBC connection to establish the connection to the IBM DB2 for i5/OS database on your IBM i server. This connection is initiated from the server computer on which the transformation map executes and is defined in LANSA Composer by means of a Database Configuration. Refer to:
Connecting to IBM DB2 for i5/OS to execute a Transformation Map
For further important information concerning the use of IBM DB2 for i5/OS databases in Transformation Maps, please refer to:
Additional Considerations for Transformation Maps Using IBM DB2 for i5/OS