
174 DB2 Recovery Expert for Multiplatforms
table space. To drop a DMS table space which links to an index table space for a
table, you have to drop the table and indexes first, before you can drop the table
space.
You can drop a table space with the following command:
db2 drop tablespace <tablespacename>
When the table space is dropped, the tables are also dropped. In DB2 there is no
way to recover the table space to the point in time just before it was dropped.
However, with the help of DB2 Recovery Expert, you can recover the table space,
and its related objects like tables, views and indexes, up to the point just before
the drop.
7.3.1 Scenario ...