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.
- *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.
|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.|
|The name of the library in which the routing entry program
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:
|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.|
|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
|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.
|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
|The degree to which the system tries to maintain the affinity
between threads and system resources.
Contains the null value when THREAD_RESOURCES_AFFINITY_GROUP is SYSVAL.
- List all the routing entries defined for the QBATCH
SELECT * FROM QSYS2.ROUTING_ENTRY_INFO WHERE SUBSYSTEM_DESCRIPTION_LIBRARY = 'QSYS' AND SUBSYSTEM_DESCRIPTION = 'QBATCH';