Start of change

ROUTING_ENTRY_INFO view

The ROUTING_ENTRY_INFO view returns information about routing entries.

The values returned for the columns in the view are closely related to the values returned by the Display Routing Entries panel accessed through the DSPSBSD (Display Subsystem Description) CL command and by the List Subsystem Entries (QWDLSBSE) API.

Authorization: The caller must have:
  • *USE authority to the subsystem description, and
  • *EXECUTE authority to the library containing the subsystem description.

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

Table 1. ROUTING_ENTRY_INFO view
Column Name System Column Name Data Type Description
SUBSYSTEM_DESCRIPTION_LIBRARY SBSD_LIB VARCHAR(10) The name of the library in which the subsystem description resides.
SUBSYSTEM_DESCRIPTION SBSD VARCHAR(10) The name of the subsystem about which information is being returned.
SEQUENCE_NUMBER SEQNO INTEGER The sequence number of the routing entry.
PROGRAM_LIBRARY PGM_LIB VARCHAR(10)
Nullable
The name of the library in which the routing entry program resides.

Contains the null value if PROGRAM_NAME is *RTGDTA.

PROGRAM_NAME PGM_NAME VARCHAR(10) The name of the program that is started when a routing step is started through this routing entry. Can contain the following special value:
*RTGDTA
The program name is taken from the routing data that was supplied and matched against this entry. The qualified program name will be taken from the routing data in this case, where the program name is specified in positions 37 through 46 and the library name is taken from positions 47 through 56.
CLASS_LIBRARY CLASS_LIB VARCHAR(10) The name of the library in which the routing entry class resides.
CLASS CLASS VARCHAR(10) The name of the class that is used when a routing step is started through this routing entry.
MAXIMUM_STEPS MAX_STEPS INTEGER
Nullable
The maximum number of routing steps (jobs) that can be active at the same time through this routing entry.

Contains the null value if the routing entry specifies *NOMAX, indicating that there is no maximum.

POOL_ID POOL_ID INTEGER The pool identifier of the storage pool in which the routing entry program is run.
COMPARISON_DATA COMPDATA VARCHAR(80) A value that is compared with the routing data to determine whether this is the routing entry that is used for starting a routing step. Can contain the following special value:
*ANY
Any routing data is considered a match.
COMPARISON_START COMP_START INTEGER
Nullable
The starting position for the routing data comparison. The comparison between the compare value and the routing data begins with this position in the routing data character string, and the last character position compared must be less than or equal to the length of the routing data used in the comparison.

Contains the null value when COMPARISON_DATA is *ANY.

RESOURCES_AFFINITY_GROUP RAG VARCHAR(3) Specifies whether jobs using this routing entry are grouped together having affinity to the same set of processors and memory.
NO
The jobs will not be grouped together. They will be spread across all the available system resources.
YES
The jobs will be grouped together such that they will have affinity to the same system resources.
THREAD_RESOURCES_AFFINITY_
GROUP
T_RAG VARCHAR(7) Specifies whether secondary threads running in jobs that started through this routing entry are grouped together with the initial thread, or spread across the system resources.
GROUP
Secondary threads will all have affinity to the same set of processors and memory as the initial thread.
NOGROUP
Secondary threads will not necessarily have affinity to the same set of processors and memory as the initial thread. They will be spread across all the available system resources.
SYSVAL
The thread resources affinity group and level in the QTHDRSCAFN system value will be used when the job starts.
THREAD_RESOURCES_AFFINITY_
LEVEL
T_RAL VARCHAR(6)
Nullable
The degree to which the system tries to maintain the affinity between threads and system resources.
HIGH
A thread will only use the resources it has affinity to, and will wait until they become available if necessary.
NORMAL
A thread will use any processor or memory in the system if the resources it has affinity to are not readily available.

Contains the null value when THREAD_RESOURCES_AFFINITY_GROUP is SYSVAL.

Example

  • List all the routing entries defined for the QBATCH subsystem.
    SELECT *
      FROM QSYS2.ROUTING_ENTRY_INFO 
      WHERE SUBSYSTEM_DESCRIPTION_LIBRARY = 'QSYS' AND 
            SUBSYSTEM_DESCRIPTION = 'QBATCH';
End of change