IBM Support

Db2 for i Database Management Enhancements

News


Abstract

Db2 for i Database Management Enhancements Landing Page

Content

You are in: IBM i Technology Updates > Db2 for i - Technology Updates >  Db2 for i Database Management Enhancements
Db2 for i Enhancement IBM i 7.4 IBM i 7.3 IBM i 7.2
--- Enhancements from 2020 ---
RELATED_OBJECTS table function SF99704 Level 10 SF99703 Level 22
SYSCOLUMNS2_SESSION view SF99704 Level 10 SF99703 Level 22
QSYS2.SYSPARTITIONSTAT and QSYS2.SYSTABLESTAT views SF99704 Level 7 SF99703 Level 18
OVERRIDE_QAQQINI procedure SF99704 Level 7 SF99703 Level 18
--- Enhancements from 2019 ---
Allow RI children to be added without an exclusive lock SF99704 Level 4
Extend ALLOW_DDL_WHILE_OPEN for grant and revoke authorities  SF99704 Level 4 SF99703 Level 16
Add SUPPRESS_INQUIRY_MESSAGES SF99704 Level 4 SF99703 Level 16
New columns added to QSYS2.SYSINDEXSTAT SF99704 Level 4 SF99703 Level 16
Health attributes added to the SQL Plan Cache Properties SF99704 Level 1 SF99703 Level 15
Alerts for IBM i System Limits SF99704 Level 1 SF99703 Level 15
Tracking Important System Limits SF99704 Level 1 SF99703 Level 15
--- Enhancements from 2018 ---
QSYS2.GENERATE_SQL_OBJECTS procedure Base SF99703 Level 11 SF99702 Level 23
QSYS2.SYSPARTITIONSTAT enhancement Base SF99703 Level 11 SF99702 Level 23
QSYS2.PARSE_STATEMENT() table function enhancement Base SF99703 Level 11 SF99702 Level 23
--- Enhancements from 2016 ---
QSYS2.PARSE_STATEMENT() table function Base SF99703 Level 3
SF99702 Level 14
--- Enhancements from 2015 ---
Fair lock option - PREVENT_ADDITIONAL_CONFLICTING_LOCKS Base Base Base
No lock option - ALLOW_DDL_CHANGES_WHILE_OPEN Base Base SF99702 Level 11
Add columns to QSYS2.SYSPROGRAMSTMTSTAT for SQL dependency level and IBM i Service dependency level Base Base SF99702 Level 11
Detail about the lock holder on SQL0913 failures Base Base SF99702 Level 11
Honor priority change for parallel index build Base Base SF99702 Level 5
ALTER TABLE ADD PARTITION preserves spanning DDS keyed logical files Base Base SF99702 Level 5

Older Enhancements:

Related Information

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB08","label":"Cognitive Systems"}}]

Document Information

Modified date:
04 October 2020

UID

ibm11116627