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
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 From that page select "Join or Leave the list". The IDUG Listserv FAQ is at The DB2 User Group - Central PA List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at