Moving a table to a table space of a different page size

You can alter a table to use a different page size, or you can move a table to a table space of a different page size.

Procedure

To move a table to a table space of a different page size:

  1. Unload the table using UNLOAD FROM TABLE or REORG UNLOAD EXTERNAL FROM TABLE.
  2. Use CREATE TABLE LIKE on the table to re-create it in the table space of the new page size.
  3. Use Db2 Control Center, Db2 Administration Tool for z/OS®, or catalog queries to determine the dependent objects: views, authorization, plans, packages, synonyms, triggers, referential integrity, and indexes.
  4. Drop the original table.
  5. Rename the new table to the name of the old table using RENAME TABLE.
  6. Re-create all dependent objects.
  7. Rebind plans and packages.
  8. Reload the table using data from the SYSRECnn data set and the control statements from the SYSPUNCH data set, which was created when the table was unloaded.