How to get instance's server port?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mockey Chen - 08 Mar 2006 14:17 GMT

I want to get my db2 instance's listen port,
is there any command to retrieve this information?

Signature

Regards.
Mockey Chen
Email: mockey.chen@gmail.com

Reply to this Message

Mark A - 10 Mar 2006 04:16 GMT

>I want to get my db2 instance's listen port,
> is there any command to retrieve this information?

db2 get dbm cfg

Look for SVCENAME. If it is a number, then it is the port number. If it is a
name, look for the name in the /etc/services file (or Windows equivilent if
using Windows). The default is 50000.

Reply to this Message

Manoharan - 10 Mar 2006 10:58 GMT

Hi,

At the db2cmd prompt/shell enter the following command:

C:\Program Files\IBM\SQLLIB\BIN>db2 list node directory

Node Directory

Number of entries in the directory = 2

Node 1 entry:

Node name = ADMIN
Comment =
Directory entry type = LOCAL
Protocol = TCPIP
Hostname = adminserver
Service name = 50000

Node 2 entry:

Node name = SERVER
Comment =
Directory entry type = LOCAL
Protocol = TCPIP
Hostname = db2server
Service name = 50000

The above information will be displayed as per your server settings.

Thanks
manoharan

> I want to get my db2 instance's listen port,
> is there any command to retrieve this information?

Reply to this Message