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.
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';