Work Management Services

These views and functions provide system value and job information.

ACTIVE_JOB_INFO table function
The ACTIVE_JOB_INFO table function returns one row for every active job.
ADD_TRACKED_JOB_QUEUE procedure
The ADD_TRACKED_JOB_QUEUE procedure registers a job queue to be tracked by adding it to the tracked job queue list.
AUTOSTART_JOB_INFO view
The AUTOSTART_JOB_INFO view returns information about autostart jobs.
CLEAR_TRACKED_JOB_INFO procedure
The CLEAR_TRACKED_JOB_INFO procedure removes entries from the job tracking file that exists on the specified ASP group.
COMMUNICATIONS_ENTRY_INFO view
The COMMUNICATIONS_ENTRY_INFO view returns information about subsystem communications entries.
END_JOBS procedure
The END_JOBS procedure ends a set of active jobs specified by a set of filters.
ENDED_JOB_INFO table function
The ENDED_JOB_INFO table function returns information about jobs that have ended. This information is gathered from CPF1164 messages recorded in the history log.
GET_JOB_INFO table function
The GET_JOB_INFO table function returns one row containing the information about a specific job.
JOB_DESCRIPTION_INFO view
The JOB_DESCRIPTION_INFO view returns information about job descriptions.
JOB_INFO table function
The JOB_INFO table function returns one row for each job meeting the selection criteria.
JOB_LOCK_INFO table function
The JOB_LOCK_INFO table function returns a list of objects that have been locked or have lower level locks acquired by the specified job. If the job is not active, no rows are returned.
JOB_QUEUE_ENTRIES view
The JOB_QUEUE_ENTRIES view returns one row for each entry in a job queue.
JOB_QUEUE_INFO view
The JOB_QUEUE_INFO view returns one row for each job queue.
MEMORY_POOL table function
The MEMORY_POOL table function returns one row for every pool.
MEMORY_POOL_INFO view
The MEMORY_POOL_INFO view returns one row for every active pool.
OBJECT_LOCK_INFO view
The OBJECT_LOCK_INFO view returns one row for every lock held for every object on the partition in *SYSBAS and in the current thread's ASP group.
OPEN_FILES table function
The OPEN_FILES table function returns a list of files (*FILE objects) that are open in all threads for a job.
POWER_SCHEDULE_INFO view
The POWER_SCHEDULE_INFO view returns one row for each date in the next year that has a power on or power off scheduled.
PRESTART_JOB_INFO view
The PRESTART_JOB_INFO view returns information about prestart jobs.
PRESTART_JOB_STATISTICS table function
The PRESTART_JOB_STATISTICS table function returns statistics and performance information for an active prestart job entry in an active subsystem. The information is collected from the time the reset key is pressed on the Display Active Prestart Jobs (DSPACTPJ) command, from the time the prestart job entry is started, or from the time RESET_STATISTICS => 'YES' is run for this table function. The prestart job entry is started when the subsystem starts or when the Start Prestart Jobs (STRPJ) command is used.
RECORD_LOCK_INFO view
The RECORD_LOCK_INFO view returns one row for every record lock for the partition.
REMOVE_TRACKED_JOB_QUEUE procedure
The REMOVE_TRACKED_JOB_QUEUE procedure removes a job queue from the tracked job queue list.
ROUTING_ENTRY_INFO view
The ROUTING_ENTRY_INFO view returns information about routing entries.
SCHEDULED_JOB_INFO view
The SCHEDULED_JOB_INFO view returns information that can also be seen through the Work with Job Schedule Entries (WRKJOBSCDE) command interface. Each job schedule entry contains the information to automatically submit a batch job once or at regularly scheduled intervals.
SUBSYSTEM_INFO view
The SUBSYSTEM_INFO view returns information about all subsystems.
SUBSYSTEM_POOL_INFO view
The SUBSYSTEM_POOL_INFO view returns information about storage pools defined for subsystems.
SYSTEM_ACTIVITY_INFO table function
The SYSTEM_ACTIVITY_INFO table function returns a single row containing statistical information about CPU usage.
SYSTEM_STATUS table function
The SYSTEM_STATUS table function returns a single row containing details about the current partition.
SYSTEM_STATUS_INFO view
The SYSTEM_STATUS_INFO view returns a single row containing details about the current partition. This view uses the QSYS2.SYSTEM_STATUS table function with DETAILED_INFO => 'ALL'.
SYSTEM_STATUS_INFO_BASIC view
The SYSTEM_STATUS_INFO_BASIC view returns a single row containing details about the current partition. This view uses the QSYS2.SYSTEM_STATUS table function with DETAILED_INFO => 'BASIC'.
SYSTEM_VALUE_INFO view
The SYSTEM_VALUE_INFO view contains information about system values.
TRACKED_JOB_INFO table function
The TRACKED_JOB_INFO table function returns information about the requested jobs. The information can be used to resubmit the job. Some information can be provided on the SBMJOB CL command. Other information can be provided on the CHGJOB CL command.
TRACKED_JOB_QUEUES view
The TRACKED_JOB_QUEUES view returns a list of job queues that have been registered to be tracked.
WORKLOAD_GROUP_INFO view
The WORKLOAD_GROUP_INFO view returns information about workload groups including their product entries.
WORKSTATION_INFO view
The WORKSTATION_INFO view returns information about workstation entries.

Parent topic: IBM i Services