Db2 for i - Technology Updates Main Landing Page
|Db2 for i updates by PTF Group and year|
|Db2 for i PTF Groups - 2021|
|Db2 for i PTF Groups - 2020|
|Db2 for i PTF Groups - 2019|
|Db2 for i PTF Groups - 2018|
|Db2 for i updates by category|
|Db2 for i Functional Enhancements|
|Db2 for i Security Enhancements|
|Db2 for i Performance Enhancements|
|Db2 for i Database Engineer (DBE) Enhancements|
|OmniFind for IBM i|
|IBM i Services (SQL)|
- Not all Db2 for i improvements are listed here.
Only the more significant enhancements are listed.
Does not include many performance enhancements since they are typically automatic. Performance enhancements are only listed if they are not automatic or are too significant not to mention.
- Instead of listing individual PTFs, Db2 for i enhancements are denoted by the DB PTF Group level in which they were enabled.
Use the WRKPTFGRP (Work with PTF Groups) command or the QSYS2.GROUP_PTF_INFO SQL view to determine the PTF Group level.
SELECT CHAR(PTF_GROUP_NAME, 7) as GRPPTF, PTF_GROUP_LEVEL FROM QSYS2.GROUP_PTF_INFO WHERE PTF_GROUP_NAME IN ('SF99704', 'SF99703') AND PTF_GROUP_STATUS = 'INSTALLED' ORDER BY PTF_GROUP_LEVEL DESC FETCH FIRST 1 ROWS ONLY
13 April 2021