AUDIT_JOURNAL_JS (Job Change) 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. 1 indicates the system ASP.

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');