Thursday, March 13, 2008

How to find DB2 port for communications

In JDBC configurations for WPA, you have to specify the port that DB2 is listening on. I usually look for /etc/services or try one of 50000/50001 and it usually works. In SUSE Linux, both the solutions did not work and there was another process (Multithreaded routing toolkit aka mrt) was listening on port 50000.

So how do we find out the DB2 port in a reliable way? Read on...

Step 1: Set the DB2 environment.
$ . \db2inst1/sqllib/db2profile

No comments: