350Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition
4.Drop the table.
The data partition has been detached from the partitioned table and the
content of the table has been archived to file on disk. At this point, the file can
be archived and backed up to TSM or another storage manager.
The table can now be dropped using the standard DROP TABLE statement as
shown in Example 9-7.
Example 9-7 Drop archived table
DROP TABLE cstinsight.archive_part_2009q4
5.Drop the data partition table space.
The dedicated table space for the data partition can now be dropped as
shown in Example 9-8.
Example 9-8 Drop archived tab ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.