If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back  dBforums > Database Server Software > DB2 > SQL1031N The database directory cannot be found on the indicated file system.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
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
  #2 (permalink)  
Old
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 2,361
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
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,713
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.
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Mar 2010
Posts: 13
SQL1031N The database directory cannot be found on the indicated file system

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
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,713
Quote:
Originally Posted by shashankj View Post
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.
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
  #6 (permalink)  
Old
Registered User
 
Join Date: Mar 2010
Posts: 13
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
Reply With Quote
  #7 (permalink)  
Old
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,713
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).
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
  #8 (permalink)  
Old
Registered User
 
Join Date: Mar 2010
Posts: 13
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
Reply With Quote
  #9 (permalink)  
Old
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 2,361
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
ÿ/home/db2inst1/test2/db2inst1

SQLDBD02
ÿÿÿòSYSTEM_819_US
UTF-8
Reply With Quote
  #10 (permalink)  
Old
Registered User
 
Join Date: Mar 2010
Posts: 13
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On