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

What about local db directory, does it exist on this path?
db2 list db directory on /DB2/db2inst1


You may also check:
db2 list db directory on /DB2

I am curious. Who told you to code the db2conf.cfg the way you have it? I thought for a shared disk HA system, you have to change the db2conf.cfg when you fail-over, but it contains only one server at a time. But I am not an expert on shared disk HA clusters for DB2, so I would like to know where that is documented.

Hi Bella / Marcus,

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

Local Database Directory on /DB2/db2inst1/
Number of entries in the directory = 1
Database 1 entry:
Database alias = HATEST
Database name = HATEST
Database directory = SQL00001
Database release level = d.00
Comment =
Directory entry type = Home
Catalog database partition number = 0
Database partition number = 0

db2inst1@test15:~>


I couldn’t find the exact URL where I got this info. I was searching a lot on google and doing modifications.

Actually I didn’t get a good doc which is useful to configure DB2HA in my environment.
Can you suggest me a doc / correct approach to configure DB2HA on shared filesystem?

Thanks and Regards,
-Shashank

You don't remember where you found the instructions to modify the db2nodes.cfg and put two hostnames in it? I have never seen that before (but that does not mean it is wrong). I have only seen multiple entries at one time in the db2nodes.cfg for DPF or for the new PureScale (9.8) clustering implementations.

I would be interested in seeing some documentation on what you are doing if you get it to work that way.

Hi Marcus,

I got the link. I have referred HA DB2 (Partitioned Database) using Tivoli System Automation for db2node.cfg file configuration.

Any idea, about the steps required / flow of installation - configuration for DB2HA.

Thanks and Regards,
-Shashank

That article describes HA using DPF (Database Partitioning Feature), which is an extra cost feature that needs to be licensed on top of ESE. DPF is really designed for data warehouses using parallel query access, but can be used for HA. However, since the advent of HADR, not many people would use DPF for high availability. There is a more simple solution you can configure using shared disk, but I don't have any doc on that (you could probably google it).

Hi All,

Any idea how can I fix the issue?

Does anybody have any doc / link to configure Db2 HA using db2haicu on shared filesystem.

Your response is appriciated.

Thanks and Regards,
-Nilesh

I believe here is where you can find the latest docs:

http://download.boulder.ibm.com/ibmd...2_db2haicu.pdf
http://www.redbooks.ibm.com/redbooks/pdfs/sg247363.pdf



I'm not about db2haicu, but verify if you have the following structure (if /DB2/db2inst1/ is your local db directory):
/DB2/db2inst1/<instance name>/NODE0000/sqldbdir/<db dir files>


Here is an example of what I have:

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

Local Database Directory on /home/db2inst1/test2

Number of entries in the directory = 1

Database 1 entry:

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



db2inst1@p6db2serv /home/db2inst1/test2/db2inst1/NODE0000/sqldbdir > ls -l
total 24
-rw-rw-r-- 1 db2inst1 build 1512 Feb 25 18:06 sqldbbak
-rw-rw-r-- 1 db2inst1 build 1512 Feb 25 18:06 sqldbdir
-rw-rw-r-- 1 db2inst1 build 540 Feb 25 18:05 sqldbins



db2inst1@p6db2serv /home/db2inst1/test2/db2inst1/NODE0000/sqldbdir > strings sqldbdir
DB2 DIRECTORY
TEST2
TEST2
2SQL00001
&#255;/home/db2inst1/test2/db2inst1

SQLDBD02
&#255;&#255;&#255;&#242;SYSTEM_819_US
UTF-8

Thanks Bella. The links were useful. I could configure DB2HA.

Now I am facing some issue while testing DB2 cluster.

I have rebooted both machines. After that I see below output of ‘lssam’ command.

db2inst1@test15:~> lssam
Failed offline IBM.ResourceGroup:db2_db2inst1_0-rg Binding=Sacrificed Nominal=Online
|- Offline IBM.Application:db2_db2inst1_0-rs Binding=Sacrificed
|- Failed offline IBM.Application:db2_db2inst1_0-rs:test14 Node=Offline
'- Offline IBM.Application:db2_db2inst1_0-rs:test15
'- Offline IBM.ServiceIP:db2ip_9_1_69_84-rs Binding=Sacrificed
|- Failed offline IBM.ServiceIP:db2ip_9_1_69_84-rs:test14 Node=Offline
'- Offline IBM.ServiceIP:db2ip_9_1_69_84-rs:test15
db2inst1@test15:~>

db2inst1@test14:~> lssam
Online IBM.ResourceGroup:db2_db2inst1_0-rg Nominal=Online
|- Unknown IBM.Application:db2_db2inst1_0-rs
|- Unknown IBM.Application:db2_db2inst1_0-rs:test14
'- Failed offline IBM.Application:db2_db2inst1_0-rs:test15 Node=Offline
'- Online IBM.ServiceIP:db2ip_9_1_69_84-rs
|- Online IBM.ServiceIP:db2ip_9_1_69_84-rs:test14
'- Failed offline IBM.ServiceIP:db2ip_9_1_69_84-rs:test15 Node=Offline
db2inst1@test14:~>

db2inst1@test14:~> cat sqllib/db2nodes.cfg
0 test14 0 test14
db2inst1@test14:~>

What may be issue?

Thanks and Regards,
-Shashank