Hello,

we have a big problem!
From a DB does'n exist any backup. We have only the DAT.*, NAM.*, INX.*, *.LB and *.LBA files without their right paths for the data structure (only SMS tablespaces , OS=Win2000 Server).

How can I restore the tables from the DAT tables? Do you know a tool which can read DAT files?

thanks
hufa

What you have are the container files only... you are missing the actual database files! Do you have the database directory files???

They would look something like this:
C:\DB2\NODE0000\SQL00007>dir
Volume in drive C is Local Disk
Volume Serial Number is DC47-7B75

Directory of C:\DB2\NODE0000\SQL00007

06/07/2004 12:43p <DIR> .
06/07/2004 12:43p <DIR> ..
06/07/2004 12:42p <DIR> DB2EVENT
06/07/2004 12:44p 166,395 db2rhist.asc
06/07/2004 12:44p 166,395 db2rhist.bak
06/07/2004 12:42p 0 db2rhist.mg6
06/07/2004 12:44p 512 SQLBP.1
06/07/2004 12:44p 512 SQLBP.2
06/07/2004 12:44p 4,096 SQLDBCON
06/07/2004 12:44p 9 SQLINSLK
06/07/2004 12:44p 24,576 SQLOGCTL.LFH
06/07/2004 12:44p <DIR> SQLOGDIR
06/07/2004 12:44p 8,192 SQLOGMIR.LFH
06/07/2004 12:43p 262,144 SQLSPCS.1
06/07/2004 12:43p 262,144 SQLSPCS.2
06/07/2004 12:43p <DIR> SQLT0000.0
06/07/2004 12:43p <DIR> SQLT0001.0
06/07/2004 12:43p <DIR> SQLT0002.0
06/07/2004 12:42p 0 SQLTMPLK
12 File(s) 894,975 bytes
7 Dir(s) 12,866,314,240 bytes free

Just having the containers is useless, unfortunately...