ANL6007I *** RECOMMENDATION: HERE IS SOME ADVICE: CONVERT THE TABLESPACE TO A UNIVERSAL TABLE SPACE (PARTITION-BY-GROWTH OR PARTITION-BY-RANGE). THIS ALLOWS BETTER SPACE MANAGEMENT SCANNING ONLY ROWS THAT BELONG TO THE SINGLE TABLE REQUIRED AND ALSO PROMOTES CLUSTERING, ALLOWS LOCKSIZE TABLE, MASS DELETE, SPACE AVAILABILITY AFTER A DROP TABLE WITHOUT REORG, AND MUCH BETTER PERFORMANCE OVERALL.
User response
As appropriate.