Setting Up DB2 connection String in Informatica

Please subscribe on my YouTube Channel.

1. You need to Install 64 bit client - ibm_data_server_client_winx64_v11.1 
2. Configure windows variables
1. SET DB2CODEPAGE=437
2. SET DB2HOME=C:\Program Files\IBM\SQLLIB
3. SET DB2INSTANCE=DB2
4. SET LIB=C:\Informatica\9.6.1\server\bin
5. SET LIBPATH=C:\Informatica\9.6.1\server\bin
6. SET PATH=C:\Informatica\9.6.1\server\bin\;C:\PROGRA~1\IBM\SQLLIB\BIN;C:\PROGRA~1\IBM\SQLLIB\FUNCTION
7. Execute db2cmd -i -w db2clpsetcp
3. Catalog DB2 databases: run the following commands from command line.

db2 catalog tcpip node <node name> remote <host> server <port>

db2 catalog db <database name> at node <node name>