asked on

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

BigSchmuh

You must re-catalog your db (and remove the duplicated post)

mamun_90

ASKER

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

BigSchmuh

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

mamun_90

ASKER

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

ASKER CERTIFIED SOLUTION

BigSchmuh

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

sachinwadhwa

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ghp7000

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