PTF_INFO view

The PTF_INFO view contains information about PTFs for the server.

The information returned is similar to QpzListPTF API.

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

Table 1. PTF_INFO view
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.
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.
NOT LOADED
The PTF has never been loaded.
LOADED
The PTF has been loaded.
APPLIED
The PTF has been temporarily applied.
PERMANENTLY APPLIED
The PTF has been applied permanently.
PERMANENTLY REMOVED
The PTF has been permanently removed.
DAMAGED
The PTF is damaged. An error occurred while applying the PTF. It needs to be reloaded and applied.
SUPERCEDED
The PTF is superseded. A PTF will have a status of superseded when one of the following situations occurs:
  • Another PTF with a more recent correction for the problem has been loaded on the system. The PTF ID that has been loaded can be found in the PTF_SUPERCEDED_BY_PTF column.
  • The PTF save file for another PTF with a more recent correction for the problem has been logged into *SERVICE on the system.
PTF_SAVE_FILE SAVF VARCHAR(3)
Nullable
Indicates whether a save file exists for the PTF.
NO
The PTF has no save file.
YES
The PTF has a save file.
PTF_COVER_LETTER COVER VARCHAR(3)
Nullable
Indicates whether a cover letter exists for the PTF.
NO
The PTF has no cover letter.
YES
The PTF has a cover letter.
PTF_ON_ORDER ONORD VARCHAR(3)
Nullable
Indicates whether the PTF has been ordered.
NO
The PTF has not been ordered or has already been received.
YES
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.
NONE
No action occurs at the next IPL.
TEMPORARILY APPLIED
The PTF is temporarily applied at the next IPL.
TEMPORARILY REMOVED
The PTF is temporarily removed at the next IPL.
PERMANENTLY APPLIED
The PTF is permanently applied at the next IPL.
PERMANENTLY REMOVED
The PTF is permanently removed at the next IPL.
PTF_ACTION_PENDING ACTPEND VARCHAR(3)
Nullable
Indicates whether a required action has yet to be performed to make this PTF active.
NO
No required actions are pending for this PTF.
YES
A required action needs to occur for this PTF to be active. Check the Activation Instructions section of the cover letter to determine what the action is. If the PTF_ACTION_REQUIRED column is set to IPL and the activation instructions have been performed, then the PTF is active. However, this column will not be updated until the next IPL.
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.
NONE
No activation instructions are needed for this PTF.
EXIT PROGRAM
This PTF was shipped with activation instructions in the cover letter. This value is returned for all PTFs that have an exit program to update the status of the PTF after the activation instructions have been performed.
IPL
This PTF was shipped with activation instructions in the cover letter. No exit program exists to verify the activation instructions were performed.
PTF_IPL_REQUIRED IPLREQ VARCHAR(9)
Nullable
Indicates whether an IPL is required to apply this PTF.
DELAYED
The PTF is delayed. The PTF must be applied during an IPL.
IMMEDIATE
The PTF is immediate. No IPL is needed to apply the PTF.
UNKNOWN
The type of the PTF is not known.
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.
NO
The PTF save file cannot be distributed.
YES
The PTF save file is released and can be distributed to another system.
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.

PTF_SUPERCEDED_BY_PTF SUPERCEDE VARCHAR(7)
Nullable
The identifier of the PTF that has replaced this PTF.

This field will be blank when the PTF is not superseded or when the superseding PTF has not been loaded on the system.

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.
NO
This is not a technology refresh PTF.
YES
This is a technology refresh PTF.
Start of changePTF_TEMPORARY_APPLY_TIMESTAMPEnd of change Start of changeTMPTIMEEnd of change Start of changeTIMESTAMP
Nullable
End of change
Start of changeThe date and time that the PTF was temporarily applied.

Contains the null value if the PTF has not been temporarily applied.

End of change

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