Audit journal entry services

These table functions provide detailed information for audit journal entries.

AUDIT JOURNAL table function common information
Each of the AUDIT_JOURNAL_xx table functions returns information from the audit journal specific to an individual entry type. The invocation of every function and the first set of columns returned by the function are identical. This common information is described in this section.
AUDIT_JOURNAL_AD table function
The AUDIT_JOURNAL_AD table function returns rows from the audit journal that contain information from the AD (Auditing Change) journal entries.
AUDIT_JOURNAL_AF table function
The AUDIT_JOURNAL_AF table function returns rows from the audit journal that contain information from the AF (Authority Failure) journal entries.
AUDIT_JOURNAL_AP table function
The AUDIT_JOURNAL_AP table function returns rows from the audit journal that contain information from the AP (Adopted Authority) journal entries.
AUDIT_JOURNAL_AU table function
The AUDIT_JOURNAL_AU table function returns rows from the audit journal that contain information from the AU (Attribute Changes) journal entries.
AUDIT_JOURNAL_AX table function
The AUDIT_JOURNAL_AX table function returns rows from the audit journal that contain information from the AX (Row and Column Access Control) journal entries.
AUDIT_JOURNAL_CA table function
The AUDIT_JOURNAL_CA table function returns rows from the audit journal that contain information from the CA (Authority Changes) journal entries.
AUDIT_JOURNAL_CD table function
The AUDIT_JOURNAL_CD table function returns rows from the audit journal that contain information from the CD (Command String) journal entries.
AUDIT_JOURNAL_CO table function
The AUDIT_JOURNAL_CO table function returns rows from the audit journal that contain information from the CO (Create Object) journal entries.
AUDIT_JOURNAL_CP table function
The AUDIT_JOURNAL_CP table function returns rows from the audit journal that contain information from the CP (User Profile Changes) journal entries.
AUDIT_JOURNAL_DO table function
The AUDIT_JOURNAL_DO table function returns rows from the audit journal that contain information from the DO (Delete Operation) journal entries.
AUDIT_JOURNAL_DS table function
The AUDIT_JOURNAL_DS table function returns rows from the audit journal that contain information from the DS (Service Tools User ID and Attribute Changes) journal entries.
AUDIT_JOURNAL_EV table function
The AUDIT_JOURNAL_EV table function returns rows from the audit journal that contain information from the EV (Environment Variable) journal entries.
AUDIT_JOURNAL_GR table function
The AUDIT_JOURNAL_GR table function returns rows from the audit journal that contain information from the GR (Generic Record) journal entries.
AUDIT_JOURNAL_IM table function
The AUDIT_JOURNAL_IM table function returns rows from the audit journal that contain information from the IM (Intrusion Monitor) journal entries.
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.
AUDIT_JOURNAL_LD table function
The AUDIT_JOURNAL_LD table function returns rows from the audit journal that contain information from the LD (Link, Unlink, Search Directory) journal entries.
AUDIT_JOURNAL_M0 table function
The AUDIT_JOURNAL_M0 table function returns rows from the audit journal that contain information from the M0 (Db2® Mirror Setup Tools) journal entries.
AUDIT_JOURNAL_M6 table function
The AUDIT_JOURNAL_M6 table function returns rows from the audit journal that contain information from the M6 (Db2 Mirror Communication Services) journal entries.
AUDIT_JOURNAL_M7 table function
The AUDIT_JOURNAL_M7 table function returns rows from the audit journal that contain information from the M7 (Db2 Mirror Replication Services) journal entries.
AUDIT_JOURNAL_M8 table function
The AUDIT_JOURNAL_M8 table function returns rows from the audit journal that contain information from the M8 (Db2 Mirror Product Services) journal entries.
AUDIT_JOURNAL_M9 table function
The AUDIT_JOURNAL_M9 table function returns rows from the audit journal that contain information from the M9 (Db2 Mirror Replication State) journal entries.
AUDIT_JOURNAL_NA table function
The AUDIT_JOURNAL_NA table function returns rows from the audit journal that contain information from the NA (Attribute Change) journal entries.
AUDIT_JOURNAL_OM table function
The AUDIT_JOURNAL_OM table function returns rows from the audit journal that contain information from the OM (Object Management Change) journal entries.
AUDIT_JOURNAL_OR table function
The AUDIT_JOURNAL_OR table function returns rows from the audit journal that contain information from the OR (Object Restore) journal entries.
AUDIT_JOURNAL_OW table function
The AUDIT_JOURNAL_OW table function returns rows from the audit journal that contain information from the OW (Ownership Change) journal entries.
AUDIT_JOURNAL_PA table function
The AUDIT_JOURNAL_PA table function returns rows from the audit journal that contain information from the PA (Program Adopt) journal entries.
AUDIT_JOURNAL_PF table function
The AUDIT_JOURNAL_PF table function returns rows from the audit journal that contain information from the PF (PTF Operations) journal entries.
AUDIT_JOURNAL_PG table function
The AUDIT_JOURNAL_PG table function returns rows from the audit journal that contain information from the PG (Primary Group Change) journal entries.
AUDIT_JOURNAL_PS table function
The AUDIT_JOURNAL_PS table function returns rows from the audit journal that contain information from the PS (Profile Swap) journal entries.
AUDIT_JOURNAL_PU table function
The AUDIT_JOURNAL_PU table function returns rows from the audit journal that contain information from the PU (PTF Object Change) journal entries.
AUDIT_JOURNAL_PW table function
The AUDIT_JOURNAL_PW table function returns rows from the audit journal that contain information from the PW (Password) journal entries.
AUDIT_JOURNAL_RA table function
The AUDIT_JOURNAL_RA table function returns rows from the audit journal that contain information from the RA (Authority Change for Restored Object) journal entries.
AUDIT_JOURNAL_RO table function
The AUDIT_JOURNAL_RO table function returns rows from the audit journal that contain information from the RO (Ownership Change for Restored Object) journal entries.
AUDIT_JOURNAL_RZ table function
The AUDIT_JOURNAL_RZ table function returns rows from the audit journal that contain information from the RZ (Primary Group Change for Restored Object) journal entries.
AUDIT_JOURNAL_SK table function
The AUDIT_JOURNAL_SK table function returns rows from the audit journal that contain information from the SK (Sockets Connections) journal entries.
AUDIT_JOURNAL_SM table function
The AUDIT_JOURNAL_SM table function returns rows from the audit journal that contain information from the SM (Systems Management Change) journal entries.
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.
AUDIT_JOURNAL_SV table function
The AUDIT_JOURNAL_SV table function returns rows from the audit journal that contain information from the SV (Action to System Value) journal entries.
AUDIT_JOURNAL_ZC table function
The AUDIT_JOURNAL_ZC table function returns rows from the audit journal that contain information from the ZC (Change to Object) journal entries.
AUDIT_JOURNAL_ZR table function
The AUDIT_JOURNAL_ZR table function returns rows from the audit journal that contain information from the ZR (Read of Object) journal entries.

Parent topic: Journal Services