Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2012
    Posts
    177

    Unanswered: How to add the db2nodes.cfg entries for four databases under one instance

    In our setup we have 1 test, 1 dev Redhat Linux boxes.

    Db2 has been installed for both the servers by using the response file installation has been done for 2nd server.


    Testing server is the primary server, Dev is the secondary server.

    For testing server we are having two instances:

    db2inst1
    db2inst2


    Only one port is enabled For db2inst1 50000
    we have four databases namely
    TIS_STG,
    TIS_DWH for Test and
    TIS_STG, TIS_DWH for Dev these databases comes under MPP setup.


    Queries:

    1) How to make the dbnodes.cfg entries for the both the servers under instance db2inst1?

    2) If i am creating the database under primary server i am able to connect the database, but for the secondary server list the db is working fine
    but i can't able to connect the database?

    Error msg:

    [db2inst1@vrdtisdbhcl02 ~]$ db2 connect to TIS_DWH
    SQL1031N The database directory cannot be found on the indicated file system.
    SQLSTATE=58031

    Could you please give me the suggestions.

    Thanks,
    laxman

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    SQL1031N The database directory cannot be found on the indicated file system.
    SQLSTATE=58031
    this message has not todo with db2nodes.cfg
    db2nodes.cfg is a special file that will be used for dpf
    which db is partitioned on which machine ?
    the message you get is another problem
    try db2 list db directory and db2 list db directory on /path
    to find all existing db
    you can catalog a missing db2
    see infocenter for all details on commands....
    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

Posting Permissions

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