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.5 | IBM i 7.4 | IBM i 7.3 | IBM i 7.2 |
| --- Enhancements from 2024 --- | ||||
| QSYS2.DUMP_PLAN_CACHE - Searching by Independent ASP name | SF99950 Level 7 | SF99704 Level 28 | Not supported | Not supported |
| --- Enhancements from 2023 --- | ||||
| QSYS2.DUMP_PLAN_CACHE - Searching by SQL Statement Text | SF99950 Level 5 | SF99704 Level 26 | Not supported | Not supported |
| --- Enhancements from 2022 --- | ||||
| New QAQQINI control PARALLEL_MIN_TIME | SF99950 Level 3 | Not supported | Not supported | Not supported |
| SQE - Improved CPU costing | Base | Not supported | Not supported | Not supported |
| SQE - Improved SMP processing |
Base | Not supported | Not supported | Not supported |
| --- Enhancements from 2021 --- | ||||
| Blocked insert supported for tables containing generated columns | Base | SF99704 Level 13 | Not supported | Not supported |
| QSYS2.CLEAR_PLAN_CACHE procedure is enhanced | Base | SF99704 Level 13 | SF99703 Level 24 | Not supported |
| QSYS2.DUMP_PLAN_CACHE procedure is enhanced | Base | SF99704 Level 13 | SF99703 Level 24 | Not supported |
| QSYS2.DUMP_PLAN_CACHE_PROPERTIES procedure is enhanced | Base | SF99704 Level 13 | SF99703 Level 24 | Not supported |
| QSYS2.DUMP_PLAN_CACHE_TOPN procedure is enhanced | Base | SF99704 Level 13 | SF99703 Level 24 | Not supported |
| --- Enhancements from 2019 --- | ||||
| IASP vary on performance is improved | Base | SF99704 Level 1 | SF99703 Level 15 | Not supported |
| --- Enhancements from 2018 --- | ||||
| Improved code generation for SQL procedures, functions, & triggers | Base | Base | SF99703 Level 11 | SF99702 Level 23 |
| Implicit parameter marker conversion on some data-change-table-references | Base | Base | SF99703 Level 11 | SF99702 Level 23 |
| --- Enhancements from 2017 --- | ||||
| QSYS2.RESET_TABLE_INDEX_STATISTICS() procedure | Base | Base | Enhanced with SF99703 Level 4 | Enhanced with SF99702 Level 16 |
| Enhanced processing of Index Advice | Base | Base | Enhanced with SF99703 Level 4 | Enhanced with SF99702 Level 16 |
| --- Enhancements from 2016 --- | ||||
| Improved Inlining support for SQL Scalar User Defined Functions (UDFs) | Base | Base | SF99703 Level 3 | SF99702 Level 14 |
| Statement deterministic functions | Base | Base | SF99703 Level 3 | SF99702 Level 14 |
| Inlining support for User Defined Table Functions (UDTFs) | Base | Base | Base | SF99702 Level 11 |
| --- Enhancements from 2015 --- | ||||
| EVI Only Access (EOA) | Base | Base | Base | SF99702 Level 9 |
| Improved code generation for SQL procedures, functions, & triggers | Base | Base | Base | SF99702 Level 9 |
| Enhanced index build logic for highly concurrent environments | Base | Base | Base | SF99702 Level 5 |
| SQE - improved performance for Outer Join queries | Base | Base | Base | SF99702 Level 5 |
| SQE - Index Merge Ordering | Base | Base | Base | SF99702 Level 5 |
| QSYS2.DATABASE_MONITOR_INFO Catalog | Base | Base | Base | SF99702 Level 5 |
| QAQQINI memory preference by pool name | Base | Base | Base | SF99702 Level 5 |
| Index Statistical Catalogs - enhanced to return more detail | Base | Base | Base | SF99702 Level 5 |
| QSYS2.CLEAR_PLAN_CACHE procedure | Base | Base | Base | SF99702 Level 5 |
| QSQPRCED() statement level control of QAQQINI options | Base | Base | Base | SF99702 Level 5 |
| --- Enhancements from 2014 --- | ||||
| Visual Explain ability to drill into a UDTF | Base | Base | Base | Not supported |
| Index 'Creation date' added to Navigator's Schemas & Db2 for i Catalogs | Base | Base | Base | SF99702 Level 3 |
| Automated DBE tasks for Navigator | Base | Base | Base | SF99702 Level 3 |
| Database monitor with condensed host variables capture | Base | Base | Base | SF99702 Level 3 |
| Comprehensive support for 'Keep in Memory' | Base | Base | Base | SF99702 Level 3 |
| 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"}]
Was this topic helpful?
Document Information
Modified date:
21 April 2024
UID
ibm11116615