AUDIT_JOURNAL_DATA_MART_INFO view
The AUDIT_JOURNAL_DATA_MART_INFO view contains information about the AUDIT_JOURNAL_xx data mart tables that are populated and updated using the MANAGE_AUDIT_JOURNAL_DATA_MART procedure.
Authorization: The caller must have *AUDIT special authority.
The following table describes the columns in the view. There is one row of information for each audit journal entry type that has been requested for each library. The system name is AJ_DMART. The schema is QSYS2.
Column Name | System Column Name | Data Type | Description |
---|---|---|---|
DATA_MART_LIBRARY | LIBRARY | VARCHAR(10) | The library containing the data mart table. |
DATA_MART_TABLE | TABLE | CHAR(16) | The name of the data mart table. |
DATA_MART_SYSTEM_TABLE_NAME | SYS_TABLE | CHAR(5) | The system name of the data mart table. |
JOURNAL_ENTRY_TYPE | ENTRY | CHAR(2) | The journal entry type contained within the data mart table. |
AUDIT_JOURNAL_STARTING_TIMESTAMP | AJ_START | TIMESTAMP | The STARTING_TIMESTAMP parameter value for the most recent call to the MANAGE_AUDIT_JOURNAL_DATA_MART procedure for this JOURNAL_ENTRY_TYPE and DATA_MART_LIBRARY. |
AUDIT_JOURNAL_ENDING_TIMESTAMP | AJ_END | TIMESTAMP | The ENDING_TIMESTAMP parameter value for the most recent call to the MANAGE_AUDIT_JOURNAL_DATA_MART procedure for this JOURNAL_ENTRY_TYPE and DATA_MART_LIBRARY. |
BUILD_START | B_START | TIMESTAMP | The timestamp of the most recent call to the MANAGE_AUDIT_JOURNAL_DATA_MART procedure for this JOURNAL_ENTRY_TYPE and DATA_MART_LIBRARY. |
BUILD_END | B_END | TIMESTAMP Nullable
|
The timestamp of when the most recent call to the
MANAGE_AUDIT_JOURNAL_DATA_MART procedure finished for this JOURNAL_ENTRY_TYPE and
DATA_MART_LIBRARY. Contains the null value if the MANAGE_AUDIT_JOURNAL_DATA_MART procedure is running or if a failure occurred during the call. |
BUILD_JOB | BUILD_JOB |
VARCHAR(28)
|
The qualified job name that most recently called the MANAGE_AUDIT_JOURNAL_DATA_MART procedure for this JOURNAL_ENTRY_TYPE and DATA_MART_LIBRARY. |
FAILURE_DETAIL | FAILURE | VARCHAR(300) Nullable
|
The failure information for the most recent call to
the MANAGE_AUDIT_JOURNAL_DATA_MART procedure for this JOURNAL_ENTRY_TYPE and DATA_MART_LIBRARY.
Contains the null value if no failure occurred. |
Examples
- Check for failures after calling the MANAGE_AUDIT_JOURNAL_DATA_MART procedure for the PW journal
entry in the library DMARTLIB.
SELECT DATA_MART_LIBRARY, DATA_MART_TABLE, JOURNAL_ENTRY_TYPE, BUILD_END, FAILURE_DETAIL FROM QSYS2.AUDIT_JOURNAL_DATA_MART_INFO WHERE JOURNAL_ENTRY_TYPE = 'PW' AND DATA_MART_LIBRARY = 'DMARTLIB' AND FAILURE_DETAIL IS NOT NULL;