IBM Support

Db2 for i - Technology Updates

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 - 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 Management 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.

    Example SQL:

    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

This pdf shows all the Db2 for i catalog tables, Db2 for i Services, the IBM i Services: Landscape

[{"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

ibm11116645