Solution : https://service.sap.com/sap/support/notes/147634 (SAP Service marketplace login required)
Summary :
This SAP Note outlines recommended practices for managing tablespaces within a DB2 UDB for UNIX and Windows database system, specifically in relation to SAP environments. Key points include using transaction ST04 for creating tablespsp
aces, adhering to specific naming conventions for tablespaces and buffer pools, as well as choosing correct page and extent sizes. The Note also emphasizes the importance of simultaneous container expansion to avoid rebalancing and recommends specific configurations for buffer pools and TEMP tablespaces to optimize performance. Notably, the use of DEVICE containers is advised against for tablespaces containing LONG/LOB data to avoid performance degradation. Additionally, SAP does not recommend using DB2 UDB extended storage segments for SAP systems.
Key words :
db2 control center makes rounding errors, db2 udb extended storage segments, buffering long & lob fieldssap dbsl, supported page sizeson db2 udb, linux 32-bit db2 database servers, i-node contention effects, i-node contention problems, avoid i-node contention, temp tablesthe db2 optimizer, optimal extent sizeyou define
Related Notes :
| 1077887 | SAP on HP-UX:mount & filesystem options for best performance |
| 766827 | Composite SAP note: Performance SCM 4.0 |
| 515968 | DB6: Creating data classes and tablespaces in DBA cockpit |
| 362325 | DB6: Table conversion using DB6CONV Version 4.10 or lower |