"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