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.


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.


Recent Stories
Db2 for z/OS locking basics

A Beginners Guide to Locks, Latches, Claims and Drains in DB2 for z/OS by Steve Thomas

Fun with Date Ranges