Prerequisites

Before you create a DB2 Loader connection to write to DB2, be sure to complete the prerequisites.

Install the DB2 Loader JDBC driver and DB2 client

To write data to DB2 databases, you need to install the DB2 Loader JDBC driver and DB2 client on the Secure Agent machine.

To install the driver, perform the following steps:

1To get the DB2 Loader JDBC driver, contact Informatica Global Customer Support.
2Create the informatica.db2loader folder manually in the following directory based on whether the Secure Agent machine is a Windows or a Linux machine:

Secure Agent machine	Directory
Linux	<Secure Agent installation directory>/ext/connectors/thirdparty/informatica.db2loader
Windows	<Secure Agent installation directory>\ext\connectors\thirdparty\informatica.db2loader

To install the DB2 LUW client, perform the following steps:

1Download and install the DB2 LUW client and instance from the IBM website.
2Set the following environmental variables based on whether the Secure Agent machine is a Windows or a Linux machine:

Secure Agent machine	Environmental variable
Linux	- setenv DB2INSTANCE <DB2 instance directory> - setenv DB2CLP DB20FADE - setenv PATH <DB2 client directory>/bin - setenv LD_LIBRARY_PATH <DB2 client directory>/lib64
Windows	setenv DB2CLP DB20FADE

After you install the DB2 Loader JDBC driver and set the environmental variables, you need to restart the Secure Agent.