IBM Support

Db2 for i Performance Enhancements

News


Abstract

Db2 for i Performance Enhancements Landing Page

Content

You are in: IBM i Technology Updates > Db2 for i - Technology Updates >  Db2 for i Performance Enhancements
 
Db2 for i Enhancement IBM i 7.6 IBM i 7.5 IBM i 7.4 IBM i 7.3
--- Enhancements from 2025 ---
QSYS2.DUMP_PLAN_CACHE - Searching by QRO hash Base SF99950 Level 9 Not supported Not supported
Parallel execution of UPDATE and DELETE (SQL) statements Base Not supported Not supported Not supported
SQL Query Engine (SQE) - QRO Hash size increase Base Not supported Not supported Not supported
Database tooling improved to return wait insights Base Not supported Not supported Not supported
Database tooling changed to return improved labels and units Base Not supported Not supported Not supported
--- Enhancements from 2024 ---
QSYS2.DUMP_PLAN_CACHE - Searching by Independent ASP name Base SF99950 Level 7 SF99704 Level 28 Not supported
--- Enhancements from 2023 ---
QSYS2.DUMP_PLAN_CACHE - Searching by SQL Statement Text Base SF99950 Level 5 SF99704 Level 26 Not supported
--- Enhancements from 2022 ---
New QAQQINI control PARALLEL_MIN_TIME Base SF99950 Level 3 Not supported Not supported
SQE - Improved CPU costing Base Base Not supported Not supported
SQE - Improved SMP processing Base Base Not supported Not supported
--- Enhancements from 2021 ---
Blocked insert supported for tables containing generated columns Base Base SF99704 Level 13 Not supported
QSYS2.CLEAR_PLAN_CACHE procedure is enhanced Base Base SF99704 Level 13 SF99703 Level 24
QSYS2.DUMP_PLAN_CACHE procedure is enhanced Base Base SF99704 Level 13 SF99703 Level 24
QSYS2.DUMP_PLAN_CACHE_PROPERTIES procedure is enhanced Base Base SF99704 Level 13 SF99703 Level 24
QSYS2.DUMP_PLAN_CACHE_TOPN procedure is enhanced Base Base SF99704 Level 13 SF99703 Level 24
--- Enhancements from 2019 ---
IASP vary on performance is improved Base Base SF99704 Level 1 SF99703 Level 15
--- Enhancements from 2018 ---
Improved code generation for SQL procedures, functions, & triggers Base Base Base SF99703 Level 11
Implicit parameter marker conversion on some data-change-table-references Base Base Base SF99703 Level 11
--- Enhancements from 2017 ---
QSYS2.RESET_TABLE_INDEX_STATISTICS() procedure Base Base Base Enhanced with SF99703 Level 4
Enhanced processing of Index Advice Base Base Base Enhanced with SF99703 Level 4
--- Enhancements from 2016 ---
Improved Inlining support for SQL Scalar User Defined Functions (UDFs) Base Base Base SF99703 Level 3
Statement deterministic functions Base Base Base SF99703 Level 3
Inlining support for User Defined Table Functions (UDTFs) Base Base Base Base
--- Enhancements from 2015 ---
EVI Only Access (EOA) Base Base Base Base
Improved code generation for SQL procedures, functions, & triggers Base Base Base Base
Enhanced index build logic for highly concurrent environments Base Base Base Base
SQE - improved performance for Outer Join queries Base Base Base Base
SQE - Index Merge Ordering Base Base Base Base
QSYS2.DATABASE_MONITOR_INFO view Base Base Base Base
QAQQINI memory preference by pool name Base Base Base Base
Index Statistical Catalogs - enhanced to return more detail Base Base Base Base
QSYS2.CLEAR_PLAN_CACHE procedure Base Base Base Base
QSQPRCED() statement level control of QAQQINI options Base Base Base Base
--- Enhancements from 2014 ---
Visual Explain ability to drill into a UDTF Base Base Base Base
Index 'Creation date' added to Navigator's Schemas & Db2 for i Catalogs Base Base Base Base
Automated DBE tasks for Navigator Base Base Base Base
Database monitor with condensed host variables capture Base Base Base Base
Comprehensive support for 'Keep in Memory' Base Base Base Base
Improved Toolbox JDBC driver support for blocked INSERTs Base Base Base Base
QSYS2.SYSPACKAGESTMTSTAT catalog Base Base Base Base
QSYS2.SYSPROGRAMSTMTSTAT catalog Base Base Base Base
QSYS2.DUMP_PLAN_CACHE_TOPN procedure Base Base Base Base
QSYS2.EXTRACT_STATEMENTS procedure Base Base Base Base

[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000CHeAAM","label":"IBM i Db2"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions"}]

Document Information

Modified date:
08 April 2025

UID

ibm11116615

Page Feedback