Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2010
    Posts
    1

    Exclamation Unanswered: DB2 Data Inaccessible After Instance Owner Password Expired

    Hi All,

    I am facing a strange problem with my database. Recently the database instance owner's password got expired. We noticed it some 3-4 days later and by that time the application had already tried connecting to the database for considerable number of times. Once we noticed it we did a password reset for the instance owner back to the old password. After that when I tried to connect to database I received the below error:

    "SQL1031N The database directory cannot be found on the indicated file system. SQLSTATE=58031"

    I, then googled and found a solution that Uncatalog database and then Catalog it again should fix the issue. Once I did the same I have started getting a new error "SQL1013N The database alias name or database name "XXXX" could not be found. SQLState=42705" for which I am not able to find any solution.

    I have tried using the Add Database wizard from db2 control center but it doesnt detect the particular database in instance owner home (though it finds & connects another database present in instance owner's home which wasn't automatically accessed by any app ever since the password expired).

    I have even tried restoring the instance owner home directory contents to an older time when the database was getting connected but the error stays the same.

    Please help! Thanks in anticipation!

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Do you see your db in the "db2 list db directory" and "db2 list db directory on <path>" output? Here is an example of what you should see:

    db2inst1@p6db2serv /home/db2inst1 > db2 list db directory

    System Database Directory

    Number of entries in the directory = 1

    Database 1 entry:

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


    db2inst1@p6db2serv /home/db2inst1 > db2 list db directory on /home/db2inst1

    Local Database Directory on /home/db2inst1

    Number of entries in the directory = 2

    Database 1 entry:

    Database alias = TEST
    Database name = TEST
    Database directory = SQL00002
    Database release level = c.00
    Comment =
    Directory entry type = Home
    Catalog database partition number = 0
    Database partition number = 0

    Database 2 entry:

    Database alias = HADR
    Database name = HADR
    Database directory = SQL00001
    Database release level = c.00
    Comment =
    Directory entry type = Home
    Catalog database partition number = 0
    Database partition number = 0


    db2inst1@p6db2serv /home/db2inst1/db2inst1/NODE0000/SQL00001 >

Tags for this Thread

Posting Permissions

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