check if db2 is listening to the connection port

DBFinder · #1 (**permalink**) 12-19-11, 10:26

Hi everybody,

Is there any provision to find if db2 is listening to a port for connections on a remote server via client connection.

I know and am used to check this at system level. But for current requirement, I have only client, I know it is connected, but for documentation purpose I want to know if there is any provision to find by querying catalog tables or DB2 registery.

Thanks
DBFinder

nvk@vhv · #2 (**permalink**) 12-19-11, 10:48

Something like
select value from sysibmadm.DBMCFG where name='svcename'
?

DBFinder · #3 (**permalink**) 12-19-11, 10:58

thanks

this is good.

wolaos123 · #4 (**permalink**) 12-19-11, 11:14

The remote connection listeners are
enabled when the DB2COMM registry variable and the appropriate Database Manager Configuration
parameters are set

wolaos123 · #5 (**permalink**) 12-19-11, 11:15

db2 list node directory also will tell u which port is the remote listening on

DBFinder · #6 (**permalink**) 12-19-11, 20:32

wolaos123,

In case I do not have permissions to anything except the db2 client, I am looking for a way to tell on which port db2 is listening for incoming connections. DB2 is on production server, but client is on other machine. I am connected to the server already.

nvk@vhv has got my point.

Code:

NAME         VALUE
------------ ------------
svcename     db2fasp

From this I can tell that the server that I am connected to is listening to this service name. Now, I am unable to convert this to numeric port number because /etc/services is on remote server where I do not have access.

Anybody having any Idea ??

Purpose is to tell which port number is on the remote server that DB2 is listening to.

Regards
DBFinder

Internet Services

Web Development

Digital Marketing

Consumer Tech