Determining whether an object requires reorganization MVS DB2
You must reorganize an object if it is in the REORG-pending (REORP) restrictive status.Also, consider reorganizing an object if it is in an advisory REORG-pending status (AREO* or AREOR) or if analysis shows that reorganization might improve performance. Use the REORG INDEX...