How can we see the alernate server name/IP set during HADR configuration,
using "db2 update alternate server for database <db_name> using hostname <standby public NIC IP> port <prt no>" command?

Database 20 entry:

Database alias = BWPRCSDB
Database name = BWPRCSDB
Local database directory = /home/db2inst1
Database release level = c.00
Comment = BatchWebsphereProcessServer
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname = pdb201.cbss.inet
Alternate server port number = 50001

(0)[db2inst1@plx00006 work]$ db2 list db directory

Thanks przytula..

Hi.. one more question, do we set the client traffic IP( ip on which client communicates) during HADR configuration.

or any IP on that node which is accessible by client can connect to the database??

do we need to set the port number for on which client communicates??

not on server
the client receives this alternate info after first connect
if type4 connection - this alternate info has to be specified as options on the connection string

In the last question, I haven't asked about the specifically about alternate server ip. My question was, do we need to configure any thing(IP, Port num) on DB2 for the client to communicate to the database?

If no, how does DB2 listen to the port and IP??

have a look at some doc
TCP/IP worksheet for configuring a client to server connection
there is a chapter for server and client - how to configure for communications (first lesson in db2 course)

The port number is specified in the database manager (instance) configuration. db2 get dbm cfg. There may be a service name instead of port number, in which case you look in /etc/services to resolve (or Windows equivalent).

Does Anyone know is there a way to get that Alternate server and port from within JDBC 4 connection?