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.

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_EV 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 EV audit journal entry.
ENTRY_TYPE	CHAR(1)	The type of entry. A Add C Change D Delete I Initialize environment variable space
ENTRY_TYPE_DETAIL	VARCHAR(200)	Descriptive text that corresponds to the entry type.
ENVIRONMENT_VARIABLE_NAME	VARGRAPHIC(1000) CCSID 1200	The name of the environment variable. Contains the null value when ENTRY_TYPE is I.
NAME_TRUNCATED	VARCHAR(3)	Indicates whether ENVIRONMENT_VARIABLE_NAME is truncated. NO Environment variable name is not truncated. YES Environment variable name is truncated. Contains the null value when ENVIRONMENT_VARIABLE_NAME is null.
ENVIRONMENT_VARIABLE_VALUE	VARGRAPHIC(1000) CCSID 1200	The value of the environment variable. Contains the null value when no environment variable value is available.
VALUE_TRUNCATED	VARCHAR(3)	Indicates whether ENVIRONMENT_VARIABLE_VALUE is truncated. NO Environment variable value is not truncated. YES Environment variable value is truncated. Contains the null value when ENVIRONMENT_VARIABLE_VALUE is null.

Example

List any environment variables that have been changed in the last month.

SELECT *
  FROM TABLE (
      SYSTOOLS.AUDIT_JOURNAL_EV (STARTING_TIMESTAMP => CURRENT DATE - 1 MONTH))
    )
  WHERE ENTRY_TYPE = 'C';