Monday 22 June 2009

DB2 not appearing to listen

During my recent travails with WebSphere Portal and Lotus Forms Server, I hit a problem whereby DB2 UDB was installed and started, but didn't appear to be listening on any TCP/IP ports.

After some digging, I found that DB2 was not correctly set up to automatically listen, despite having the relevant entries in /etc/services.

In summary, I needed to ensure that I had the following: -

DB2_db2inst1 60000/tcp
DB2_db2inst1_1 60001/tcp
DB2_db2inst1_2 60002/tcp
DB2_db2inst1_END 60003/tcp

in /etc/services ( I'm using the 6000x port range but this could easily be another range such
as 5000x etc. ).

Having done this, I then needed to run the following three commands ( as the DB2 instance owner, db2inst1 ): -

DB2 UPDATE DATABASE MANAGER CONFIGURATION USING SVCENAME DB2_db2inst1
DB2SET DB2COMM=TCPIP
DB2START

( note that the first command uses the service name that's listed in /etc/services and may vary
from installation to installation )

Once I updated the DBM configuration and set the DB2 environment variable, all appeared to
be well.

2 comments:

Vance said...

Thanks!

Dave Hay said...

You're welcome, glad to be of assistance, Dave

Visual Studio Code - Wow 🙀

Why did I not know that I can merely hit [cmd] [p]  to bring up a search box allowing me to search my project e.g. a repo cloned from GitHub...