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 License 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.
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.
|
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.
|
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.
|
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 | 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.
|
LOG_VIOLATION | LOG | VARCHAR(3) | Specifies whether or not requests
exceeding the usage limit are logged in the QUSRSYS/QLZALOG journal.
|
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:
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;