[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5167
  • Last Modified:

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
0
mamun_90
Asked:
mamun_90
2 Solutions
 
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
 
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
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
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
 
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
 
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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now