Brenda Beane, Seewah Chan, Paul Lekkas
DASD; DB2 for z/OS and OS/390; DB2 Universal Database for z/OS; ERP; IBM System Storage; IBM System z; IBM Z; Linux on zSeries; SAP; z Systems; z15; zSeries; z/OS
|Abstract: Current IBM Z processor family introduced a new technique for compressing data. It provides optimized on-chip compression and uses Huffman encoding to achieve better data compression efficiency than the prior fixed length algorithm.|
The IBM SAP on Z Performance Team, located in Poughkeepsie, NY, conducted a study to see if there could be any space saving benefit or significant system performance impact for an SAP on Z database from the improved compression algorithm.
This study used banking services from SAP, with a database of 100 million accounts. This is comparable to the number of accounts held by some of the largest banks in the world. This database was compressed using Huffman encoding and the space usage was compared to the same database compressed with fixed length encoding. The SAP Banking Account Settlement and Day Posting workloads were run to quantify the database growth and any impact to the system performance with Huffman compression compared to fixed length compression. Using both a batch and an OLTP workload gave a more complete picture of potential performance impacts since these workloads have different characteristics. Both these workloads are good representations of customer workloads. The measurements were conducted on an IBM z15 with Db2 12 for z/OS function level 504.
Hardware; Software; Solutions
IBM System z Software
Linux on IBM Z; z/OS
Huffman, compression, IBM Z, z15, Db2, SAP, banking
|Is this your first visit to Techdocs (the Technical Sales Library)?