AUDIT_JOURNAL_M0 (Db2 Mirror Setup Tools) table function

The AUDIT_JOURNAL_M0 table function returns rows from the audit journal that contain information from the M0 (Db2® Mirror Setup Tools) 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_M0 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 M0 audit journal entry.
ENTRY_TYPE	CHAR(1)	The type of entry. A Db2 Mirror setup tools
ENTRY_TYPE_DETAIL	VARCHAR(200)	Descriptive text that corresponds to the entry type.
ACTION	VARCHAR(15)	The action performed. CHECKSYSBASE Verify the cloning of SYSBASE and the configuration of the setup copy node has completed successfully. CONFIGFILE Manipulate the JSON configuration files. FLASHCOPY Perform the flash copy process on the storage. IASPCOPY Perform the entire automated DB IASP clone process. POSTIASP Perform the post-IASP copy steps. POWEROFF Power off the setup source or copy node using the HMC poweroff operation. PRECHECK Perform validation and checking to ensure the whole cloning process will complete successfully. PREIASP Perform the pre-IASP copy steps. REMOTECOPY Perform the remote copy process on the storage. START Begin the entire SYSBASE cloning process. STARTWARMCLONE Start Db2 Mirror tracking and flush main memory on the setup source node.
ACTION_TYPE	VARCHAR(10)	The type of action being performed. When ACTION is START or IASPCOPY: COLD WARM When ACTION is CONFIGFILE: NEW RESTORE SAVE UPDATE When ACTION is POWEROFF: CONTROL HMC IMMED Contains the null value if there is no action type.
ACTION_DETAIL	VARCHAR(200)	Descriptive text that corresponds to the action. Contains the null value if ACTION_TYPE is null.
ACTION_STATUS	VARCHAR(12)	Status of the action. This column can return a value when ACTION has a value of START, CHECKSYSBASE, POWEROFF, PRECHECK, FLASHCOPY, REMOTECOPY, and IASPCOPY. For these ACTION values, two audit entries will be sent: one when the action starts and another when the action ends. When the audit entry is for the start of the action, this column contains STARTED. When the audit entry is for the end of the action, this column contains the status of the action. COMPLETED The action was successful STARTED The action has started UNSUCCESSFUL The action was not successful Contains the null value if there is no status.
IASP_NAME	VARCHAR(10)	The name of the auxiliary storage pool (ASP). A value of *SYSBAS indicates the system ASP and all basic user ASPs. Contains the null value if ACTION is not IASPCOPY, PREIASP, or POSTIASP.
SETUP_SOURCE_NODE	VARCHAR(8)	The partition name of the Db2 Mirror setup source node.
SETUP_COPY_NODE	VARCHAR(8)	The partition name of the Db2 Mirror setup copy node.
SETUP_SOURCE_STORAGE	VARCHAR(256)	The IP address or host and domain name of the setup source storage system. Contains the null value if ACTION is not START, PRECHECK, FLASHCOPY, REMOTECOPY, or IASPCOPY.
SETUP_COPY_STORAGE	VARCHAR(256)	The IP address or host and domain name of the setup copy storage system. Contains the null value if ACTION is not START, PRECHECK, FLASHCOPY, REMOTECOPY, or IASPCOPY.

Example

List any Db2 Mirror set up actions that were unsuccessful from the last week.


SELECT ENTRY_TIMESTAMP, IASP_NAME, ACTION, ACTION_TYPE, ACTION_DETAIL 
FROM TABLE(
  SYSTOOLS.AUDIT_JOURNAL_M0(  
      STARTING_TIMESTAMP => CURRENT TIMESTAMP - 7 DAYS
  )
)
WHERE ACTION_STATUS = 'UNSUCCESSFUL';