WORKLOAD_GROUP_INFO view
The WORKLOAD_GROUP_INFO view returns information about workload groups including their product entries.
The values returned for the columns in the view are closely related to the detail generated by the DSPWLCGRP CL command and the Retrieve Workload Groups Information (QLZRTVWC) API.
Authorization: The caller must have *USE authority to the QSYS/QLZRTVWC program.
The following table describes the columns in the view. The system name is WLG_INFO. The schema is QSYS2.
Column Name | System Column Name | Data Type | Description |
---|---|---|---|
WORKLOAD_GROUP | WL_GRP | VARCHAR(10) | The workload group name. |
PROCESSOR_LIMIT | PROC_LIMIT | INTEGER | The processor limit for jobs and threads associated with this workload group. Values are 1-256. |
NUMBER_OF_PRODUCTS | PROD_COUNT | INTEGER | Number of products defined for this workload group. The view returns one row for each of the products defined for a specific WORKLOAD_GROUP value. |
PRODUCT_ID | LICPGM | VARCHAR(7) Nullable
|
The identifier of the product. Contains the null value if NUMBER_OF_PRODUCTS is 0. |
LICENSE_TERM | LIC_TERM | VARCHAR(6) Nullable
|
The license term associated with this workload group, in one of the
following formats:
Contains the null value if NUMBER_OF_PRODUCTS is 0. |
FEATURE_ID | FEATURE | VARCHAR(4) Nullable
|
The feature number of the product associated with this workload
group. Values are 5001 to 9999. Contains the null value if NUMBER_OF_PRODUCTS is 0. |
Example
- Return information about all workload
groups.
SELECT * FROM QSYS2.WORKLOAD_GROUP_INFO;