Upgrade Guide for DB2 UDB for z/OS and OS/390 > Database and UI Upgrade Planning > Planning Your Upgrade >

About Moving Tablespaces

If you want to move tables from one tablespace to another, you need to recreate the tables in the new tablespace and then drop the existing tablespace. You cannot change the bufferpool designation in the storage control file to move tables because the page size is associated with the tablespace. For example, if you are making changes to an existing tablespace that is using BP1 or a 4K bufferpool and these changes cause you to receive a warning from ddlimp that the table will now need to be in a 16K bufferpool, you cannot just change the bufferpool designation in the storage control file from BP1 to BP16K1. If you change the bufferpool designation, ddlimp will generate the following statement:

ALTER TABLESPACE <NAME> BUFFERPOOL PB16K1

This command will fail when executed because it is not permissible to alter the bufferpool associated with the tablespace unless the new bufferpool designation is the same size as the existing bufferpool designation.