timmzzz 060000RTR7 Visits (2308)
Setting the zparm SPRMRRF to DISABLE will prevent the conversion of pagesets from basic row format (BRF) to reordered row format (RRF), but does not convert pagesets back to BRF format.
If a REORG utility is run against a Partition-by-growth (PBG) table space that is currently in RRF format, it is possible that the PBG tablespace needs to grow a new partition during the REORG. Since the previous partitions are RRF, the new partition should be RRF in spite of the current zparm setting. Due to a code defect, the new partition is created as BRF and it can result in a mix of BRF and RRF data within the partition. This mix of row formats in a single partition should never occur.
This problem can occur in both DB2 10 CM and NFM.
Two APARs have been opened to address this issue.
APAR PM68133 is created to ensures that PBG partitions that are created during REORG will be in the correct format.
An exception is when REORG of a PBG pageset is also materializing pending alters in DB2 10 NFM. APAR PM69073 is created to correct this scenario as well.
PM68133: MIXED ROW FORMATS WAS MADE BY REORG WHEN PBG GROW
PM69073: ABEND04E RC00C90101 DSNIRLPG DURING REORG OF A PBG WITH PENDING ALTER MATE