IBM Support

Performance Evaluation of Huffman Compression with SAP Banking on IBM Z

White Papers


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.

[{"Line of Business":{"code":"","label":""},"Business Unit":{"code":"BU022","label":"Technical Sales Support"},"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":"","label":""},"Business Unit":{"code":"BU022","label":"Technical Sales Support"},"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":"BU022","label":"Technical Sales Support"},"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":"BU022","label":"Technical Sales Support"},"Product":{"code":"SSCLPQ","label":"Tivoli Storage Manager for Enterprise Resource Planning Entry"},"ARM Category":[{"code":"","label":""}],"Platform":[{"code":"","label":"Platform Independent"}],"Version":"All Version(s)"},{"Line of Business":{"code":"","label":""},"Business Unit":{"code":"BU022","label":"Technical Sales Support"},"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":"BU022","label":"Technical Sales Support"},"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":"","label":""},"Business Unit":{"code":"BU022","label":"Technical Sales Support"},"Product":{"code":"z15mr","label":"IBM z15"},"ARM Category":[{"code":"","label":""}],"Platform":[{"code":"","label":"Platform Independent"}],"Version":"All Version(s)"},{"Line of Business":{"code":"","label":""},"Business Unit":{"code":"BU022","label":"Technical Sales Support"},"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":"","label":""},"Business Unit":{"code":"BU022","label":"Technical Sales Support"},"Product":{"code":"HW11U","label":"IBM z15 (z15)"},"ARM Category":[{"code":"","label":""}],"Platform":[{"code":"","label":"Platform Independent"}],"Version":"All Version(s)"},{"Line of Business":{"code":"","label":""},"Business Unit":{"code":"BU022","label":"Technical Sales Support"},"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)"}]

Document Information

Modified date:
12 February 2021

UID

WP102824