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
