Solution : https://service.sap.com/sap/support/notes/1493932 (SAP Service marketplace login required)
Summary :
In this SAP Note, users of DB2 for Linux, UNIX, and Windows are advised on the optimal extent size selection for tablespaces. In DB2, an extent is a storage unit allocated within a tablespace, essential for table and index object storage. SAP systems default to a layout with a 16 KB page size and an extent size of 2, optimizing both space and performance. Larger extent sizes, while reducing frequent allocation overhead for rapidly growing tables, result in more significant partially filled blocks, impacting overall database size. Users should cautiously consider extent sizes larger than 2 only for specific needs, especially for tables with high growth rates. Recommendations against arbitrary increases in extent size unless for predefined reasons are highlighted.
Key words :
terms db2 db6 luw ese purescale reason, larger extent sizes allocate larger portions, blindly apply larger extent sizes, larger extent sizes onlyfor tables, data objectcontains long field data, larger extent sizes result, choose extent sizes larger, avoid increased space consumption, read larger portions, larger extent sizes
Related Notes :
| 1329179 | DB6: DB2 9.7 Standard Parameter Settings |
| 1151343 | DB6: Using "Deferred Table Creation" |
| 1086130 | DB6: DB2 9.5 Standard Parameter Settings |
| 899322 | DB6: DB2 9.1 Standard Parameter Settings |
| 584952 | DB6: DB2 UDB Version 8 Standard Parameter Settings |