[[{“value”:”This is something that caught my attention when the latest Technology Refreshes were announced: the ability to create a database of journal entry types entries. I had been doing something similar using the CREATE TABLE SQL statement and various of the Audit journal entry services, AUDIT_JOURNAL_xx. But these additions added functionality that makes it easier for me to extract the journal entries from the System Audit Journal, QAUDJRN.
The two new additions are:
MANAGE_AUDIT_JOURNAL_DATA_MART: SQL procedure that uses the various AUDIT_JOURNAL_xx to create an output table.
AUDIT_JOURNAL_DATA_MART_INFO: SQL View that displays information about all the files created with the MANAGE_AUDIT_JOURNAL_DATA_MART SQL procedure.
Read more »”}]] Read More
