Articles & Content
Topic: 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
Click Here to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.