An excellent SAP document describes how to avoid database REORG operations in SAP Systems operating with DB2 10.1 LUW
Techniacal environment:Â SAP NetWeaver 7.0 and higherÂ on DB2 for Linux, UNIX, and Windows (DB2Â forÂ LUW) version 10.1 or higher.
Document Summary: Database tables with frequent INSERT, UPDATE and DELETE operations become fragmented over time. This fragmentation causes problems in terms of performance and space reclamatio n. To alleviate these problems the database administrator starts a table and/or index reorganization which is a heavy operation and has an impact on the avail ability of that table or index . DB2 10.1 offers new features that help to a void reorganizations. This document discusses the usag e of insert time clustering tables, index space reclamation and smart data and inde x prefetching in SAP systems running on DB2 10.1.
Owner and source of document: SAP
Link: Click here.