Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    2

    Unanswered: Help!! Restore DB from DAT files!?

    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

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by hufa
    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...
    --
    Jonathan Petruk
    DB2 Database Consultant

Posting Permissions

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