Bookshelf Home | Contents | Index | Search | PDF |
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.
Bookshelf Home | Contents | Index | Search | PDF |
Upgrade Guide for Microsoft Windows Published: 20 October 2003 |