Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2009
    Posts
    5

    Question Unanswered: SQL1031N- The Database directory cannot be found on the indicated file system

    Hello,

    I have created a system image of AIX5.3. All the DB2 installation and instance file systems were on the rootvg.

    This image has been restored on another AIX workstation and verified whether all the file systems has been created and all are fine. (both db2home directory and the Database file system directory)

    Now if i logon as db2 instance owner (which is db2adm) and try to start the DB, it is throwing error. And while tring to connect to DB, throwing error with SQL1031N- The Database directory cannot be found on the indicated file system.

    The only difference between the original server and the image restored server is the hostname and the ip address. Is this creating any issue on starting the DB?

    If anyone throws some light on this issue, it will be very much appreciated and helpful.

    Thanks in advance
    Regards,
    RASE

  2. #2
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338
    Hi Rase,
    Can you please inform the db2level output for both the source and the new server.

    Jayanta Datta
    DB2 UDB DBA
    IBM India, Global Delivery
    New Delhi

  3. #3
    Join Date
    Jan 2009
    Posts
    5
    db2level was same on both source and the target server (it is DB2 9.1 fixpack 2)

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Locate a file called db2nodes.cfg and change the host name as appropriate.

    The file should be located under <instance-home>/sqllib
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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