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.

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.

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.

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.