AUDIT_JOURNAL_M8 table function

The AUDIT_JOURNAL_M8 table function returns rows from the audit journal that contain information from the M8 (Db2® Mirror Product Services) 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_M8 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 M8 audit journal entry.
ENTRY_TYPE	CHAR(1)	The type of entry. A Add IASP C Change mirror F Change flight recorder H Change health monitor I Set default inclusion state J Change mirror ObjectConnect L Reclone replicated objects O Takeover R Remove IASP S Setup mirror T Terminate mirror W Swap mirror roles
ENTRY_TYPE_DETAIL	VARCHAR(200)	Descriptive text that corresponds to the entry type.
ACTION	VARCHAR(15)	Action to perform. When ENTRY_TYPE is A: NEW The IASP is being defined for the first time. RECLONE The IASP is used as the source of a reclone operation. SHADOW The IASP is being pre-defined as an IASP on a PowerHA® disaster recovery system. When ENTRY_TYPE is C: RESUME Resume replication. RESUMEABN Resume abnormal replication. SUSPEND Suspend replication. MAINTENANCE Suspend for maintenance. When ENTRY_TYPE is F: ENDJOB End flight recorder QMRDBLOGR job. RESUME Resume flight recorder logging. STARTJOB Start flight recorder QMRDBLOGR job. SUSPEND Suspend flight recorder logging. When ENTRY_TYPE is J: CHANGE SERVER Change ObjectConnect for Db2 Mirror server. END SERVER End ObjectConnect for Db2 Mirror server. START SERVER Start ObjectConnect for Db2 Mirror server. When ENTRY_TYPE is L: RESUMEABN Reclone replicated objects with abnormal resume. When ENTRY_TYPE is O: ADD Add mirror takeover address. CHANGE Change mirror takeover group. CREATE Create mirror takeover group. DELETE Delete mirror takeover group. REMOVE Remove mirror takeover address. SWAP Swap mirror takeover group. When ENTRY_TYPE is T: DESTROY Db2 Mirror is ended. RECLONE Active replication is ended. Contains the null value if: ENTRY_TYPE is not A, C, F, J, L, O, or T ENTRY_TYPE is C and the replication state was not specified ENTRY_TYPE is F and no action was specified ENTRY_TYPE is L and resume type was not specified
ACTION_DETAIL	VARCHAR(200)	Descriptive text that corresponds to the action. Contains the null value if ACTION is null.
IASP_NAME	VARCHAR(10)	ASP name. Can contain the special value *SYSBAS. Contains the null value if no ASP name applies to this entry.
IASP_TYPE	VARCHAR(8)	The type of IASP. DATABASE This IASP is for a database IASP group. IFS This IASP is for an IFS ASP group. Contains the null value if ENTRY_TYPE is not A or R.
DEFAULT_INCLUSION_STATE	VARCHAR(7)	When the ENTRY_TYPE is A, the default object inclusion state for objects in IASP_NAME. When ENTRY_TYPE is I, the default inclusion state for objects in *SYSBAS. EXCLUDE Eligible objects not covered by an RCL rule will not be replicated. INCLUDE Eligible objects not covered by an RCL rule will be replicated. RESET Clear the default inclusion state. This value applies when ENTRY_TYPE is I. Contains the null value if ENTRY_TYPE is not A or I.
CLUSTER_RESOURCE_GROUP	VARCHAR(10)	The cluster resource group name. Contains the null value if ENTRY_TYPE is not A.
AUTO_RESUME	VARCHAR(3)	When ENTRY_TYPE is C, whether to automatically resume mirroring. NO Do not automatically resume mirroring. YES Automatically resume mirroring after being suspended. Contains the null value if ENTRY_TYPE is not C or if the value was not changed.
SWAP_ON_PWRDWNSYS	VARCHAR(3)	Swap behavior on power down system. NO Do not automatically swap roles. YES Automatically swap roles. Contains the null value if ENTRY_TYPE is not C or if the value was not changed.
PARALLEL_DEGREE	VARCHAR(5)	The degree of parallelism to be used for Db2 Mirror resynchronization processing. Can contain the special value of NONE. Contains the null value if ENTRY_TYPE is not C or if the value was not changed.
SPLF_RESYNC_INTERVAL	INTEGER	The spooled file resynchronization interval. Contains the null value if ENTRY_TYPE is not C or if the value was not changed.
REPLICATE_USER_INDEX	VARCHAR(7)	The replication choice for user indexes. DISABLE Disable replication of user indexes. ENABLE Enable replication of user indexes. Contains the null value if ENTRY_TYPE is not C or if the value was not changed.
REPLICATE_USER_SPACE	VARCHAR(7)	The replication choice for user spaces. DISABLE Disable replication of user spaces. ENABLE Enable replication of user spaces. Contains the null value if ENTRY_TYPE is not C or if the value was not changed.
REPLICATE_DATA_QUEUE_ENTRIES	VARCHAR(7)	The replication choice for entries in a data queue (*DTAQ). DISABLE Disable replication of data queue entries. ENABLE Enable replication of data queue entries. Contains the null value if ENTRY_TYPE is not C or if the value was not changed.
ENCRYPTED_RDMA	VARCHAR(12)	The encrypted RDMA value. NOT REQUIRED Non-encrypted RDMA protocols may be used. REQUIRED Encrypted RDMA protocols must be used. Contains the null value if ENTRY_TYPE is not C or if the value was not changed.
AUTO_TAKEOVER	VARCHAR(7)	The choice for automatic takeover for unplanned outages. DISABLE Disable automatic takeover for unplanned outages. ENABLE Enable automatic takeover for unplanned outages. Contains the null value if ENTRY_TYPE is not C or if the value was not changed.
TAKEOVER_GROUP_NAME	VARCHAR(10)	The takeover group name. Contains the null value if ENTRY_TYPE is not O.
AUTO_SWITCHBACK	VARCHAR(3)	When ENTRY_TYPE is O and ACTION is CREATE or CHANGE, whether the takeover IP address group should be automatically switched back to its preferred node. NO Do not automatically return this takeover IP address group. YES Automatically return this takeover IP address group to its preferred node. Contains the null value if ENTRY_TYPE is not O or if the value was not changed.
PRIMARY_NODE	VARCHAR(8)	When ENTRY_TYPE is O and ACTION is CREATE or CHANGE, the name of the preferred node. When ENTRY_TYPE is S or T, the name of the partition designated as the primary node. When ENTRY_TYPE is W, the name of the new primary node. Contains the null value if ENTRY_TYPE is not O, S, T, or W.
SECONDARY_NODE	VARCHAR(8)	The name of the partition designated as the secondary node. When ENTRY_TYPE is W this is the name of the new secondary node. Contains the null value if ENTRY_TYPE is not S, T, or W.
IP_ADDRESS	VARCHAR(45)	The takeover IP address. Contains the null value if ENTRY_TYPE is not O and ACTION is not ADD or REMOVE.
OBJECTCONNECT_AUTO_START	VARCHAR(3)	Whether to automatically start the ObjectConnect for Db2 Mirror server. NO Do not automatically start the ObjectConnect for Db2 Mirror server. YES Automatically start the ObjectConnect for Db2 Mirror server. Contains the null value if ENTRY_TYPE is not J or if the value was not changed.
OBJECTCONNECT_MINIMUM_JOBS	INTEGER	The minimum number of ObjectConnect for Db2 Mirror server jobs that are started. Contains the null value if ENTRY_TYPE is not J or if the value was not changed.
OBJECTCONNECT_MAXIMUM_JOBS	INTEGER	The maximum number of ObjectConnect for Db2 Mirror server jobs that are started. Contains the null value if ENTRY_TYPE is not J or if the value was not changed.
OBJECTCONNECT_INACTIVE_TIME	INTEGER	The length of time, in minutes, that a ObjectConnect for Db2 Mirror server job will stay inactive before ending. Contains the null value if ENTRY_TYPE is not J or if the value was not changed.
ARCHIVE_RETENTION_DAY_COUNT	INTEGER	The number of days the flight recorder logs are retained. Contains the null value if ENTRY_TYPE is not F.
MAX_SYSBAS_PERCENTAGE	INTEGER	The percentage of *SYSBAS allocated for flight recorder logs. Contains the null value if ENTRY_TYPE is not F.
LOGGING_CATEGORY	VARCHAR(26)	The category for which flight recorder entries will be logged. ALL All categories CONFIGURATION PROCESSING Configuration processing DATABASE Database processing DATA QUEUE Data queue handler DB CONNECTION Database connection ENGINE COMMUNICATION Engine communication ENGINE CONNECTION Engine connection ENGINE CONTROLLER Engine controller ENGINE JOB Engine job ENGINE STATE Engine state FLIGHT RECORDER Flight recorder HEALTH MONITOR Health monitor IFS CONNECTION IFS connection LOGGER TESTING Logger testing NRG Network redundancy groups OBJECT CONNECTION Object connection OBJECT RECEIVER Object receiver OBJECT REGISTRY Object registry OBJECT REPLICATION MANAGER Object replication manager OBJECT SYNCHRONIZATION Object synchronization QUORUM SERVER Quorum server RCL Replication criteria list RESYNC Resynchronization process SAVE RESTORE Save and restore processing SECURITY OBJECT Security object handler SPOOL Spooled file handler OUTPUT AND JOB QUEUE Output queue and job queue processing UTILITIES Utilities processing VARY IASP Vary IASP processing WORK MANAGEMENT Work management Contains the null value if ENTRY_TYPE is not F.
LOGGING_LEVEL	VARCHAR(7)	The level at which an entry is written to the flight recorder log. DEBUG Log entries for the INFO level are generated, plus debug information. ERROR Log entries are generated for run time errors and unexpected conditions. INFO Log entries for the WARN level are generated, plus interesting run time events. NONE No log entries are generated. SYSTEM When LOGGING_CATEGORY is ALL the shipped default level is set for each category. WARNING Log entries for the ERROR level are generated, plus entries for errors or other run time situations that are unexpected or unusual but not necessarily wrong. Contains the null value if ENTRY_TYPE is not F.

Example

List when Db2 Mirror active replication was suspended in the last 2 months.


SELECT * FROM TABLE(
  SYSTOOLS.AUDIT_JOURNAL_M8(  
      STARTING_TIMESTAMP => CURRENT TIMESTAMP - 2 MONTHS
  )
)
WHERE ENTRY_TYPE = 'C' AND
      ACTION IN ('SUSPEND', 'MAINTENANCE');