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:
- Unload the table using UNLOAD FROM TABLE or REORG UNLOAD EXTERNAL FROM TABLE.
- Use CREATE TABLE LIKE on the table to re-create it in the table space of the new page size.
- 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.
- Drop the original table.
- Rename the new table to the name of the old table using RENAME TABLE.
- Re-create all dependent objects.
- Rebind plans and packages.
- 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.