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!

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 >