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................

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

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.........................

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