IBM Support

SQE performance and compression enhancements



The SQL Query Engine (SQE) is enhanced in IBM i 7.5 to be able to leverage ZLIB compression technology, and Power 10 hardware acceleration.


You are in: IBM i Technology Updates > Db2 for i - Technology UpdatesDb2 for i Database Engineer (DBE) Enhancements > SQE performance and compression enhancements
When complex query plans exist within SQE on IBM i 7.5, the query engine has the option to compress the plan, reducing the total memory footprint related to the SQL Plan Cache. Further, when running on Power 10, the compression and decompression of such plans can leverage ZLIB compression technology along with hardware acceleration, thus reducing the time it takes to manage complex plans in the SQL Plan Cache.
See the following IBM Documentation link for additional information: Plan cache


[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000CHeAAM","label":"IBM i Db2"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.5.0;and future releases"}]

Document Information

Modified date:
11 April 2023