Just a point here. A) If in circular logging, your only option is the full db restore. B) If in archive or log retain mode, and you have a full db backup, you can restore only the tblspc. that has that table in it from the full image: db2 restore db <dbname> tablespace(<tblspcname>) online from ....... The tblspc. will be in roll forward pending. roll it forward as far as you need to get your table, extract the data from it in IXF format. Restore the tblspc. again and roll it forward to end of logs so that ALL tables are now consistent. Recreate your table from the extracted data (import create from extracted file.) C) If you are in log retain AND you have set the DROPEED TABLE RECOVERY flag on at the tblspc. level (V7) or are in V8 (flag is set at tablspc. create) then retore the tblspc. and roll forward with dropped table recover parms. in the roll froward copmmand. HTH, Pierre. ----- Original Message ----- From: "Wise Ltd" <[EMAIL PROTECTED]> To: "Turgut Kalfaoglu" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, January 30, 2004 7:37 AM Subject: RE: [DB2EUG] Painless restore of a single table?
> Hi Turgut, > > In DB2 UDB you can backup (and restore) databases and tablespaces. If you > have done full database backups, then you will have to restore the whole > database. > If you have backed up the tablespace where the table resides, then you would > be able to restore just the tablespace concerned. > > Hope this helps! > > Judy Porter-Wise > Director of IT Services > Wise Ltd. > [EMAIL PROTECTED] > www.wiselimited.com > Tel: +44 (0)1403 269247 > > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Behalf Of Turgut Kalfaoglu > Sent: 30 January 2004 11:15 > To: [EMAIL PROTECTED] > Subject: [DB2EUG] Painless restore of a single table? > > > > Hello.. We regularly backup our udb databases with DB2 BACKUP command, > and I just wanted to restore a small table from this backup. I was > wondering what was the most painless way to restore this data? I did not > want to restore the whole lot; just a small table.. > > Thanks! > -turgut > > ----- > Turgut Kalfaoglu: http://www.kalfaoglu.com > EgeNet Internet Services: http://www.egenet.com.tr > > > - > ::: When replying to the list, please use 'Reply-All' and make sure > ::: a copy goes to the list ([EMAIL PROTECTED]). > *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] > *** For more information, check http://www.db2eug.uni.cc > > - > ::: When replying to the list, please use 'Reply-All' and make sure > ::: a copy goes to the list ([EMAIL PROTECTED]). > *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] > *** For more information, check http://www.db2eug.uni.cc > - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
