AUDIT_JOURNAL_JS table function

The AUDIT_JOURNAL_JS table function returns rows from the audit journal that contain information from the JS (Job Change) journal entries.

Every audit journal table function shares a common authorization requirement and a common set of parameters. These are described in AUDIT JOURNAL table function common information.

The result of the function is a table containing rows with the format shown in the following table. All the columns are nullable.

Table 1. AUDIT_JOURNAL_JS table function
Column Name	Data Type	Description
The first columns returned by this table function are from the common audit journal entry header. See Common columns returned from the audit journal entry header for the column definitions. After the common columns are the following columns that describe the entry specific data for the JS audit journal entry.
ENTRY_TYPE	CHAR(1)	The type of entry. A ENDJOBABN command B Submit C Change E End H Hold I Disconnect J The current job is attempting to interrupt another job K The current job is about to be interrupted L The interruption of the current job has completed M Change profile or group profile N ENDJOB command P Attach prestart or batch immediate job Q Change query attributes R Release S Start T Change profile or group profile using a profile token U CHGUSRTRC V Virtual device changed by QWSACCDS API
ENTRY_TYPE_DETAIL	VARCHAR(200)	Descriptive text that corresponds to the entry type.
JOB_TYPE	VARCHAR(3)	The job type. This value is based on the values of the JOB_TYPE_BASIC and JOB_SUBTYPE columns. ASJ Autostart BCH Batch BCI Batch Immediate EVK Started by a procedure start request INT Interactive M36 Advanced 36 server job MRT Multiple requester terminal PDJ Print driver job PJ Prestart job RDR Spool reader SBS Subsystem monitor SYS System WTR Spool writer Contains the null value if no value is available.
JOB_TYPE_BASIC	CHAR(1)	The type of job. A Autostart B Batch I Interactive M Subsystem monitor R Reader S System W Writer X SCPF Contains the null value if no value is available.
JOB_SUBTYPE	CHAR(1)	The subtype of the job. D Batch immediate E Procedure start request J Prestart P Print device driver Q Query T MRT U Alternate spool user Contains the null value if there is no subtype for the job.
TARGET_QUALIFIED_JOB_NAME	VARCHAR(28)	The qualified job name of the job that is being operated on.
TARGET_JOB_NAME	VARCHAR(10)	The name of the job that is being operated on.
TARGET_JOB_USER	VARCHAR(10)	The user profile that of the job that is being operated on.
TARGET_JOB_NUMBER	VARCHAR(6)	The job number of the job that is being operated on.
DEVICE_NAME	VARCHAR(10)	The name of the device. Contains the null value if no value is available.
EFFECTIVE_USER_PROFILE	VARCHAR(10)	The name of the effective user profile for the thread. When this audit record is generated because one job performs an operation on another job this column contains data from the initial thread of the job that is being operated on. In all other cases, the column contains data from the thread that performed the operation. Contains the null value if no value is available.
EFFECTIVE_GROUP_PROFILE	VARCHAR(10)	The name of the effective group profile for the thread. When this audit record is generated because one job performs an operation on another job, this column contains data from the initial thread of the job that is being operated on. In all other cases, the column contains data from the thread that performed the operation. Contains the null value if no value is available.
SUPPLEMENTAL_GROUP_PROFILES	VARCHAR(150)	The names of the supplemental group profiles for the thread. When this audit record is generated because one job performs an operation on another job, this column contains data from the initial thread of the job that is being operated on. In all other cases, the column contains data from the thread that performed the operation. Contains the null value if no value is available.
REAL_USER_PROFILE	VARCHAR(10)	The name of the real (initial) user profile for the thread. Contains the null value if no value is available.
SAVED_USER_PROFILE	VARCHAR(10)	The name of the saved user profile for the thread. Contains the null value if no value is available.
REAL_GROUP_PROFILE	VARCHAR(10)	The name of the real (initial) group profile for the thread. Contains the null value if no value is available.
SAVED_GROUP_PROFILE	VARCHAR(10)	The name of the saved group profile for the thread. Contains the null value if no value is available.
REAL_USER_CHANGED	VARCHAR(3)	The real user profile was changed. NO The real user profile was not changed. YES The real user profile was changed. Contains the null value when ENTRY_TYPE is not M or T.
EFFECTIVE_USER_CHANGED	VARCHAR(3)	The effective user profile was changed. NO The effective user profile was not changed. YES The effective user profile was changed. Contains the null value when ENTRY_TYPE is not M or T.
SAVED_USER_CHANGED	VARCHAR(3)	The saved user profile was changed. NO The saved user profile was not changed. YES The saved user profile was changed. Contains the null value when ENTRY_TYPE is not M or T.
REAL_GROUP_CHANGED	VARCHAR(3)	The real group profile was changed. NO The real group profile was not changed. YES The real group profile was changed. Contains the null value when ENTRY_TYPE is not M or T.
EFFECTIVE_GROUP_CHANGED	VARCHAR(3)	The effective group profile was changed. NO The effective group profile was not changed. YES The effective group profile was changed. Contains the null value when ENTRY_TYPE is not M or T.
SAVED_GROUP_CHANGED	VARCHAR(3)	The saved group profile was changed. NO The saved group profile was not changed. YES The saved group profile was changed. Contains the null value when ENTRY_TYPE is not M or T.
SUPPLEMENTAL_GROUPS_CHANGED	VARCHAR(3)	The supplemental group profiles were changed. NO The supplemental group profiles were not changed. YES The supplemental group profiles were changed. Contains the null value when ENTRY_TYPE is not M or T.
JOB_DESCRIPTION_LIBRARY	VARCHAR(10)	The name of the library for the job description. Contains the null value if no value is available.
JOB_DESCRIPTION	VARCHAR(10)	The name of the job description for the job. Contains the null value if no value is available.
JOB_DESCRIPTION_ASP_NAME	VARCHAR(10)	ASP name for JOB_DESCRIPTION_LIBRARY. Contains the null value if no value is available.
JOB_DESCRIPTION_ASP_NUMBER	INTEGER	ASP number for JOB_DESCRIPTION_LIBRARY. Contains the null value if no value is available.
JOB_QUEUE_LIBRARY	VARCHAR(10)	The name of the library for the job queue. Contains the null value if no value is available.
JOB_QUEUE_NAME	VARCHAR(10)	The name of the job queue for the job. Contains the null value if no value is available.
JOB_QUEUE_ASP_NAME	VARCHAR(10)	ASP name for JOB_QUEUE_LIBRARY. Contains the null value if no value is available.
JOB_QUEUE_ASP_NUMBER	INTEGER	ASP number of JOB_QUEUE_LIBRARY. Contains the null value if no value is available.
OUTPUT_QUEUE_LIBRARY	VARCHAR(10)	The name of the library for the output queue. Contains the null value if no value is available.
OUTPUT_QUEUE_NAME	VARCHAR(10)	The name of the output queue for the job. Contains the null value if no value is available.
PRINTER_DEVICE	VARCHAR(10)	The name of the printer device for the job. Contains the null value if no value is available.
TIME_ZONE_DESCRIPTION_NAME	VARCHAR(10)	The timezone description name. Contains the null value if no value is available.
THREAD_ASP_NAME	VARCHAR(10)	The ASP group for the current thread. Contains the null value if no value is available.
LIBRARY_LIST_COUNT	INTEGER	The number of libraries in LIBRARY_LIST.
LIBRARY_LIST	VARCHAR(2680)	The library list for the job. The list is an array of entries, each ten characters long. When this audit record is generated because one job performs an operation on another job, this column contains data from the initial thread of the job that is being operated on. In all other cases, the column contains data from the thread that performed the operation. Contains the null value when LIBRARY_LIST_COUNT is 0.
JOB_USER_IDENTITY_DESCRIPTION	VARCHAR(5)	Describes the meaning of JOB_USER_IDENTITY. CLEAR The clear JUID API was called. JOB_USER_IDENTITY contains the new value. JOB JOB_USER_IDENTITY contains the value for the JOB. SET The set JUID API was called. JOB_USER_IDENTITY contains the new value.
JOB_USER_IDENTITY	VARCHAR(10)	The job user identity value. Contains the null value if no value is available.
WORKLOAD_GROUP	VARCHAR(10)	The name of the workload group associated with the job. Contains the null value when ENTRY_TYPE is not C, E, or S.
EXIT_QUALIFIED_JOB_NAME	VARCHAR(28)	When ENTRY_TYPE is J, the qualified job name of the job that was interrupted by the current job. When ENTRY_TYPE is K or L, the qualified job name of the job that requested the interruption of the current job. Contains the null value when ENTRY_TYPE is not J, K, or L.
EXIT_JOB_NAME	VARCHAR(10)	When ENTRY_TYPE is J, the name of the job that was interrupted by the current job. When ENTRY_TYPE is K or L, the name of the job that requested the interruption of the current job. Contains the null value when ENTRY_TYPE is not J, K, or L.
EXIT_JOB_USER	VARCHAR(10)	When ENTRY_TYPE is J, the user of the job that was interrupted by the current job. When ENTRY_TYPE is K or L, the user of the job that requested the interruption of the current job. Contains the null value when ENTRY_TYPE is not J, K, or L.
EXIT_JOB_NUMBER	VARCHAR(6)	When ENTRY_TYPE is J, the job number of the job that was interrupted by the current job. When ENTRY_TYPE is K or L, the number of the job that requested the interruption of the current job. Contains the null value when ENTRY_TYPE is not J, K, or L.
EXIT_PROGRAM_LIBRARY	VARCHAR(10)	The library name of the exit program used to interrupt the job. Contains the null value when ENTRY_TYPE is not J, K, or L.
EXIT_PROGRAM	VARCHAR(10)	The exit program used to interrupt the job. Contains the null value when ENTRY_TYPE is not J, K, or L.

Example

List jobs that were ended today with the ENDJOB or ENDJOBABN CL commands.

SELECT *
  FROM TABLE (
      SYSTOOLS.AUDIT_JOURNAL_JS (STARTING_TIMESTAMP => CURRENT DATE)
    )
  WHERE ENTRY_TYPE IN ('A','N');