Articles & Content


RRF - is it possible to have too much of a good thing? (B11)

Topic: 2010 EMEA

Subtopic: DB2 for z/OS

DATE: 2010-11-10 (13:00 - 14:00)
SPEAKERS: Steve Thomas (BMC Software)

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.

EXP. LEVEL: Beginner,Intermediate


Describe the difference between Basic Row Format and Reordered Row Format and explain when you data will start to use RRF after you migrate to DB2 9 for z/OS

Understand the benefits you automatically obtain using RRF under most circumstances

Highlight a few rare situations to watch out for where it may not be as useful

What options do you have if you happen to be in one of these and RRF is causing a problem rather than providing the usual benefits?

What other situations might you come across where you may notice that your data is using Reordered Row Format

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.