AUDIT_JOURNAL_AU (Attribute Changes) table function

The AUDIT_JOURNAL_AU table function returns rows from the audit journal that contain information from the AU (Attribute Changes) 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_AU 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 AU audit journal entry.
ENTRY_TYPE CHAR(1) The type of entry.
A
EIM association
E
EIM configuration attributes
ENTRY_TYPE_DETAIL VARCHAR(200) Descriptive text that corresponds to the entry type.
ACTION VARCHAR(6) The action that was performed.

When ENTRY_TYPE is A:

ADD
Add association
REMOVE
Remove association
When ENTRY_TYPE is E:
CHANGE
Attributes changed
ACTION_DETAIL VARCHAR(200) Descriptive text that corresponds to the action.
ATTRIBUTE_NAME VARCHAR(100) The name of the changed attribute.

Contains the null value if ENTRY_TYPE is A.
ATTRIBUTE_VALUE VARGRAPHIC(2000) CCSID 1200 The value of the attribute.

Contains the null value if ENTRY_TYPE is A.
PREV_ATTRIBUTE_VALUE VARGRAPHIC(2000) CCSID 1200 The previous value of the attribute.

Contains the null value if ENTRY_TYPE is A.
ASSOCIATION_TYPE VARCHAR(17) The association type that was added or removed:
  • ADMINISTRATIVE
  • ALL
  • TARGET
  • SOURCE AND TARGET
  • SOURCE

Contains the null value if ENTRY_TYPE is E.
REGISTRY_USER_NAME VARCHAR(100) The registry user name.

Contains the null value if ENTRY_TYPE is E.
IDENTIFIER_DISTINGUISHED_NAME VARGRAPHIC(1000) CCSID 1200 The identifier distinguished name.

Contains the null value if ENTRY_TYPE is E.
REGISTRY_DISTINGUISHED_NAME VARGRAPHIC(1000) CCSID 1200 The registry distinguished name.

Contains the null value if ENTRY_TYPE is E.

Example

  • List the EIM configuration attributes that were changed in the last two months.
    
SELECT * FROM TABLE(
  SYSTOOLS.AUDIT_JOURNAL_AU(  
      STARTING_TIMESTAMP => CURRENT TIMESTAMP - 2 MONTHS
  )
)
WHERE ENTRY_TYPE = 'E' AND ACTION = 'CHANGE';