WORKLOAD_GROUP_INFO view

Edit online

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.

Table 1. WORKLOAD_GROUP_INFO view
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:
Vx, VxRy, or VxRyMz
where x and y are a number from 0 through 9, and z is a number 0 through 9 or a letter A through Z
vv, vvrr, or vvrrmm
where vv and rr are a number from 00 through 35, and mm is a number 00 through 09 or a letter sequence 0A through 0Z.

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;