RRF – Is it possible to have too much of a good thing?

Date: 
Wednesday, 15 lipanj, 2011 - 09:00 - 10:00
Speaker: 
Steve Thomas

The format of the physical rows stored on a page has remained essentially the same since DB2 Version 1, but DB2 9 for z/OS changes all this with the introduction of Reordered Row Format. This new feature is on by default so you are very likely to start using without even noticing – it’s implemented whenever you create a new object or when you run the first REORG or LOAD of a table after going to V9 NFM. The good news is that in almost all situations using RRF is a thoroughly good thing and almost all sites will benefit from it. In fact most sites will remain in blissful ignorance that the row format has even changed internally. However, as often happens there are exceptions to the general rule even if they’re rare and it’s far from clear from the documentation what you can do if you find yourself in one of these situations.

This session will explain how RRF is implemented together along with some tips regarding when you might want to take a closer look at whether it may be hurting you and what you can do if you find yourself in such circumstances.

 

sqladria

SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us

facebook
linkid
twitter

 

Events in 2023

VODICE -  12th - 15th June 2023