Results 1 to 9 of 9
  1. #1
    Join Date
    Sep 2011
    Posts
    22

    Unanswered: How to view alternate server name/IP

    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?

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    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
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Sep 2011
    Posts
    22
    Thanks przytula..

  4. #4
    Join Date
    Sep 2011
    Posts
    22
    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??

  5. #5
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    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
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  6. #6
    Join Date
    Sep 2011
    Posts
    22
    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??
    Last edited by arunmahendran; 10-03-11 at 07:43.

  7. #7
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    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)
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  8. #8
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by arunmahendran View Post
    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??
    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).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  9. #9
    Join Date
    Apr 2012
    Posts
    1

    Via JDBC?

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

    Quote Originally Posted by przytula_guy View Post
    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

Posting Permissions

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