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:

*EXECUTE authority to the library containing the subsystem description, and
*USE authority to 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';