News
Abstract
Db2 for i - Technology Updates Main Landing Page
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates
- 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;
[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000CHeAAM","label":"IBM i Db2"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
16 November 2023
UID
ibm11116645