View Single Post
  #1 (permalink)  
Old 03-19-10, 21:22
shashankj shashankj is offline
Registered User
 
Join Date: Mar 2010
Posts: 13
SQL1031N The database directory cannot be found on the indicated file system.

Hi,

I see error below when I try to connect to database:

db2inst1@test15:~/sqllib> db2 connect to HATEST
SQL1031N The database directory cannot be found on the indicated file system.
SQLSTATE=58031
db2inst1@test15:~/sqllib>
db2inst1@test15:~/sqllib> db2 list database directory

System Database Directory

Number of entries in the directory = 1

Database 1 entry:

Database alias = HATEST
Database name = HATEST
Local database directory = /DB2/db2inst1
Database release level = d.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname = test15.db2test.com
Alternate server port number = 60000

db2inst1@test15:~/sqllib>


Setup Info:
I am trying to configure DB2 HA
I am shared GPFS filesystem as /DB2 on both machines.
I have created required users in same directory and also installed DB2 in same directory so that it is accessible from both machines.

Now, I am able to connect to above database from machine A but I see error above on machine B.

My db2conf.cfg file has below content:
0 test14.db2test.com 0
1 test15.db2test.com 0

How to fix this error?

Thanks and Regards,
-Shashank
Reply With Quote