SQL1031N The database directory cannot be found on the indicated file system.

zenith · #1 (**permalink**) 06-12-09, 13:53

Used the following command

Code:

db2 "connec to db user userid using passwd

Getting the following Error:
SQL1031N The database directory cannot be found on the indicated file system.
SQLSTATE=58031

Tried this.

Code:

db2 get dbm cfg | grep DFTDBPATH

gets nothing.

I am a developer not an admin.
What steps i have to take to resolve this issue

Cougar8000 · #2 (**permalink**) 06-12-09, 14:06

+ contact your DBA

Cougar8000 · #3 (**permalink**) 06-12-09, 14:08

db2 "? SQL1031N"

SQL1031N The database directory cannot be found on the indicated
file system.

Explanation:

The system database directory or local database directory could
not be found. A database has not been created or it was not
cataloged correctly.

The command cannot be processed.

User Response:

Verify that the database is created with the correct path
specification. The Catalog Database command has a path parameter
which specifies the directory where the database resides.

sqlcode : -1031

sqlstate : 58031

zenith · #4 (**permalink**) 06-12-09, 15:52

Quote:

Originally Posted by Cougar8000

db2 "? SQL1031N"

SQL1031N The database directory cannot be found on the indicated
file system.

Explanation:

The system database directory or local database directory could
not be found. A database has not been created or it was not
cataloged correctly.

The command cannot be processed.

User Response:

Verify that the database is created with the correct path
specification. The Catalog Database command has a path parameter
which specifies the directory where the database resides.

sqlcode : -1031

sqlstate : 58031

Thanks you

Internet Services

Web Development

Digital Marketing

Consumer Tech