Upgrade Guide for Microsoft Windows > Postupgrade Tasks > Postupgrade Tasks for All Environments >

Dropping DB2 8-KB Tablespaces and Buffers

You need to drop your 8-KB tablespace, 8-KB temporary tablespace, and 8-KB bufferpool. Before dropping your 8-KB tablespace, check for the existence of any tables in it by running the following SQL statement:

select name from sysibm.systables where TBSPACE='TBS_8K'

CAUTION:  Check your 8-KB tablespace to make sure that all objects have been migrated to your new 16-KB tablespace before dropping the 8-KB tablespace. Otherwise, you may lose this data.


 Upgrade Guide for Microsoft Windows
 Published: 20 October 2003