Solution : https://service.sap.com/sap/support/notes/980067 (SAP Service marketplace login required)
Summary :
This SAP Note discusses the activation and implications of row compression in DB2 for SAP systems (version 9). Row compression, aiming to save tablespace disk space, leverages dictionary-based compression at the table level. Benefits include reduced IO operations and smaller backups, but potential drawbacks involve slower updates and added CPU load. The INSPECT_TABLE_ROWCOMPESTIMATE stored procedure is suggested for identifying compression candidates. The Note outlines steps for enabling and assessing row compression, including necessary SAP and DB2 configurations, and provides tools and scripts for older SAP versions not fully integrated with DBA Cockpit.
Key words :
tp import <transport-number> <sapsid> <target_client> -, > compress nothe exisiting rows stay compressed, <dbsid>db2 invoke db2sapdb2 terminate note, windows db2 supports row compression, 1 sap systems helps finding tables, blog=/pub/wlg/4330 solution, user cataloguing stored procedure inspect_table_rowcompestimate, provided v91 parameter struct, sap note helpsyou exploiting, storage optimization feature reason
Related Notes :
| 1351160 | DB6: Using DB2 9.7 with SAP Software |
| 1089578 | DB6: Using DB2 Version 9.5 with SAP Software |
| 1027336 | DB6: New functions in the DBA Cockpit |
| 930487 | DB6: Using DB2 V9.1 with SAP Software |