467,189 Members | 1,330 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,189 developers. It's quick & easy.

How to get instance's server port?

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

--
Regards.
Mockey Chen
Email: mo*********@gmail.com
Mar 10 '06 #1
  • viewed: 24200
Share:
2 Replies
"Mockey Chen" <mo*********@google.com> wrote in message
news:du**********@news.yaako.com...
I want to get my db2 instance's listen port,
is there any command to retrieve this information?

--
Regards.
Mockey Chen
Email: mo*********@gmail.com


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.
Mar 10 '06 #2
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

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

--
Regards.
Mockey Chen
Email: mo*********@gmail.com


Mar 10 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

21 posts views Thread by Alexander N. Spitzer | last post: by
5 posts views Thread by lazydb2dba@yahoo.com | last post: by
28 posts views Thread by (Pete Cresswell) | last post: by
2 posts views Thread by GreyAlien007 | last post: by
10 posts views Thread by Mike Collins | last post: by
7 posts views Thread by jane | last post: by
reply views Thread by Jacques M | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.