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 01-18-09, 11:59
RASE RASE is offline
Registered User
 
Join Date: Jan 2009
Posts: 5
Question SQL1031N- The Database directory cannot be found on the indicated file system

Hello,

I have created a system image of AIX5.3. All the DB2 installation and instance file systems were on the rootvg.

This image has been restored on another AIX workstation and verified whether all the file systems has been created and all are fine. (both db2home directory and the Database file system directory)

Now if i logon as db2 instance owner (which is db2adm) and try to start the DB, it is throwing error. And while tring to connect to DB, throwing error with SQL1031N- The Database directory cannot be found on the indicated file system.

The only difference between the original server and the image restored server is the hostname and the ip address. Is this creating any issue on starting the DB?

If anyone throws some light on this issue, it will be very much appreciated and helpful.

Thanks in advance
Regards,
RASE
Reply With Quote
  #2 (permalink)  
Old 01-19-09, 05:11
JAYANTA_DATTA JAYANTA_DATTA is offline
Registered User
 
Join Date: Oct 2004
Location: DELHI INDIA
Posts: 336
Hi Rase,
Can you please inform the db2level output for both the source and the new server.
__________________

Jayanta Datta
DB2 UDB DBA
IBM India, Global Delivery
New Delhi
Reply With Quote
  #3 (permalink)  
Old 01-20-09, 13:03
RASE RASE is offline
Registered User
 
Join Date: Jan 2009
Posts: 5
db2level was same on both source and the target server (it is DB2 9.1 fixpack 2)
Reply With Quote
  #4 (permalink)  
Old 01-20-09, 13:25
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,196
Locate a file called db2nodes.cfg and change the host name as appropriate.

The file should be located under <instance-home>/sqllib
__________________
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
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