| |
This paper describes the results of an analysis that was executed at a customer site. The system investigated was a SAP R/3 production system using SAP R/3 Enterprise with the industry solution insurance (IS-Insurance). The analysis comprises the effects on the compression of large tables using the DB2 9 row compression feature. The database software was upgraded from DB2 V8 to DB2 9 using the standard upgrade procedure. The results that we received are remarkable and very encouraging related to the usage of DB2 compression in a SAP system. The compression of the chosen 310 tables resulted in an average compression rate of 70%. The overall space saving of the database was 43%, which also includes the effects of the reorganization and table movements to reduce table space high water marks. This was in spite of having the large RID attribute switched on and being activated during REORG for the selected 310 tables, which increased the size of the indexes.
View the complete white paper |
|  |
|
