PTF_INFO view
The PTF_INFO view contains information about PTFs for the server.
The information returned is similar to QpzListPTF API.
Authorization:
The caller must have *USE authority to the Display Program Temporary Fix (DSPPTF)
command.
The following table describes the columns in the view. The schema is QSYS2.
Column name | System column name | Data type | Description |
---|---|---|---|
PTF_PRODUCT_ID | LICPGM | VARCHAR(7) Nullable
|
Product identifier. |
PTF_PRODUCT_OPTION | PRODOPT | VARCHAR(6) Nullable
|
Product option. |
![]() ![]() |
![]() ![]() |
![]() Nullable
![]() |
![]() ![]() |
PTF_PRODUCT_RELEASE_LEVEL | PRODRLS | VARCHAR(6) Nullable
|
Product release level. |
PTF_PRODUCT_DESCRIPTION | PRODDESC | VARCHAR(132) Nullable
|
Product description. |
PTF_IDENTIFIER | PTFID | VARCHAR(7) Nullable
|
The identifier of the PTF. |
PTF_RELEASE_LEVEL | PTFRLS | VARCHAR(6) Nullable
|
The release level of the PTF. |
PTF_PRODUCT_LOAD | PRODLOAD | VARCHAR(4) Nullable
|
The load ID of the product load for the PTF. |
PTF_LOADED_STATUS | LOADSTAT | VARCHAR(19) Nullable
|
The current loaded status of the PTF.
|
PTF_SAVE_FILE | SAVF | VARCHAR(3) Nullable
|
Indicates whether a save file exists for the PTF.
|
PTF_COVER_LETTER | COVER | VARCHAR(3) Nullable
|
Indicates whether a cover letter exists for the PTF.
|
PTF_ON_ORDER | ONORD | VARCHAR(3) Nullable
|
Indicates whether the PTF has been ordered.
|
PTF_IPL_ACTION | IPLACT | VARCHAR(19) Nullable
|
The action to be taken on this PTF during the next unattended
IPL.
|
PTF_ACTION_PENDING | ACTPEND | VARCHAR(3) Nullable
|
Indicates whether a required action has yet to be performed
to make this PTF active.
|
PTF_ACTION_REQUIRED | ACTREQ | VARCHAR(12) Nullable
|
Indicates whether an action is required to make this PTF active
when it is applied. See the cover letter to determine what action
needs to be taken.
|
PTF_IPL_REQUIRED | IPLREQ | VARCHAR(9) Nullable
|
Indicates whether an IPL is required to apply this PTF.
|
PTF_IS_RELEASED | RELEASED | VARCHAR(3) Nullable
|
Indicates whether the PTF save file is available for distribution to another system. This is set to YES only when the System Manager for IBM® i licensed program is on the system and the product is supported. The PTF_SAVE_FILE column must have a value of YES before
using the value in this column.
|
PTF_MINIMUM_LEVEL | MINLVL | VARCHAR(2) Nullable
|
The indicator of the lowest level of the product to which this
PTF can be applied. The level can be AA to 99. Contains the null value if the product does not have a level. |
PTF_MAXIMUM_LEVEL | MAXLVL | VARCHAR(2) Nullable
|
The indicator of the highest level of the product to which
this PTF can be applied. The level can be AA to 99. Contains the null value if the product does not have a level. |
PTF_STATUS_TIMESTAMP | STATTIME | TIMESTAMP Nullable
|
The date and time that the PTF status was last changed. Contains the null value when the status date and time is not available. |
![]() ![]() |
![]() ![]() |
![]() Nullable
![]() |
![]() This field will be blank when the PTF is not superseded or when the superseding PTF has not been loaded on the system. ![]() |
![]() ![]() |
![]() ![]() |
![]() Nullable
![]() |
![]() Contains the null value when PTF_LOADED_STATUS is not PERMANENTLY APPLIED or SUPERSEDED. ![]() |
PTF_CREATION_TIMESTAMP | CRTTIME | TIMESTAMP Nullable
|
The date and time that the PTF was created. Contains the null value when the creation date and time cannot be determined. |
PTF_TECHNOLOGY_REFRESH_PTF | TRPTF | VARCHAR(3) Nullable
|
Indicates whether this is a technology refresh
PTF.
|
PTF_TEMPORARY_APPLY_TIMESTAMP | TMPTIME | TIMESTAMP Nullable
|
The date and time that the PTF was temporarily
applied. Contains the null value if the PTF has not been temporarily applied. |
Examples
- Find which PTFs will be impacted by the next IPL.
SELECT PTF_IDENTIFIER, PTF_IPL_ACTION, A.* FROM QSYS2.PTF_INFO A WHERE PTF_IPL_ACTION <> 'NONE‘
- Find which PTFs are loaded but not applied.
SELECT PTF_IDENTIFIER, PTF_PRODUCT_DESCRIPTION, A.* FROM QSYS2.PTF_INFO A WHERE PTF_LOADED_STATUS = 'LOADED' ORDER BY PTF_PRODUCT_ID