By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,667 Members | 2,261 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,667 IT Pros & Developers. It's quick & easy.

Single table restore

P: n/a
Hello!
Is it at all possible (on DB2 V7.2, AIX) to restore a single table from a
full table backup?
The RESTORE DB command doesn't have this functionality - at least not
according to the DB2 manuals.
Any undocumented commands, switches, tweaks?

Regards,
Damir
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a

"Damir Wilder" <da**********@etna.hr> wrote in message
news:ce**********@ls219.htnet.hr...
Hello!
Is it at all possible (on DB2 V7.2, AIX) to restore a single table from a
full table backup?
The RESTORE DB command doesn't have this functionality - at least not
according to the DB2 manuals.
Any undocumented commands, switches, tweaks?

I think what you meant to say was a "full *database* backup", not a "full
table backup".

You are right, the RESTORE command does not work at the table level. It
works at the database level or the tablespace level, as documented in the
Command Reference. Therefore, you may want to redesign your physical
database somewhat so that any table that may need to be restored
independently of the other tables is in its own tablespace (or database).

However, many database designs feature lots of interrelationships between
tables. In cases like that, you will want to restore all the related tables
to the same point in time so that you don't create logical inconsistencies
between the tables. Each group of related tables might end up in its own
tablespace so that you could restore that one tablespace independent of the
rest of the database.

I realize that this doesn't help you with your immediate problem but it may
help you improve the design of your database so that this problem doesn't
occur again in the future.

Rhino
Nov 12 '05 #2

P: n/a
"Damir Wilder" <da**********@etna.hr> wrote in message
news:ce**********@ls219.htnet.hr...
Hello!
Is it at all possible (on DB2 V7.2, AIX) to restore a single table from a
full table backup?
The RESTORE DB command doesn't have this functionality - at least not
according to the DB2 manuals.
Any undocumented commands, switches, tweaks?

Regards,
Damir

Restore the backup to a new database name and then export the data from the
table you want, and import it back in to the old database. That is the only
option that I know of.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.