Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
page reorgs while updating variable length records
- Thread starter clarkr
- Start date
I don't believe you can explicitly : there is no DB or DBM CFG parameter to do this. The reason why you are getting page reorgs is because DB2 is "repacking" the data on the page because the data being written back is a different length to that read.
Is this causing you a major performance problem ? I can't say I seen this in any site I've worked at.
If you really want to eliminate page reorgs, and don't mind wasting space then change the varchars to chars. On mainframe DB2 you could also play with the FREEPAGE and FREESPACE tablespace parameters to ensure you only got one row per page (again that wasted space, but was sometimes worth it, for example to reduce contention).
HTH
Phil Nelson
ScotDB Limited
Is this causing you a major performance problem ? I can't say I seen this in any site I've worked at.
If you really want to eliminate page reorgs, and don't mind wasting space then change the varchars to chars. On mainframe DB2 you could also play with the FREEPAGE and FREESPACE tablespace parameters to ensure you only got one row per page (again that wasted space, but was sometimes worth it, for example to reduce contention).
HTH
Phil Nelson
ScotDB Limited
- Status
Similar threads
- Locked
- Question