Start of change

PRESTART_JOB_INFO view

The PRESTART_JOB_INFO view returns information about prestart jobs.

The values returned for the columns in the view are closely related to the values returned by the Display Prestart Job 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 PREJ_INFO. The schema is QSYS2.

Table 1. PRESTART_JOB_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.
PRESTART_JOB_PROGRAM_LIBRARY PJ_PGM_LIB VARCHAR(10) The name of the library in which the prestart job program resides.
PRESTART_JOB_PROGRAM PJ_PGM VARCHAR(10) The program name that is used to match an incoming request with an available prestart job.
SUBSYSTEM_ACTIVE SBS_ACTIVE VARCHAR(3) Whether the subsystem for this prestart job is active.
NO
The status of the subsystem is not ACTIVE.
YES
The status of the subsystem is ACTIVE.
USER_PROFILE USRPRF VARCHAR(10) The name of the user profile under which the prestart job runs.
PRESTART_JOB_NAME PJ_NAME VARCHAR(10) The name of the prestart job.
JOB_DESCRIPTION_LIBRARY JOBDLIB VARCHAR(10)
Nullable
The name of the library in which the job description for the prestart job entry resides.

Contains the null value if JOB_DESCRIPTION is *USRPRF.

JOB_DESCRIPTION JOBD VARCHAR(10) The name of the job description that is used for the prestart job entry. Can contain the following special value:
*USRPRF
The job description that has the same name as the user profile that is used.
START_JOBS START_JOBS VARCHAR(3) Whether the prestart jobs are started at the time the subsystem is started.
NO
The prestart jobs are not started at the time the subsystem is started. The Start Prestart Jobs (STRPJ) command is used to start these prestart jobs.
YES
The prestart jobs are started at the time the subsystem is started.
INITIAL_JOBS INIT_JOBS INTEGER The initial number of prestart jobs that are started when the subsystem is started.
THRESHOLD THRESHOLD INTEGER The number at which additional prestart jobs are started. When the pool of available jobs (jobs available to service a program start request) is reduced below this number, more jobs (specified by ADDITIONAL_JOBS) are started and added to the available pool. This number is checked after a prestart job is attached to a procedure start request.
ADDITIONAL_JOBS ADD_JOBS INTEGER The additional number of prestart jobs that are started when the number of prestart jobs drops below the value of THRESHOLD.
MAXIMUM_JOBS MAX_JOBS INTEGER The maximum number of prestart jobs that can be active at the same time for this prestart job entry. A value of -1 indicates *NOMAX.
MAXIMUM_USES MAX_USES INTEGER The maximum number of requests that can be handled by each prestart job in the pool before the job is ended. A value of -1 indicates *NOMAX.
WAIT_FOR_JOB WAIT VARCHAR(3) Whether requests wait for a prestart job to become available or are rejected if a prestart job is not immediately available when the request is received.
NO
Requests are rejected if a prestart job is not immediately available when the request is received.
YES
Requests wait until there is an available prestart job, or until a prestart job is started, to handle the request.
POOL_ID POOL_ID INTEGER The subsystem pool in which the prestart jobs will run.
CLASS_LIBRARY CLASS1_LIB VARCHAR(10) The name of the library in which the first class resides.
CLASS CLASS1 VARCHAR(10) The name of the first class that the prestart jobs run under. Jobs start by using the first class that is specified until the number of jobs specified for the first class is reached. After the number of jobs that are specified for the first class is reached, then jobs are started by using the second class.
CLASS_JOBS CLASS1_JOB INTEGER The maximum number of jobs to run using the first class. Can contain the following special values:
-3
The system calculates how many prestart jobs use this class.

If only one class is specified and -3 is specified, all of the jobs use that class.

If two classes are specified and -3 is specified for both, the first class is the value of MAXIMUM_JOBS divided by two, and the second class is the value of MAXIMUM_JOBS minus the value that is calculated for the first class.

If a specific number of jobs is specified for either class and -3 is specified for the other class, the system calculates the difference between MAXIMUM_JOBS and the specific number of jobs for the -3 designation.

-4
All of the prestart jobs use the specified class.
CLASS2_LIBRARY CLASS2_LIB VARCHAR(10)
Nullable
The name of the library in which the second class resides.

Contains the null value if only one class is used.

CLASS2 CLASS2 VARCHAR(10)
Nullable
The second class that the prestart jobs run under.

Contains the null value if only one class is used.

CLASS2_JOBS CLASS2_JOB INTEGER
Nullable
The maximum number of jobs to run using the second class. Can contain the following special values:
-3
The system calculates how many prestart jobs use this class.
-4
All of the prestart jobs use the specified class.

Contains the null value if only one class is used.

RESOURCES_AFFINITY_GROUP RAG VARCHAR(3) Specifies whether the prestart jobs started by this entry are grouped together having affinity to the same set of processors and memory.
NO
Prestart jobs will not be grouped together. They will be spread across all the available system resources.
YES
Prestart 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 the prestart jobs are grouped together with the initial thread, or spread across the system resources.
GROUP
Secondary threads running in the prestart job will all have affinity to the same set of processors and memory as the initial thread.
NOGROUP
Secondary threads running in the prestart job 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 prestart job entries in the QUSRWRK subsystem.
    SELECT *
      FROM QSYS2.PRESTART_JOB_INFO 
      WHERE SUBSYSTEM_DESCRIPTION_LIBRARY = 'QSYS' AND 
            SUBSYSTEM_DESCRIPTION = 'QUSRWRK';
End of change