Question & Answer

Question

How do you create a report of System Value changes?

Answer

The AUDIT_JOURNAL_SV table function returns rows from the audit journal that contain information from the SV (Action to System Value) journal entries.

Authorization: No authorization needed.

Note: The AUDIT_JOURNAL_SV table function is available on IBM i 7.5 base, IBM i 7.4 at SF99704 Level 15 and IBM i 7.3 at SF99703 Level 26.

Before you start, verify that the QAUDJRN journal exists and that you have *SECCFG or *SECURITY on your QAUDLVL system value.

Use the DSPSECAUD command and make sure the following settings are configured on your system:

  Security journal QAUDJRN exists . . . . . :  YES    
Current QAUDCTL system value  . . . . . . : *AUDLVL 
Current QAUDLVL system value  . . . . . . : *SECCFG

NOTE: The value *SECURITY also tracks the changes to System Values.

If not there, use the CHGSECAUD command to add them to your system. Keep in mind that the auditing values need to be active on your system before the report can be generated.

To get a report of System Value changes, follow the steps:

1) Open the ACS Run SQL Scripts tool

2) Run the following SQL:

select ENTRY_TIMESTAMP,
       JOB_NAME,
       JOB_USER,
       JOB_NUMBER,
       ENTRY_TYPE_DETAIL,
       SYSTEM_VALUE,
       NEW_VALUE,
       OLD_VALUE
    from table (
            SYSTOOLS.AUDIT_JOURNAL_SV(STARTING_TIMESTAMP => current date - 15 day)
        )
    where ENTRY_TYPE = 'A';

Note 1: Modify the number of days for the report.

Note 2: If Hexadecimal data is displayed on the report, you need to change the JDBC connection properties to translate the CCSID to 65535. On the Run SQL tool, select the Connection Menu > Connected > Edit JDBC Connection > Translation and click on Translate CCSID 65535. Save the connection and reconnect to run the SQL.

To use the History Log to track for changes to System Values refer to: What Message is Issued for Each System Value Changed

More information on the AUDIT_JOURNAL_SV table function: AUDIT_JOURNAL_SV table function

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m3p000000GoLuAAK","label":"Job and Work Management-\u003ESystems management"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.3.0;7.4.0;7.5.0"}]

Was this topic helpful?

Document Information

More support for:
IBM i

Component:
Job and Work Management->Systems management

Software version:
7.3.0, 7.4.0, 7.5.0

Operating system(s):
IBM i

Document number:
6594825

Modified date:
14 June 2022

UID

ibm16594825

IBM Support

Tips

How do you create a report of System Value changes.