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.
Authorization:
The caller must have *USE authority to the Work with PTF Groups (WRKPTFGRP)
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.
|
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'