SQL1031N The database directory cannot be found on the indicated file system. How to fix this.

I am using IBM DB2 6.1 on Windows NT 4.0 SP 6.

There are two databases LIBSRVRN and OBJSRVRN. I see only the folder d:\db2\node0000\sql00002. But I cannot see the folder d:\db2\node0000\sql00001.

How to solve this problem.

Mamun
mamun_90Asked:
Who is Participating?
 
BigSchmuhCommented:
The folder sql00002 is gone and you don't have a backup....I have a very bad news for you.

Once I had one of my team member who inadvertendly move the db data root dir while the db was closed, we almost had the same error in fact...
You must first retrieve this directory from your NT explorer or restore it from a backup.

hth
0
 
BigSchmuhCommented:
You must re-catalog your db (and remove the duplicated post)
0
 
mamun_90Author Commented:
I tried to re-catalog the db but no success. Can any one explain if the folder d:\db2\node0000\sql00001 is missing will it be possible to fix the problem?

This is a serious problem for me. can anyone help me?

Mamun
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
BigSchmuhCommented:
If you don't see the folder from your NT explorer, you will not be able to catalog the db.

This means you may first try to see if some files are in this directory with the correct permissions settings.
Can you tell us where do those files in the sql00002 dir comes from ? (restore, copy, old db)

hth
0
 
mamun_90Author Commented:
There were two folders in D:\DB2\node0000. one was sql00001 and another was sql00002. After compuer restart i could only see sql00002 folder. But  did not see the folder sql00001.

I did nothing ( restore or copy or old db)

Please answer me.

Mamun
0
 
sachinwadhwaCommented:
SQLxxxx folder contains db2 database...if you miss them...you can restore from backup (if you have one....)

are you sure u have checked your recycle bin and searched for SQL00001 (may be you might have moved it?)

try using undelete command/utilities available...
0
 
ghp7000Commented:
if you dont see the folder then you or somebody else dropped the database
or
you deleted the database folder (check recycle bin)
or
the database folder is not on drive d, it is on another drive
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.