LICENSE_INFO view

The LICENSE_INFO view contains information about all products or features that contain license information.

The values returned for the columns in the view are similar to the values returned by the Work with Licence Information (WRKLICINF) CL command or Retrieve License Information (QLZARTV) API. Refer to the API for more detailed information.

Authorization: None required.

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

Table 1. LICENSE_INFO view
Column Name	System Column Name	Data Type	Description
PRODUCT_ID	LICPGM	VARCHAR(7)	The identifier of the product.
LICENSE_TERM	LIC_TERM	VARCHAR(6)	The license term indicates whether the authorized usage limit for a product exists until the next version, next release, or next modification level of the product. Vx or vv for products licensed by version. VxRy or vvrr for products licensed by release. VxRyMz or vvrrmm for products licensed by modification.
RELEASE_LEVEL	RLS_LVL	VARCHAR(6)	The version, release, and modification level of the product in either VxRyMz or vvrrmm format.
FEATURE_ID	FEATURE	VARCHAR(4)	The feature number of the product.
INSTALLED	INSTALLED	VARCHAR(3)	Indicates whether this feature number of the product is installed. NO The feature is not installed. YES The feature is installed.
PROCESSOR_GROUP	PROC_GROUP	VARCHAR(3)	The processor group of this system.
PRODUCT_TEXT	LABEL	VARGRAPHIC(50) CCSID 1200 Nullable	The description of the product or feature. Contains null if there is no description text.
USAGE_LIMIT	USG_LIMIT	INTEGER Nullable	The usage limit of the product or feature that contains license information. Values are 0-999999 indicating the number of users allowed to access the product. Contains null if there is no usage limit.
USAGE_LIMIT_UPDATED	USG_UPDATE	TIMESTAMP(0) Nullable	The timestamp when the usage limit was last updated. Contains null if the usage limit has never been updated.
USAGE_TYPE	USAGE_TYPE	VARCHAR(11)	The usage type of the license. CONCURRENT The usage type is concurrent, meaning the usage limit is for the number of uses held by unique jobs using the product or feature at the same time. REGISTERED The usage type is registered, meaning the usage limit is for the number of uses held by license users registered to use the product or feature. *PROCESSOR The usage type is processor, meaning the usage limit is for the number of processors on system partitions where this product or feature is in use.
USAGE_COUNT	USG_COUNT	DECIMAL(8,2)	The current usage count for the product or feature. Valid values are 0 through 999999. If the product is using processor usage type, the usage count value is rounded up to the next whole number.
GLOBAL_COUNT	GLOB_COUNT	DECIMAL(8,2)	The number of jobs currently using this product or feature across all system partitions.
LICENSED_USER_COUNT	LIC_COUNT	INTEGER	The number of current license users.
THRESHOLD	THRESHOLD	DECIMAL(10,2) Nullable	The usage limit threshold for this product or feature. Contains null if there is no usage limit threshold.
PEAK_USAGE	PEAK_USAGE	DECIMAL(10,2)	For concurrent usage, the maximum number of uses held by license users of the product or feature at one time. For registered usage, the maximum number of uses that have been registered through license users for the product or feature. For processor usage, the maximum number of processors configured for this system partition while this product or feature was in use.
LAST_PEAK_USAGE	LAST_PEAK	TIMESTAMP(0) Nullable	The timestamp when the peak usage of the product or feature last occurred since the peak usage was reset to zero. Contains null if the product has not been used since the peak usage was reset to zero.
COMPLIANCE_TYPE	COMP_TYPE	VARCHAR(10)	The compliance type of the program determines the action taken when the usage limit of the product or feature is exceeded. OPRACTION License requests are denied and failure messages are sent. WARNING A warning message is sent. *KEYED Requests for licenses over the usage limit are allowed for the number of days in the product's grace period. Once the grace period ends, the license users holding uses over the usage limit will be released and no requests for uses over the limit will be granted until a new license key is received from the software provider. The expiration date is the date the license will expire. After the expiration date is reached, the default usage limit is in effect. When a request for a license is received after the usage limit has been reached, the system sends a warning message to the system operator message queue and to any additional message queues defined for the product.
LOG_VIOLATION	LOG	VARCHAR(3)	Specifies whether or not requests exceeding the usage limit are logged in the QUSRSYS/QLZALOG journal. NO The requests for a license when the usage count is greater than or equal to the usage limit will not be logged. YES The requests for a license when the usage count is greater than or equal to the usage limit will be logged.
LICENSE_EXPIRATION	EXPIR_DATE	DATE Nullable	The date the license will expire. After the expiration date is reached, the usage limit is reset to the default usage limit. Contains null if the license has no expiration date.
GRACE_PERIOD	GRACE_PRD	INTEGER	The number of days a user has to obtain a new license key after a product or feature exceeds its usage limit.
GRACE_END	GRACE_END	DATE Nullable	The date the grace period expires. When a request for license uses exceeds the usage limit for a product or feature, the date the grace period expires is determined by adding the number of days in the grace period to the current date. Contains null if there is no grace period or the grace period has expired.
VENDOR_DATA	VENDOR	VARCHAR(8)	Information the vendor defined when the key was added using the Add License Key Information (ADDLICKEY) command.
MESSAGE_QUEUE1	MESSAGE_1	VARCHAR(10) Nullable	The name of the first message queue to which messages will be sent. Each of these message queues, in addition to the system operator message queue, will be sent a messages if one of the following occurs: The usage count threshold is met. A license request is made, and the usage count is equal to or greater than the usage limit. The usage limit is changed. The messages sent include: CPI9E10 - License usage limit changed for product &1. CPI9E19 - Usage limit threshold exceeded. CPI9E75 - Grace period will expire on &3. CPI9E76 - Expiration date will be reached on &3. Contains null if there is no first message queue.
MESSAGE_QUEUE_LIBRARY1	LIBRARY_1	VARCHAR(10) Nullable	The library containing the first message queue. Contains null if there is no first message queue.
MESSAGE_QUEUE2	MESSAGE_2	VARCHAR(10) Nullable	The name of the second message queue to which messages will be sent. Contains null if there is no second message queue.
MESSAGE_QUEUE_LIBRARY2	LIBRARY_2	VARCHAR(10) Nullable	The library containing the second message queue. Contains null if there is no second message queue.
MESSAGE_QUEUE3	MESSAGE_3	VARCHAR(10) Nullable	The name of the third message queue to which messages will be sent. Contains null if there is no third message queue.
MESSAGE_QUEUE_LIBRARY3	LIBRARY_3	VARCHAR(10) Nullable	The library containing the third message queue. Contains null if there is no third message queue.
MESSAGE_QUEUE4	MESSAGE_4	VARCHAR(10) Nullable	The name of the fourth message queue to which messages will be sent. Contains null if there is no fourth message queue.
MESSAGE_QUEUE_LIBRARY4	LIBRARY_4	VARCHAR(10) Nullable	The library containing the fourth message queue. Contains null if there is no fourth message queue.
MESSAGE_QUEUE5	MESSAGE_5	VARCHAR(10) Nullable	The name of the fifth message queue to which messages will be sent. Contains null if there is no fifth message queue.
MESSAGE_QUEUE_LIBRARY5	LIBRARY_5	VARCHAR(10) Nullable	The library containing the fifth message queue. Contains null if there is no fifth message queue.

Example

Return information about all licensed products and features that will expire within the next 2 weeks.

SELECT * FROM QSYS2.LICENSE_INFO
   WHERE LICENSE_EXPIRATION <= CURRENT DATE + 14 DAYS;