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.
JOB_DESCRIPTION_INFO view
The JOB_DESCRIPTION_INFO view returns information about job descriptions.
GET_JOB_INFO table function
The GET_JOB_INFO table function returns one row containing the information about a specific job.
JOB_INFO table function
The JOB_INFO table function returns one row for each job meeting the selection criteria. It returns information similar to what is returned by the Work with User Jobs (WRKUSRJOB), Work with Subsystem Jobs (WRKSBSJOB), and Work with Submitted Jobs (WRKSBMJOB) CL commands and the List Job (QUSLJOB) API.
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.
RECORD_LOCK_INFO view
The RECORD_LOCK_INFO view returns one row for every record lock for the partition.
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.
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.
SYSTEM_VALUE_INFO view
The SYSTEM_VALUE_INFO view contains information about system values.

Parent topic: IBM i Services