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 Enhancement IBM i 7.5 IBM i 7.4 IBM i 7.3 IBM i 7.2
--- Enhancements from 2022 ---
QSYS2.MTI_INFO Base SF99704 Level 20 SF99703 Level 28 Not supported
Maximum Binary Radix Index size increased to 16TB Base Not supported Not supported Not supported
QSYS2.GENERATE_SQL for long view names Base SF99704 Level 20 SF99703 Level 28 Not supported
QSYS2.GENERATE_SQL_OBJECTS for long view names Base SF99704 Level 20 SF99703 Level 28 Not supported
QSYS2.GENERATE_SQL option to generate comment for system object text Base SF99704 Level 20 SF99703 Level 28 Not supported
QSYS2.GENERATE_SQL_OBJECTS option to generate comment for system object text Base SF99704 Level 20 SF99703 Level 28 Not supported
Ragged flash Base Not supported Not supported Not supported
Query Supervisor CL exit programs Base SF99704 Level 20 SF99703 Level 28 Not supported
--- Enhancements from 2021 ---
QSYS2.ACTIVE_QUERY_INFO Base SF99704 Level 15 SF99703 Level 26 Not supported
QSYS2.SYSFILES Base SF99704 Level 15 SF99703 Level 26 Not supported
 IBM i System Limits pruning global variables Base SF99704 Level 15 SF99703 Level 26 Not supported
Query Supervisor Base SF99704 Level 13 SF99703 Level 24 Not supported
QSYS2.SYSCOLUMNS2 Base SF99704 Level 13 SF99703 Level 24 Not supported
QSYS2.SYSPACKAGESTAT Base SF99704 Level 13 SF99703 Level 24 Not supported
QSYS2.END_IDLE_SQE_THREADS Base SF99704 Level 13 SF99703 Level 24 Not supported
QSYS2.GENERATE_SQL procedure output to IFS Base SF99704 Level 13 SF99703 Level 24 Not supported
QSYS2.GENERATE_SQL_OBJECTS procedure output to IFS Base SF99704 Level 13 SF99703 Level 24 Not supported
QSQGNDDL API output to IFS Base SF99704 Level 13 SF99703 Level 24 Not supported
--- Enhancements from 2020 ---
RELATED_OBJECTS table function Base SF99704 Level 10 SF99703 Level 22 Not supported
SYSCOLUMNS2_SESSION view Base SF99704 Level 10 SF99703 Level 22 Not supported
QSYS2.SYSPARTITIONSTAT and QSYS2.SYSTABLESTAT views Base SF99704 Level 7 SF99703 Level 18 Not supported
OVERRIDE_QAQQINI procedure Base SF99704 Level 7 SF99703 Level 18 Not supported
--- Enhancements from 2019 ---
Allow RI children to be added without an exclusive lock Base SF99704 Level 4 Not supported Not supported
Extend ALLOW_DDL_WHILE_OPEN for grant and revoke authorities  Base SF99704 Level 4 SF99703 Level 16 Not supported
Add SUPPRESS_INQUIRY_MESSAGES Base SF99704 Level 4 SF99703 Level 16 Not supported
New columns added to QSYS2.SYSINDEXSTAT Base SF99704 Level 4 SF99703 Level 16 Not supported
Health attributes added to the SQL Plan Cache Properties Base SF99704 Level 1 SF99703 Level 15 Not supported
Alerts for IBM i System Limits Base SF99704 Level 1 SF99703 Level 15 Not supported
Tracking Important System Limits Base SF99704 Level 1 SF99703 Level 15 Not supported
--- Enhancements from 2018 ---
QSYS2.GENERATE_SQL_OBJECTS procedure Base Base SF99703 Level 11 SF99702 Level 23
QSYS2.SYSPARTITIONSTAT enhancement Base Base SF99703 Level 11 SF99702 Level 23
QSYS2.PARSE_STATEMENT() table function enhancement Base Base SF99703 Level 11 SF99702 Level 23
--- Enhancements from 2016 ---
QSYS2.PARSE_STATEMENT() table function Base Base SF99703 Level 3
SF99702 Level 14
--- 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 SF99702 Level 11
Add columns to QSYS2.SYSPROGRAMSTMTSTAT for SQL dependency level and IBM i Service dependency level Base Base Base SF99702 Level 11
Detail about the lock holder on SQL0913 failures Base Base Base SF99702 Level 11
Honor priority change for parallel index build Base Base Base SF99702 Level 5
ALTER TABLE ADD PARTITION preserves spanning DDS keyed logical files Base Base Base SF99702 Level 5

Older Enhancements:

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Document Information

Modified date:
02 May 2022

UID

ibm11116627