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 Enhancement | IBM i 7.6 | IBM i 7.5 | IBM i 7.4 | IBM i 7.3 |
| --- Enhancements from 2025 --- | ||||
| Index advice adds ordering information to key column list | SF99960 Level 2 | SF99950 Level 11 | Not supported | Not supported |
| SYSIXADV pruning with SYSIBMADM.QIBM_SYSIXADV_BY_DAYS | SF99960 Level 2 | SF99950 Level 11 | Not supported | Not supported |
| SQL Error Logging Facility (SELF) pruning with SYSIBMADM.QIBM_SELF_BY_DAYS | SF99960 Level 2 | SF99950 Level 11 | Not supported | Not supported |
| SQL Error Logging Facility (SELF) - stop logging for all jobs | Base | SF99950 Level 9 | SF99904 Level 30 | Not supported |
| SQLSTATE_INFO table | Base | SF99950 Level 9 | Not supported | Not supported |
| --- Enhancements from 2024 --- | ||||
| SQL table function cursor name improvement | Base | SF99950 Level 8 | SF99704 Level 29 | Not supported |
| QSYS2.MTI_INFO returns member/partition name | Base | SF99950 Level 8 | SF99704 Level 29 | Not supported |
| QSYS2.SYSMEMBERSTAT | Base | SF99950 Level 7 | SF99704 Level 28 | Not supported |
| QSYS2.ACTIVE_QUERY_INFO - filter for the job's user | Base | SF99950 Level 7 | SF99704 Level 28 | Not supported |
| --- Enhancements from 2023 --- | ||||
| QSYS2.PARSE_STATEMENT() table function - DDL information | Base | SF99950 Level 5 | SF99704 Level 26 | Not supported |
| SQL Error Logging Facility (SELF) - improved controls and insight | Base | SF99950 Level 5 | SF99704 Level 26 | Not supported |
| SYSTOOLS.SQLCODE_INFO() | Base | SF99950 Level 5 | SF99704 Level 26 | Not supported |
| Tracking Important System Limits - Improved Alerting | Base | SF99950 Level 5 | SF99704 Level 26 | Not supported |
| QSYS2.SYSCOLUMNS2 additional columns | Base | SF99950 Level 5 | SF99704 Level 26 | Not supported |
| QSYS2.CANCEL_SQL procedure enhancement | Base | SF99950 Level 5 | SF99704 Level 26 | Not supported |
| SQE performance and compression enhancements | Base | SF99950 Level 4 | Not supported | Not supported |
| --- Enhancements from 2022 --- | ||||
| SQL Error Logging Facility (SELF) | Base | SF99950 Level 3 | SF99704 Level 23 | Not supported |
| COMMENT on table function return columns | Base | SF99950 Level 3 | SF99704 Level 23 | Not supported |
| Online reorganize physical file member (RGZPFM) enhancement | Base | SF99950 Level 3 | SF99704 Level 23 | Not supported |
| QSYS2.MTI_INFO lists QRO hashes and plan identifiers that have used the MTI | Base | SF99950 Level 3 | Not supported | Not supported |
| QSYS2.SYSCOLUMNSTAT enhanced for variable length columns | Base | SF99950 Level 3 | SF99704 Level 23 | Not supported |
| New QAQQINI control PARALLEL_MIN_TIME | Base | SF99950 Level 3 | Not supported | Not supported |
| New QAQQINI control PARALLEL_MAX_SYSTEM_CPU | Base | Base | Not supported | Not supported |
| QSYS2.MTI_INFO | Base | Base | SF99704 Level 20 | SF99703 Level 28 |
| Maximum Binary Radix Index size increased to 16TB | Base | Base | Not supported | Not supported |
| QSYS2.GENERATE_SQL for long view names | Base | Base | SF99704 Level 20 | Not supported |
| QSYS2.GENERATE_SQL_OBJECTS for long view names | Base | Base | SF99704 Level 20 | Not supported |
| QSQGNDDL API for long view names | Base | Base | SF99704 Level 20 | Not supported |
| QSYS2.GENERATE_SQL option to generate comment for system object text | Base | Base | SF99704 Level 20 | Not supported |
| QSYS2.GENERATE_SQL_OBJECTS option to generate comment for system object text | Base | Base | SF99704 Level 20 | Not supported |
| QSQGNDDL API option to generate comment for system object text | Base | Base | SF99704 Level 20 | Not supported |
| Ragged flash | Base | Base | Not supported | Not supported |
| Query Supervisor CL exit programs | Base | Base | SF99704 Level 20 | SF99703 Level 28 |
| --- Enhancements from 2021 --- | ||||
| QSYS2.ACTIVE_QUERY_INFO | Base | Base | SF99704 Level 15 | SF99703 Level 26 |
| QSYS2.SYSFILES | Base | Base | SF99704 Level 15 | SF99703 Level 26 |
| IBM i System Limits pruning global variables | Base | Base | SF99704 Level 15 | SF99703 Level 26 |
| Query Supervisor | Base | Base | SF99704 Level 13 | SF99703 Level 24 |
| QSYS2.SYSCOLUMNS2 | Base | Base | SF99704 Level 13 | SF99703 Level 24 |
| QSYS2.SYSPACKAGESTAT | Base | Base | SF99704 Level 13 | SF99703 Level 24 |
| QSYS2.END_IDLE_SQE_THREADS | Base | Base | SF99704 Level 13 | SF99703 Level 24 |
| QSYS2.GENERATE_SQL procedure output to IFS | Base | Base | SF99704 Level 13 | SF99703 Level 24 |
| QSYS2.GENERATE_SQL_OBJECTS procedure output to IFS | Base | Base | SF99704 Level 13 | SF99703 Level 24 |
| QSQGNDDL API output to IFS | Base | Base | SF99704 Level 13 | SF99703 Level 24 |
| --- Enhancements from 2020 --- | ||||
| RELATED_OBJECTS table function | Base | Base | SF99704 Level 10 | SF99703 Level 22 |
| SYSCOLUMNS2_SESSION view | Base | Base | SF99704 Level 10 | SF99703 Level 22 |
| QSYS2.SYSPARTITIONSTAT and QSYS2.SYSTABLESTAT views | Base | Base | SF99704 Level 7 | SF99703 Level 18 |
| OVERRIDE_QAQQINI procedure | Base | Base | SF99704 Level 7 | SF99703 Level 18 |
| --- Enhancements from 2019 --- | ||||
| Allow RI children to be added without an exclusive lock | Base | Base | SF99704 Level 4 | Not supported |
| Extend ALLOW_DDL_WHILE_OPEN for grant and revoke authorities | Base | Base | SF99704 Level 4 | SF99703 Level 16 |
| Add SUPPRESS_INQUIRY_MESSAGES | Base | Base | SF99704 Level 4 | SF99703 Level 16 |
| New columns added to QSYS2.SYSINDEXSTAT | Base | Base | SF99704 Level 4 | SF99703 Level 16 |
| Health attributes added to the SQL Plan Cache Properties | Base | Base | SF99704 Level 1 | SF99703 Level 15 |
| Alerts for IBM i System Limits | Base | Base | SF99704 Level 1 | SF99703 Level 15 |
| Tracking Important System Limits | Base | Base | SF99704 Level 1 | SF99703 Level 15 |
| --- Enhancements from 2018 --- | ||||
| QSYS2.GENERATE_SQL_OBJECTS procedure | Base | Base | Base | SF99703 Level 11 |
| QSYS2.SYSPARTITIONSTAT enhancement | Base | Base | Base | SF99703 Level 11 |
| QSYS2.PARSE_STATEMENT() table function enhancement | Base | Base | Base | SF99703 Level 11 |
| --- Enhancements from 2016 --- | ||||
| QSYS2.PARSE_STATEMENT() table function | Base | Base | Base | SF99703 Level 3 |
| --- Enhancements from 2015 --- | ||||
| Fair lock option - PREVENT_ADDITIONAL_CONFLICTING_LOCKS | Base | Base | Base | Base |
| No lock option - ALLOW_DDL_CHANGES_WHILE_OPEN | Base | Base | Base | Base |
| Add columns to QSYS2.SYSPROGRAMSTMTSTAT for SQL dependency level and IBM i Service dependency level | Base | Base | Base | Base |
| Detail about the lock holder on SQL0913 failures | Base | Base | Base | Base |
| Honor priority change for parallel index build | Base | Base | Base | Base |
| ALTER TABLE ADD PARTITION preserves spanning DDS keyed logical files | Base | Base | Base | Base |
Older Enhancements:
- QSYS2.Generate_SQL procedure
- Some SQL messages changed to return SQL column names
- Debugger support for EVAL within SQL Routines and SQL Triggers
- DRDA connections imprinted with client special register values
- Ability to create range partitions out of order
- QSYS2.RESTART_IDENTITY Procedure
- Deferred Journal Restore
- New Generate SQL option for Modernization
- Debug step supported for SQL Procedures, Functions and Triggers
- Generating field reference detail on CREATE TABLE AS
- Database Reorganization - User specified starting point
- STRQMQRY command - instrumented for Client Special Registers
- SYSPROC.BASE_TABLE - alias interrogation
- Number of partition keys - added to statistical views
- CHECK_SYSCST procedure added to SYSTOOLS
- CHECK_SYSROUTINE procedure added to SYSTOOLS
- Improved catalog management for procedures and functions
- STRDBMON pre-filtering of QUERY/400 command use
- Add result set information to QUSRJOBI & System i Navigator
- STRDBMON - QQI1 fast delete reason code
- STRDBMON - QQI2 result rows for more statements
- STRDBMON - FETCH statements show failures and warnings
- Add QSYS2.REMOVE_PERFORMANCE_MONITOR procedure
- Add FTRSQLCODE parameter to STRDBMON
- Extend FTRINTNETA pre-filter on STRDBMON command to work with non-Database clients
- Extend STRDBMON to support FTRUSER against group profiles
- Add client/server IP address and port number to QSYS2/TCPIP_INFO
- Automatic cancel of QSQSRVR jobs when an application is ended
- QSYS2.DUMP_SQL_CURSORS procedure
- QSYS2.QIBM_SQL_NO_RLA_CANCEL environment variable
- QSYS2.FIND_AND_CANCEL_QSQSRVR_SQL and QSYS2.CANCEL_SQL procedures
- QSYS2.FIND_QSQSRVR_JOBS procedure
- SQL Server Mixed Mode for Batch Processing
[{"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"}]
Was this topic helpful?
Document Information
Modified date:
07 October 2025
UID
ibm11116627