Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Location
    Dunedin, New Zealand
    Posts
    8

    Unanswered: Restoring Dropped Table

    Hello,

    I'm trying to restore from backup a couple of dropped tables.

    DB2 8.1 FP4 for Windows.

    I can do an online database or tablespace restore rolling forward but the tables never appear in the table space once the restore is completed.

    There are no error messages or anything.

    I'm quite new at this so could I be missing something?

    Thanks.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I hope I understand your situation correctly, but if you restore and then roll forward to the end of the logs, drop table statements will be reapplied (the tables will be dropped). You need to roll forward to a point in time before you dropped the tables.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jan 2004
    Location
    Dunedin, New Zealand
    Posts
    8
    That is what I thought was happening too Marcus.

    Trouble is that I can't seem to pick the time to roll forward too.

    Quite frustrating really. I managed to get everything completely messed up at one stage with Rollforward pending, Bankup Pending, unable to connect type messages, you must do a full online backup etc.

    I must say that the whole restore process is quite conveluted to the novis like me!

    Thanks for your help.

  4. #4
    Join Date
    Mar 2003
    Posts
    343
    Well then do this - give the database a time a year ago to rollforward to - the database will return the minimum point in time for rollforward (which is the max of db or any tablespace in the db). Use that timestamp to rollforward to and don't forget to use the 'and stop' clause.

    Hope this helps.

Posting Permissions

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