Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655

    Unanswered: check if db2 is listening to the connection port

    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

  2. #2
    Join Date
    Jan 2010
    Posts
    335
    Something like
    select value from sysibmadm.DBMCFG where name='svcename'
    ?

  3. #3
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    thanks

    this is good.

  4. #4
    Join Date
    Nov 2011
    Location
    Shen Zhen,China
    Posts
    37
    The remote connection listeners are
    enabled when the DB2COMM registry variable and the appropriate Database Manager Configuration
    parameters are set

  5. #5
    Join Date
    Nov 2011
    Location
    Shen Zhen,China
    Posts
    37
    db2 list node directory also will tell u which port is the remote listening on

  6. #6
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •