Thursday, February 28, 2008

DB2: Remote Client Connection

I had a hard time connecting to a DB2 server after the remote client was installed. I'm not an expert on DB2, so I decided to notate this for others.

-From a command prompt, export a environment variables needed to run:

export DB2INSTANCE=db2inst1
export INSTHOME=/export/home/db2inst1

-Run DB2 and set the database catalog to the remove connection:


db2 => CATALOG TCPIP NODE UNIQUENODENAME REMOTE 192.168.1.10 SERVER 50000;

-Now, set database name to connect through the new node:

db2 => catalog database mydatabase as mydatabase at node UNIQUENODENAME

-And finally, connect to the database:

db2 => connect to mydatabase user username using password

No comments: