Triggering DB2 online reorgs in V7 for z/OS

Brian K. Cocklin

Triggering DB2 online reorgs in V7 for z/OS
When conditionally triggering DB2 reorgs using OFFPOSLIMIT, INDREFLIMIT, or
LEAFDISTLIMIT, does DB2 take into consideration physical dataset extents
and/or the number of pseudo deleted entries found in
SYSIBM.SYSINDEXPART???
We are currently using CA's Database Analyzer to determine which
tablespaces and indexes are reorganized on a weekly basis. Trying to
determine if IBM's selection criteria is a better alternative.
Any advice or help would be greatly appreciated. thank you.

---------------------------------------------------------------------------------
Welcome to the DB2 User Group - Central Pennsylvania list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/DB2-UG-Central-PA.html. From that page select "Join or Leave the list". The IDUG Listserv FAQ is at http://www.idugdb2-l.org. The DB2 User Group - Central PA List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm