AUDIT_JOURNAL_ST table function

The AUDIT_JOURNAL_ST table function returns rows from the audit journal that contain information from the ST (Service Tools Action) 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_ST 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 ST audit journal entry.
ENTRY_TYPE	CHAR(1)	The type of entry. A Service record
ENTRY_TYPE_DETAIL	VARCHAR(200)	Descriptive text that corresponds to the entry type.
SERVICE_TOOL	CHAR(2)	The service tool identifier. AR ARM diagnostic trace (see ARMSRV QShell command) AS Storage altered by Display/Alter/Dump service tool or by a remote service tool debugger CD QTACTLDV, QTADMPDV CE QWTCTLTR CS STRCPYSCN CT DMPCLUTRC DC DLTCMNTRC DD DMPDLO DF QWTDMPFR, QWTDMPLF DI QSCDIRD DM DMPMEMINF DO DMPOBJ DS DMPSYSOBJ, QTADMPTS, QTADMPDV, QWTDMPLF DU DMPUSRPRF DW STRDW, ENDDW, ADDDWDFN, RMVDWDFN EC ENDCMNTRC ER ENDRMTSPT FF FFDC (First Failure Data Capture) GS QSMGSSTD HD QYHCHCOP (DASD) HL QYHCHCOP (LPAR) JW STRJW, ENDJW, ADDJWDFN, RMVJWDFN MC QWTMAINT (change) MD QWTMAINT (dump) MP End system job MQ Restart system job OP Operations console PC PRTCMNTRC PE PRTERRLOG, QTADMPDV
SERVICE_TOOL (continued)		PI PRTINTDTA, QTADMPDV PS QP0FPTOS SC STRCMNTRC, QSCCHGCT SE QWTSETTR SF QWCCDSIC, QWVRCSTK (Display internal stack entry) SJ STRSRVJOB SN QPZSYNC SR STRRMTSPT SS QFPHPSF ST STRSST SV QSRSRV TA TRCTCPAPP TC TRCCNN (FORMAT specified) TE ENDTRC, ENDPEX, TRCJOB(OFF or END specified) TI TRCINT, or TRCCNN with SET(ON), SET(OFF), or SET(END) TO QTOBSRV TQ QWCTMQTM TS STRTRC, STRPEX, TRCJOB(*ON specified) UD QTAUPDDV WE ENDWCH, QSCEWCH WS STRWCH, QSCSWCH WT WRKTRC WW WRKWCH, QSCRWCHI, QSCRWCHL
SERVICE_TOOL_DETAIL	VARCHAR(200)	Descriptive text that corresponds to the service tool.
OBJECT_LIBRARY	VARCHAR(10)	Name of the library for OBJECT_NAME. Contains the null value if there is no library name.
OBJECT_NAME	VARCHAR(10)	Name of the object accessed. Contains the null value if there is no object name.
OBJECT_TYPE	VARCHAR(7)	Type of object. Contains the null value if there is no object type.
OBJECT_ASP_NAME	VARCHAR(10)	ASP name for object library. Contains the null value if there is no object ASP name.
OBJECT_ASP_NUMBER	INTEGER	ASP number for object library. Contains the null value if there is no object ASP number.
DLO_NAME	VARCHAR(12)	Name of the document library object. Contains the null value if there is no document library object.
FOLDER_PATH	VARCHAR(63)	The folder containing the document library object Contains the null value if there is no folder.
SOURCE_NODE_ID	VARCHAR(8)	Source node ID. Contains the null value if there is no source node ID.
SOURCE_USER	VARCHAR(10)	Source user. Contains the null value if there is no source user.
TARGET_QUALIFIED_JOB_NAME	VARCHAR(28)	The qualified job name of the target job. Contains the null value if there is no target job.
TARGET_JOB_NAME	VARCHAR(10)	The job name of the target job. Contains the null value if there is no target job.
TARGET_JOB_USER	VARCHAR(10)	The job user of the target job. Contains the null value if there is no target job.
TARGET_JOB_NUMBER	VARCHAR(6)	The job number of the target job. Contains the null value if there is no target job.
TARGET_JOB_USER_IDENTITY	VARCHAR(10)	The job user identity value of the target job. Contains the null value if there is no target job.
DMPSYSOBJ_LIBRARY	VARCHAR(30)	Name of the library for the object for DMPSYSOBJ. Contains the null value when SERVICE_TOOL is not DS.
DMPSYSOBJ_OBJECT	VARCHAR(30)	Name of the object for DMPSYSOBJ. Contains the null value when SERVICE_TOOL is not DS.
DMPSYSOBJ_TYPE	VARCHAR(7)	Type of the object for DMPSYSOBJ. Contains the null value when SERVICE_TOOL is not DS.
DMPSYSOBJ_ASP_NAME	VARCHAR(10)	ASP name for DMPSYSOBJ object library. Contains the null value when SERVICE_TOOL is not DS.
DMPSYSOBJ_ASP_NUMBER	INTEGER	ASP number for DMPSYSOBJ object library. Contains the null value when SERVICE_TOOL is not DS.
AA_COMMAND_NAME	VARCHAR(30)	Advanced Analysis Command name. See QMGTOOLS: Run AA Macros Contains the null value when SERVICE_TOOL is not GS.
EARLY_TRACE_ACTION	VARCHAR(6)	The action requested for early job tracing OFF Early tracing turned off ON Early tracing turned on *RESET Early tracing turned off and trace information deleted. Contains the null value when SERVICE_TOOL is not CE.
ARM_TRACE	VARCHAR(10)	ARM diagnostic trace. ACTIVATE Activate DEACTIVATE Deactivate Contains the null value when SERVICE_TOOL is not AR.
TRCTCPAPP_OPTION	VARCHAR(7)	The trace option specified on TRCTCPAPP. ENDED Collection of trace information ended and all trace information purged (no output created) STARTED Collection of trace information started STOPPED Collection of trace information stopped and trace information written to spooled file Contains the null value when SERVICE_TOOL is not TA.
APPLICATION_TRACED	VARCHAR(10)	The name of the application being traced. Contains the null value when SERVICE_TOOL is not AR or TA.
SERVICE_TOOLS_PROFILE	VARCHAR(10)	The name of the service tools profile used for Start System Service Tools (STRSST). Contains the null value when SERVICE_TOOL is not ST or OP.
CONSOLE_TYPE	VARCHAR(7)	The console type. DIRECT HMC *LAN Contains the null value when SERVICE_TOOL is not OP.
CONSOLE_ACTION	VARCHAR(9)	The console action. RECOVERY TAKEOVER Contains the null value when SERVICE_TOOL is not OP.
ADDRESS_FAMILY	VARCHAR(5)	The address family. IPV4 IPV6 Contains the null value when SERVICE_TOOL is not OP or CONSOLE_TYPE is not *LAN.
CURRENT_IP_ADDRESS	VARCHAR(45)	The IP address of the current console device for LAN. Contains the null value when SERVICE_TOOL is not OP or CONSOLE_TYPE is not LAN.
CURRENT_DEVICE_ID	VARCHAR(10)	The service tools device ID of the current console device for LAN. Contains the null value when SERVICE_TOOL is not OP or CONSOLE_TYPE is not LAN.
PREVIOUS_IP_ADDRESS	VARCHAR(45)	The IP address of the previous console device for LAN. Contains the null value when SERVICE_TOOL is not OP or CONSOLE_TYPE is not LAN or there is no previous console device.
PREVIOUS_DEVICE_ID	VARCHAR(10)	The service tools device ID of the previous console device for LAN. Contains the null value when SERVICE_TOOL is not OP or CONSOLE_TYPE is not LAN or there is no previous console device.
WATCH_SESSION	VARCHAR(10)	Watch session ID. Contains the null value when SERVICE_TOOL is not WE or WS.
SERVICE_TOOL_USERID	VARCHAR(10)	Service tools user ID if storage was altered from DST or *DEBUG if storage was altered by a remote service tool debugger. Contains the null value when SERVICE_TOOL is not AS.
USER_PROFILE	VARCHAR(10)	User profile name if storage was altered from SST. Contains the null value when SERVICE_TOOL is not AS.
LIC_RU_NAME	VARCHAR(8)	The Licensed Internal Code Replaceable Unit name. Contains the null value when SERVICE_TOOL is not AS.
ADDRESS_OF_ALTERED_STORAGE	BINARY(8)	Address of storage that was altered. Contains the null value when SERVICE_TOOL is not AS.
SEGMENT_TYPE	BINARY(2)	Type of segment that was altered. Contains the null value when SERVICE_TOOL is not AS.
NUMBER_OF_ALTERED_BYTES	INTEGER	The number of bytes of storage in ALTERED_STORAGE_VALUE that were changed. Contains the null value when SERVICE_TOOL is not AS.
ALTERED_STORAGE_VALUE	BINARY(16)	Altered storage value. Contains the null value when SERVICE_TOOL is not AS.
PREVIOUS_STORAGE_VALUE	BINARY(16)	Original storage value. Contains the null value when SERVICE_TOOL is not AS.

Example

Check whether anyone has changed storage using STRSST today.

SELECT *
  FROM TABLE (
      SYSTOOLS.AUDIT_JOURNAL_ST (STARTING_TIMESTAMP => CURRENT DATE)
    )
  WHERE SERVICE_TOOL = 'ST' AND NUMBER_OF_ALTERED_BYTES > 0;