IBM Support

Db2 for i Database Engineer (DBE) Enhancements

News


Abstract

Db2 for i Database Engineer (DBE) Enhancements Landing Page

Content

You are in: IBM i Technology Updates > Db2 for i - Technology Updates >  Db2 for i Database Engineer (DBE) Enhancements
 
 
Db2 for i EnhancementIBM i 7.6IBM i 7.5IBM i 7.4IBM i 7.3
--- Enhancements from 2026 ---
SQL Error Logging Facility (SELF) users can view rows they generatedSF99960 Level 3SF99950 Level 12Not supportedNot supported
SQL query engine pruning of debug data with SYSIBMADM.QIBM_SQEDEBUG_BY_DAYSSF99960 Level 3SF99950 Level 12Not supportedNot supported
--- Enhancements from 2025 ---
Index advice adds ordering information to key column listSF99960 Level 2SF99950 Level 11Not supportedNot supported
SYSIXADV pruning with SYSIBMADM.QIBM_SYSIXADV_BY_DAYSSF99960 Level 2SF99950 Level 11Not supportedNot supported
SQL Error Logging Facility (SELF) pruning with SYSIBMADM.QIBM_SELF_BY_DAYSSF99960 Level 2SF99950 Level 11Not supportedNot supported
SQL Error Logging Facility (SELF) - stop logging for all jobsBaseSF99950 Level 9SF99904 Level 30Not supported
SQLSTATE_INFO tableBaseSF99950 Level 9Not supportedNot supported
--- Enhancements from 2024 ---
SQL table function cursor name improvementBaseSF99950 Level 8SF99704 Level 29Not supported
QSYS2.MTI_INFO returns member/partition nameBaseSF99950 Level 8SF99704 Level 29Not supported
QSYS2.SYSMEMBERSTATBaseSF99950 Level 7SF99704 Level 28Not supported
QSYS2.ACTIVE_QUERY_INFO - filter for the job's userBaseSF99950 Level 7SF99704 Level 28Not supported
--- Enhancements from 2023 ---
QSYS2.PARSE_STATEMENT() table function - DDL informationBaseSF99950 Level 5SF99704 Level 26Not supported
SQL Error Logging Facility (SELF) - improved controls and insightBaseSF99950 Level 5SF99704 Level 26Not supported
SYSTOOLS.SQLCODE_INFO()BaseSF99950 Level 5SF99704 Level 26Not supported
Tracking Important System Limits - Improved AlertingBaseSF99950 Level 5SF99704 Level 26Not supported
QSYS2.SYSCOLUMNS2 additional columnsBaseSF99950 Level 5SF99704 Level 26Not supported
 QSYS2.CANCEL_SQL procedure enhancementBaseSF99950 Level 5SF99704 Level 26Not supported
SQE performance and compression enhancementsBaseSF99950 Level 4Not supportedNot supported
--- Enhancements from 2022 ---
SQL Error Logging Facility (SELF)BaseSF99950 Level 3SF99704 Level 23Not supported
COMMENT on table function return columnsBaseSF99950 Level 3SF99704 Level 23Not supported
Online reorganize physical file member (RGZPFM) enhancementBaseSF99950 Level 3SF99704 Level 23Not supported
QSYS2.MTI_INFO lists QRO hashes and plan identifiers that have used the MTIBaseSF99950 Level 3Not supportedNot supported
QSYS2.SYSCOLUMNSTAT enhanced for variable length columnsBaseSF99950 Level 3SF99704 Level 23Not supported
New QAQQINI control PARALLEL_MIN_TIMEBaseSF99950 Level 3Not supportedNot supported
New QAQQINI control PARALLEL_MAX_SYSTEM_CPUBaseBaseNot supportedNot supported
QSYS2.MTI_INFOBaseBaseSF99704 Level 20SF99703 Level 28
Maximum Binary Radix Index size increased to 16TBBaseBaseNot supportedNot supported
QSYS2.GENERATE_SQL for long view namesBaseBaseSF99704 Level 20Not supported
QSYS2.GENERATE_SQL_OBJECTS for long view namesBaseBaseSF99704 Level 20Not supported
QSQGNDDL API for long view namesBaseBaseSF99704 Level 20Not supported
QSYS2.GENERATE_SQL option to generate comment for system object textBaseBaseSF99704 Level 20Not supported
QSYS2.GENERATE_SQL_OBJECTS option to generate comment for system object textBaseBaseSF99704 Level 20Not supported
QSQGNDDL API option to generate comment for system object textBaseBaseSF99704 Level 20Not supported
Ragged flashBaseBaseNot supportedNot supported
Query Supervisor CL exit programsBaseBaseSF99704 Level 20SF99703 Level 28
--- Enhancements from 2021 ---
QSYS2.ACTIVE_QUERY_INFOBaseBaseSF99704 Level 15SF99703 Level 26
QSYS2.SYSFILESBaseBaseSF99704 Level 15SF99703 Level 26
IBM i System Limits pruning global variablesBaseBaseSF99704 Level 15SF99703 Level 26
Query SupervisorBaseBaseSF99704 Level 13SF99703 Level 24
QSYS2.SYSCOLUMNS2BaseBaseSF99704 Level 13SF99703 Level 24
QSYS2.SYSPACKAGESTATBaseBaseSF99704 Level 13SF99703 Level 24
QSYS2.END_IDLE_SQE_THREADSBaseBaseSF99704 Level 13SF99703 Level 24
QSYS2.GENERATE_SQL procedure output to IFSBaseBaseSF99704 Level 13SF99703 Level 24
QSYS2.GENERATE_SQL_OBJECTS procedure output to IFSBaseBaseSF99704 Level 13SF99703 Level 24
QSQGNDDL API output to IFSBaseBaseSF99704 Level 13SF99703 Level 24
--- Enhancements from 2020 ---
RELATED_OBJECTS table functionBaseBaseSF99704 Level 10SF99703 Level 22
SYSCOLUMNS2_SESSION viewBaseBaseSF99704 Level 10SF99703 Level 22
QSYS2.SYSPARTITIONSTAT and QSYS2.SYSTABLESTAT viewsBaseBaseSF99704 Level 7SF99703 Level 18
OVERRIDE_QAQQINI procedureBaseBaseSF99704 Level 7SF99703 Level 18
--- Enhancements from 2019 ---
Allow RI children to be added without an exclusive lockBaseBaseSF99704 Level 4Not supported
Extend ALLOW_DDL_WHILE_OPEN for grant and revoke authorities BaseBaseSF99704 Level 4SF99703 Level 16
Add SUPPRESS_INQUIRY_MESSAGESBaseBaseSF99704 Level 4SF99703 Level 16
New columns added to QSYS2.SYSINDEXSTATBaseBaseSF99704 Level 4SF99703 Level 16
Health attributes added to the SQL Plan Cache PropertiesBaseBaseSF99704 Level 1SF99703 Level 15
Alerts for IBM i System LimitsBaseBaseSF99704 Level 1SF99703 Level 15
Tracking Important System LimitsBaseBaseSF99704 Level 1SF99703 Level 15
--- Enhancements from 2018 ---
QSYS2.GENERATE_SQL_OBJECTS procedureBaseBaseBaseSF99703 Level 11
QSYS2.SYSPARTITIONSTAT enhancementBaseBaseBaseSF99703 Level 11
QSYS2.PARSE_STATEMENT() table function enhancementBaseBaseBaseSF99703 Level 11
--- Enhancements from 2016 ---
QSYS2.PARSE_STATEMENT() table functionBaseBaseBaseSF99703 Level 3
--- Enhancements from 2015 ---
Fair lock option - PREVENT_ADDITIONAL_CONFLICTING_LOCKSBaseBaseBaseBase
No lock option - ALLOW_DDL_CHANGES_WHILE_OPENBaseBaseBaseBase
Add columns to QSYS2.SYSPROGRAMSTMTSTAT for SQL dependency level and IBM i Service dependency levelBaseBaseBaseBase
Detail about the lock holder on SQL0913 failuresBaseBaseBaseBase
Honor priority change for parallel index buildBaseBaseBaseBase
ALTER TABLE ADD PARTITION preserves spanning DDS keyed logical filesBaseBaseBaseBase

 

 

Older Enhancements:

[{"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":"7.2.0;and future releases"}]

Document Information

Modified date:
29 June 2026

UID

ibm11116627

Page Feedback