Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2009
    Posts
    2

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

    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

  2. #2
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    + contact your DBA
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  3. #3
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    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
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  4. #4
    Join Date
    Jun 2009
    Posts
    2
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •