GROUP_PTF_INFO view

The GROUP_PTF_INFO view contains information about the group PTFs for the server.

The information returned is similar to the information available from Work with PTF Groups (WRKPTFGRP) CL command.

The following table describes the columns in the view. The system name is GRPPTFINFO. The schema is QSYS2.

Table 1. GROUP_PTF_INFO view
Column name System column name Data type Description
COLLECTED_TIME COLLE00001 TIMESTAMP Date and time of when this row information was generated.
PTF_GROUP_NAME PTF_G00001 VARCHAR(60)
Nullable
Name of the PTF group.
PTF_GROUP_DESCRIPTION PTF_G00002 VARCHAR(100)
Nullable
Description of the PTF group.
PTF_GROUP_LEVEL PTF_G00003 INTEGER
Nullable
Level of the PTF group.
PTF_GROUP_TARGET_RELEASE PTF_G00004 VARCHAR(6)
Nullable
Release level for PTF group.
PTF_GROUP_STATUS PTF_G00005 VARCHAR(20)
Nullable
Status of the PTF group.
UNKNOWN
The PTF group status cannot be resolved because a related PTF group is either not found on the system or is in error.
NOT APPLICABLE
All PTFs in the PTF group and related PTF groups are for products that are not installed or supported on this system.
SUPPORTED ONLY
There are no PTFs in the PTF group or related PTF groups that are for installed products on this system. There is at least one PTF that is for a product, release, option, and load identifier that is supported on this system.
NOT INSTALLED
There is at least one PTF that is for an installed product on this system, and not all of the PTFs or their superseding PTFs are temporarily or permanently applied.
INSTALLED
All PTFs for products that are installed on this system are temporarily or permanently applied. If a PTF is superseded, a superseding PTF is either temporarily or permanently applied.
ERROR
The PTF group information is in error. Either delete the PTF group or replace the PTF group information that is currently on the system.
APPLY AT NEXT IPL
All PTFs for the installed products on the system are either set to be applied at the next IPL or are already temporarily or permanently applied.
RELATED GROUP
The PTF group does not have any PTFs for products installed or supported on the system. However, it is identified in another PTF group as a related PTF group. Deleting a PTF group in this status will cause the other PTF group to have a status of UNKNOWN.
ON ORDER
There is at least one PTF in the group that is on order and has not yet been installed on the system. It will be delivered on either physical or virtual media.

Example

Determine the level of the latest CUM PTF group installed on the system.

SELECT MAX(PTF_GROUP_LEVEL) AS CUM_LEVEL 
  FROM QSYS2.GROUP_PTF_INFO
  WHERE PTF_GROUP_NAME IN ('SF99610','SF99710')
        AND PTF_GROUP_STATUS = 'INSTALLED'