DB2 for LUW Conditional Reorgs : by Joe Geller

To round off this month's DB2 for LUW performance topics, we are please to have another contribution from frequent contributor Joe Geller.

http://www.idug.org/p/do/sd/sid=6132&type=0

In this article he discusses how to determine when tables and indexes need reorgs.   He goes into a lot of detail on the various outputs from the REORGCHK command, explaining which of them are relevant and under what circumstances.   He then describes how to use the newer facilities which return result sets of this information, and how to augment thi with additional data from a variety of system resources to provide a much better idea of when a reorg would be beneficial.

As usual, Joe's article is very thorough and is highly recommended reading for all DB2 for LUW DBAs.

Be sure to check out all the articles, whitepapers, presentations, and guides in our Content File Library.

http://www.idug.org/p/do/si/topic=428&type=0

Recent Stories
Selecting Appropriate Data Architecture Technologies

SQL Tuning for Developers – Part 2 Explain Output

Some of my favorite tunings tips and tricks for DB2 by Joe Geller