To connect IBM DB2, you will need to set up DB2 Runtime Client, here are the steps

1. Download and install IBM DB2 Runtime Client lite.
2. In DB2 CLP, Run “catalog tcpip node #NODE_NAME# remote #HOST ADDRESS# #PORT NUMBER#” to create instance alias. The node name cannot be more than 8 characters.
3. In DB2 CLP, run “list node directory” to verify the instance alias is created.

4. In DB2 CLP, Run “catalog database #DATABASE NAME# as #ALIAS_NAME# at node #NODE_NAME# authentication server” to create database alias.
5. In DB2 CLP, Run “list database directory” to verify the database alias is created.

6. In DB2 CLP, Run “connect to #ALIAS_NAME# user #USER NAME# using #PASSWORD#”
7. If connection is made successfully, you will see the connection information like this:

Database Connection Information

Database server = DB2/NT 8.2.9
SQL authorization ID = #####…
Local database alias = #####