Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2010
    Posts
    123

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

    hi all i am getting the following error
    db2 connect to RPT78GET
    SQL1031N The database directory cannot be found on the indicated file system. SQLSTA
    NOTE:while using ALIS name (RPT78GEZ)for connecting its there is no issue,connecting succefully.

    I found SQL00001 IN /flash/db2/fs1/rpt78get
    I did not found any NODE0000 directory in /home/reptdb2t

    pls find the attachment , pls let me know

    If i have to perform catalog command

    which path i hav to consider

    wheter flash/db2/fs1/rpt78get or /home/reptdb2t

    if i have ti use /home/reptdb2t (have to copy NODE0000 from flash/db2/fs1/rpt78get to /home/reptdb2t)

    pls help me out................
    Attached Files Attached Files

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    There are no databases under /home/reptdb2t as per your attached file.

    Here is an example of how your "local db directory" structure should look like:

    <db path>/<instance name>/NODE0000/SQL00001
    <db path>/<instance name>/NODE0000/sqldbdir

  3. #3
    Join Date
    Dec 2010
    Posts
    123
    Quote Originally Posted by BELLO4KA View Post
    There are no databases under /home/reptdb2t as per your attached file.

    Here is an example of how your "local db directory" structure should look like:

    <db path>/<instance name>/NODE0000/SQL00001
    <db path>/<instance name>/NODE0000/sqldbdir

    i know tat, but i found in /flash/db2/fs1/rpt78get( i provided db2 list db directory output also)

    why it is not founding

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    What's the output from "db2 list db directory on /flash/db2/fs1/rpt78get" ?


    Under the local db directory where "I found SQL00001 IN /flash/db2/fs1/rpt78get", look for sqldbdir dir. Inside this sqldbdir dir, there are several files, one of them is sqldbdir. Do "strings sqldbdir" to see its content.

  5. #5
    Join Date
    Dec 2010
    Posts
    123
    Quote Originally Posted by BELLO4KA View Post
    What's the output from "db2 list db directory on /flash/db2/fs1/rpt78get" ?


    Under the local db directory where "I found SQL00001 IN /flash/db2/fs1/rpt78get", look for sqldbdir dir. Inside this sqldbdir dir, there are several files, one of them is sqldbdir. Do "strings sqldbdir" to see its content.

    i am already provided in attachment.........................

  6. #6
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Sorry, I didn't realize your attachment had more than one page. Try the following:

    catalog db rpt78get on /flash/db2/fs1/rpt78get
    list db directory
    connect to rpt78get

Posting Permissions

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