Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2008

    Unanswered: db2 restore problem

    Hi guys,
    I am using db2 9.5 on aix platform .
    I have two databases under the same instance .

    I am trying to restore a a backup of one db into other .

    after restoring using command
    restore source_db taken at timestamp_backup into target_db .

    the tablespaces of target db becomes unusable andf goes into backup pending state.

    my tablespace def is as follows :

    source FILE '/tmp/db2inst1/DSCPTEST/data1/SCPRT_TS1_3.dat' 25600,
    FILE '/tmp/db2inst1/DSCPTEST/data1/SCPRT_TS1_4.dat' 25600)

    target :

    FILE '/home/db2inst1/db2inst1/DSCPIST/data1/SCPRT_TS1_1.dat' 38400,
    FILE '/home/db2inst1/db2inst1/DSCPIST/data1/SCPRT_TS1_2.dat' 38400,
    FILE '/tmp/db2inst1/DSCPIST/data1/SCPRT_TS1_3.dat' 25600,
    FILE '/tmp/db2inst1/DSCPIST/data1/SCPRT_TS1_4.dat' 25600)

    Please advice how to proceed


  2. #2
    Join Date
    Jan 2009
    Zoetermeer, Holland
    use/google redirected restore.... and be carefull (as you noticed) the way you work now leads to desctruction of your tablespaces because you overwrite them
    Last edited by dr_te_z; 10-15-09 at 09:49.

Posting Permissions

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