Updating Partition Key Columns
Posted on 2006-10-30
I am designing a database in IBM DB2 UDB version 8 for z/OS and OS/390. The database will have several very large tables that will require partitioning. We intend to use a single SMALLINT column, PARTN_ID (Partition ID), as the partition key column on each partitioned table. The column value would determine the partition to which INSERTed rows would be put.
Now, for my questions.
1. If we UPDATE column PARTN_ID for existing rows via static SQL, will DB2 automatically redistribute the updated rows to the partitions indicated by the new values in PARTN_ID, or will the redistribution only happen at the next REORG?
2. Will a RUNSTATS be required or merely advisable after the redistribution or REORG?
3. Will plans need to be rebound after the redistirbution or REORG?