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