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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"ARM Category":[{"code":"","label":""}],"Platform":[{"code":"z\/OS","label":"Platform Independent"}],"Version":"All Version(s)"},{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"ARM Category":[{"code":"","label":""}],"Platform":[{"code":"","label":"Platform Independent"}],"Version":"All Version(s)"},{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"ARM Category":[{"code":"","label":""}],"Platform":[{"code":"","label":"Platform Independent"}],"Version":"All Version(s)"},{"Line of Business":{"code":"","label":""},"Business Unit":{"code":null,"label":null},"Product":{"code":"SUNSET","label":"PRODUCT REMOVED"},"ARM Category":[{"code":"","label":""}],"Platform":[{"code":"","label":"Platform Independent"}],"Version":"All Version(s)"},{"Line of Business":{"code":"LOB26","label":"Storage"},"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"HW206","label":"Storage Systems"},"ARM Category":[{"code":"","label":""}],"Platform":[{"code":"","label":"Platform Independent"}],"Version":"All Version(s)"},{"Line of Business":{"code":"","label":""},"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"HW17E","label":"z Systems->S\/390 G5"},"ARM Category":[{"code":"","label":""}],"Platform":[{"code":"","label":"Platform Independent"}],"Version":"All Version(s)"},{"Line of Business":{"code":"LOB16","label":"Mainframe HW"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"z15_1","label":"IBM z15 (8561-T01)"},"ARM Category":[{"code":"","label":""}],"Platform":[{"code":"","label":"Platform Independent"}],"Version":"All Version(s)"},{"Line of Business":{"code":"","label":""},"Business Unit":{"code":null,"label":null},"Product":{"code":"SSRRCQ","label":"PureApplication System Pattern for SAP CRM"},"ARM Category":[{"code":"","label":""}],"Platform":[{"code":"","label":"Platform Independent"}],"Version":"All Version(s)"},{"Line of Business":{"code":"LOB16","label":"Mainframe HW"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"z15_1","label":"IBM z15 (8561-T01)"},"ARM Category":[{"code":"","label":""}],"Platform":[{"code":"","label":"Platform Independent"}],"Version":"All Version(s)"},{"Line of Business":{"code":"LOB16","label":"Mainframe HW"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG90","label":"z\/OS->z\/OS - All versions and releases"},"ARM Category":[{"code":"","label":""}],"Platform":[{"code":"z\/OS","label":"Platform Independent"}],"Version":"All Version(s)"},{"Type":"MASTER","Line of Business":{"code":"LOB56","label":"Z HW"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"z15_2","label":"IBM z15 (8562-T02)"},"ARM Category":[{"code":"","label":""}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":""}]
