Error 58031 connecting to a DB2 database

db2-connect
Monali James picture Monali James · Nov 30, 2011 · Viewed 29.4k times · Source

I have created a database in DB2. It was working until yesterday, but now I am getting the following error when attempting to connect to the database:

[IBM][CLI Driver] SQL1031N  The database directory cannot be 
found on the indicated file system.  SQLSTATE=58031

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

What is the cause of the error and how do I fix it?

Answer

Ricketyship picture Ricketyship · Jan 10, 2012

See if the database folder where your actual database files exist has been renamed or moved.

Related questions

what is the upper limit for the predicate WHERE IN () db2?

what is the upper limit for predicate WHERE IN in DB2. For example: select salary from employee where empid in (1,2,3,4...N)

Read More