SOFTWARE_PRODUCT_INFO view

The SOFTWARE_PRODUCT_INFO view returns information about software products.

The values returned for the columns in the view are closely related to the values returned by the Display Software Resources (DSPSFWRSC) command and the Retrieve Product Information (QSZRTVPR) API.

Authorization: None required.

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

Table 1. SOFTWARE_PRODUCT_INFO view
Column Name	System Column Name	Data Type	Description
PRODUCT_ID	PRODUCT_ID	VARCHAR(7)	The product ID.
PRODUCT_OPTION	PROD_OPT	VARCHAR(5)	The product option of the product. Can contain the following special value: *BASE The base part of the product.
LOAD_ID	LOAD_ID	VARCHAR(4)	The load ID of the product load for which information was returned.
LOAD_TYPE	LOAD_TYPE	VARCHAR(8)	The type of load. CODE The load is a code load. LANGUAGE The load is a language load.
RELEASE_LEVEL	RELEASE	VARCHAR(10)	The release level of the product selected.
INSTALLED	INSTALLED	VARCHAR(3)	Whether the code load for this product option is installed. A load is installed if a product load (*PRDLOD) object is loaded on the system by the Restore Licensed Program (RSTLICPGM) command. NO The code load for this product option is not installed. YES The code load for this product option is installed.
SYMBOLIC_LOAD_STATE	SYM_STATE	VARCHAR(9)	The symbolic state of the load for which information was returned. This value, in conjunction with the LOAD_ERROR column, can be used to determine if the load is installed correctly. CREATED The product load object for this load exists. DAMAGED If this is for an option other than the base option or for a language load for the base option, the product load object has been damaged. If this is for the code load for the base option, one of the following happened: The product definition for this product ID and release level has been damaged. The product load object has been damaged. DEFINED The load is defined. The product load object for this load does not exist. INSTALLED The product load (*PRDLOD) object for this load was loaded onto the system by the RSTLICPGM command. LOADED Indicates one of the following: A restore licensed program function is in progress. A delete licensed program function is in progress. PACKAGED The product load object for this load has been packaged with the PKGPRDOPT command.
LOAD_ERROR	LOAD_ERROR	VARCHAR(3)	Whether there is a known error for this load. NO No error was found the last time that the state of this load was checked or updated. YES An error was found the last time that the state of this load was checked or updated.
LOAD_STATE	LOAD_STATE	CHAR(2)	The state of the load for which information was returned. 10 The load is defined. 20 The product load object for this load exists. 30 The product load object for this load has been packaged with the PKGPRDOPT command or the QSZPKGPO API. 32 The product load object for this load has been packaged with the PKGPRDOPT command or the QSZPKGPO API. Either a development library or folder was renamed, but the product does not allow dynamic naming, or the product definition or product load for a packaged load was renamed or moved to another library. 33 The product load object for this load has been packaged with the PKGPRDOPT command or the QSZPKGPO API. However, an object was found to be damaged the last time that the CHKPRDOPT command or SAVLICPGM command was used for this load. 34 The product load object for this load has been packaged with the PKGPRDOPT command or the QSZPKGPO API. Either an attempt was made to delete the product load using the delete licensed program function and the function failed, or a packaged object was missing the last time that the CHKPRDOPT command or SAVLICPGM command was used for this load. 35 A RSTLICPGM command is in progress. The product being replaced had been packaged, but not installed. 38 A DLTLICPGM command is in progress. The product being deleted had been packaged, but not installed. 3E A RSTLICPGM command did not complete successfully. A preoperation exit program failed. The product being replaced had been packaged, but not installed. 3F A RSTLICPGM command failed. A preoperation exit program did not fail. The product being replaced had been packaged, but not installed. 50 A RSTLICPGM command is in progress. The product being replaced had been installed. 53 A DLTLICPGM command is in progress. The product being deleted had been installed. 59 This product is an IBM-supplied product, and it is not compatible with the currently installed release level of the operating system.
LOAD_STATE (continued)			60 The product load object for this load was loaded onto the system by the RSTLICPGM command. 61 The product load object for this load was loaded onto the system by the RSTLICPGM command, but a postoperation exit program failed. 62 An installed library or folder was renamed, but the product does not allow dynamic naming. 63 The product load object for this load was installed by the RSTLICPGM command, but an object is damaged. 64 The product load object for this load was installed by the RSTLICPGM command, but an object was found to be missing when CHKPRDOPT or SAVLICPGM was used, or an error occurred while DLTLICPGM was being used. 67 The CHKPRDOPT command was used for this product load, but the postoperation exit program failed or indicated that an error was found. 6E A RSTLICPGM command did not complete successfully. 6F A RSTLICPGM command failed. 90 The product load was installed successfully. If an object was missing or was damaged, and the problem was corrected, using the CHKPRDOPT command sets the state back to 90.
SUPPORTED	SUPPORTED	VARCHAR(3)	Whether this load is currently supported. A load can be supported by using the Work with Supported Products (WRKSPTPRD) command in the System Manager for IBM i licensed program. NO This load is not currently supported. YES This load is currently supported.
COMPATIBLE	COMPATIBLE	VARCHAR(3) Nullable	Indicates whether this IBM product is compatible with the current release. NO The product is not compatible. YES The product is compatible. Contains the null value if this product does not have a compatibility value.
PRODUCT_LIBRARY_COUNT	LIB_COUNT	INTEGER	The number of product libraries included in the PRODUCT_LIBRARIES column.
PRODUCT_LIBRARIES	PROD_LIB	VARCHAR(120) Nullable	The list of product load libraries. Each library name entry is ten characters long with one blank separating entries. Contains the null value if PRODUCT_LIBRARY_COUNT is 0.
PRODUCT_DIRECTORY_COUNT	DIR_COUNT	INTEGER	The number of product directories included in the PRODUCT_DIRECTORIES column.
PRODUCT_DIRECTORIES	PROD_DIR	DBCLOB(5M) CCSID 1200 Nullable	The list of product directories. Directory entries are separated by the string ' -- ' (a blank, two minus signs, and a blank). Contains the null value if PRODUCT_DIRECTORY_COUNT is 0.
TEXT_DESCRIPTION	TEXT	VARCHAR(132) Nullable	Text description for this product option. Contains the null value if there is no text description or the text description is not available.
PRIMARY_LANGUAGE_LOAD_ID	LANG_ID	CHAR(4) Nullable	For code loads, this field contains the primary language of the product option. Contains the null value for language loads and for code loads when no language is installed in the libraries for the code load.
RELEASE_DATE	REL_DATE	DATE Nullable	Indicates the value specified for the release date when the product definition for this product load was created. Contains the null value if no release date was specified.
MINIMUM_TARGET_RELEASE	MIN_TGTRLS	CHAR(6)	The minimum release of the operating system to which the Save Licensed Program (SAVLICPGM) command will allow the product to be saved.
MINIMUM_VRM_BASE	MIN_BASE	CHAR(6) Nullable	The minimum release level that is allowed for the BASE option that will run with the current level of the option for the product. Can containing the following special value: MATCH The release of the option matches that of the *BASE. Contains the null value for Licensed Internal Code.
REQUIREMENTS_MET	REQ_MET	INTEGER	The reason why the release requirements between the base and option may or may not be in error. 0 There is not enough information available to determine if the release requirements have been met. This value if always returned for a load type of LANG. 1 The releases of the BASE and option meet all requirements. 2 The release of the option is too old compared to the BASE. 3 The release of the BASE is too old compared to the option.
MIXED_RELEASES	MIXED_REL	VARCHAR(3)	Product allows mixed releases. NO The BASE option and other options of this product cannot be at different release levels. YES The BASE option and other options of this product can be at different release levels.
LEVEL_ID	LEVEL_ID	CHAR(3) Nullable	The level identifier of the product for which information was returned. The format is Lxx. Contains the null value for all products other than the operating system and Licensed Internal Code.
REGISTRATION_TYPE	REG_TYPE	CHAR(2)	The registration type associated with the product. The registration type and registration value together make up the registration ID for the product.
REGISTRATION_VALUE	REG_VALUE	VARCHAR(14)	The registration value associated with the product.

Example

List any licensed programs that are in an error state.

SELECT *
  FROM QSYS2.SOFTWARE_PRODUCT_INFO
  WHERE LOAD_ERROR = 'YES';