News
Abstract
Db2 for i - Technology Updates Main Landing Page
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates
| Db2 for i updates by PTF Group and year |
|---|
| Db2 for i PTF Groups - 2023 |
| Db2 for i PTF Groups - 2022 |
| Db2 for i PTF Groups - 2021 |
| Db2 for i PTF Groups - 2020 |
| Db2 for i PTF Groups - 2019 |
| Db2 for i PTF Groups - 2018 |
- 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.
Example SQL:
SELECT CHAR(PTF_GROUP_NAME, 7) as GRPPTF, PTF_GROUP_LEVEL FROM QSYS2.GROUP_PTF_INFO WHERE PTF_GROUP_NAME IN ('SF99950', 'SF99704', 'SF99703') AND PTF_GROUP_STATUS = 'INSTALLED' ORDER BY PTF_GROUP_LEVEL DESC LIMIT 1;
[{"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"}}]
Was this topic helpful?
Document Information
Modified date:
11 April 2023
UID
ibm11116645