PTF_INFO view

The PTF_INFO view contains information about PTFs for the server.

The information returned is similar to QpzListPTF API.

Authorization: Start of change The caller must have *USE authority to the Display Program Temporary Fix (DSPPTF) command. End of change

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_OPTION_2	PRODOPT2	VARCHAR(6) Nullable	Product option. The column contains the optional part number or *BASE.
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. SUPERSEDED 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_SUPERSEDED_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_SUPERSEDED_BY_PTF	SUPERSEDE	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_LATEST_SUPERSEDING_PTF	LATEST_PTF	VARCHAR(7) Nullable	The identifier of the most recent PTF that has superseded this PTF. 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. NO This is not a technology refresh PTF. YES 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