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.

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_SV 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 SV audit journal entry.
ENTRY_TYPE	CHAR(1)	The type of entry. A Change to system values B Change to service attributes C Change to system clock D Adjustment to Coordinated Universal Time (UTC) E Change to option F Change to system-wide journal attribute
ENTRY_TYPE_DETAIL	VARCHAR(200)	Descriptive text that corresponds to the entry type.
SYSTEM_VALUE	VARCHAR(10)	The name of the system value or service attribute that was changed. Can contain one of the following special values. CACHEWAIT Changed journal maximum cache wait time JRNRCYCNT Changed journal recovery count value QINPIDCO Change the current install disk configuration option with QINPIDCO API.
OLD_VALUE	VARCHAR(1500)	The value of the system value or service attribute before it was changed.
NEW_VALUE	VARCHAR(1500)	The new value of the system value or service attribute.

Example

List any system value changes that have been made in the current calendar year.

SELECT *
  FROM TABLE (
      SYSTOOLS.AUDIT_JOURNAL_SV (STARTING_TIMESTAMP => TRUNC_TIMESTAMP(CURRENT DATE, 'YEAR'))
    )
  WHERE ENTRY_TYPE = 'A';