Connecting to a DB2 data source
iHub can connect from designs to IBM DB2 data sources on UNIX and Windows using run-time client version 9.1, 9.5, and 9.7. To connect to DB2 data sources, you must perform the following tasks:
Define appropriate environment variables.
Specify the database environment.
Supply an account name and password.
Specify the protocol your site uses.
Configure the DB2 client’s locale setting to match the locale of the machine.
The Actuate interface to DB2 clients supports DB2 stored procedures. The following limitations of DB2 stored procedures exist:
DB2 does not support large object (LOB) data types between versions. See the DB2 documentation for information about DB2 support for LOB data types.
You must bind the DB2 CLI packages from the client system to the DB2 server using db2cli.lst in some situations. For example, after you apply a Fix Pak to a client or server, or on a system where an Actuate design uses DB2 9.1 client software with a DB2 9.1 server.