CONFIGURATION_STATUS view

The CONFIGURATION_STATUS view returns one row for each configuration description on the system.

The information returned is similar to the detail returned by the Retrieve Configuration Status (RTVCFGSTS) CL command.

Authorization: See Note below.

The following table describes the columns in the view. The system name is CONFIG_STS. The schema is SYSTOOLS.

Table 1. CONFIGURATION_STATUS view
Column Name System Column Name Data type Description
OBJECT_NAME NAME VARCHAR(10) The name of the configuration description.
OBJECT_TYPE TYPE VARCHAR(5) The type of configuration description.
*CTLD
Controller description
*DEVD
Device description
*LIND
Line description
*NWID
Network interface description
*NWSD
Network interface description
OBJECT_ATTRIBUTE ATTR VARCHAR(10) The object attribute of the configuration description.
STATUS STATUS INTEGER The status value.
STATUS_DESCRIPTION STATUS_D VARCHAR(20) The descriptive status value.
TEXT_DESCRIPTION TEXT VARCHAR(50)
Nullable
 The text description for the configuration object.

Contains the null value if a description is not available.
CREATE_TIMESTAMP CREATED TIMESTAMP(0) The timestamp when the configuration description was created.
LAST_USED_TIMESTAMP LAST_USED TIMESTAMP(0)
Nullable
 The timestamp when the configuration description was most recently used.

Contains the null value if a value is not available or it has not been used.
CHANGE_TIMESTAMP CHANGED TIMESTAMP(0) The timestamp when the configuration description was most recently changed.

Note

This function is provided in the SYSTOOLS schema as an example of how SQL can return information from a CL program. Similar to other Db2® for i provided tools within SYSTOOLS, the SQL source can be extracted and used as a model for building similar helper functions, or to create a customized version within a user-specified schema.

Services provided in SYSTOOLS have authorization requirements that are determined by the interfaces used to implement the service. To understand the authority requirements, extract the SQL for the service and examine the implementation.

Example

List the status of all controllers.
SELECT OBJECT_NAME, OBJECT_ATTRIBUTE, STATUS_DESCRIPTION, TEXT_DESCRIPTION 
  FROM SYSTOOLS.CONFIGURATION_STATUS
  WHERE OBJECT_TYPE = '*CTLD';