AUDIT_JOURNAL_M6 table function

The AUDIT_JOURNAL_M6 table function returns rows from the audit journal that contain information from the M6 (Db2® Mirror Communication 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_M6 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 M6 audit journal entry.
ENTRY_TYPE	CHAR(1)	The type of Network Redundancy Group (NRG) entry. A Add NRG C Change NRG R Remove NRG
ENTRY_TYPE_DETAIL	VARCHAR(200)	Descriptive text that corresponds to the entry type.
NRG_NAME	VARCHAR(15)	The name associated with the NRG.
NRG_TYPE	VARCHAR(12)	Type of NRG. UNSPECIFIED Unspecified DB2® MIRROR Db2 Mirror USER DEFINED User defined Contains the null value if ENTRY_TYPE is R.
TEXT_DESCRIPTION	VARCHAR(50)	Text description. Contains the null value if there is no text description or if ENTRY_TYPE is R.
LOAD_BALANCE_LINK_COUNT	INTEGER	Load balance link count. Contains the null value if ENTRY_TYPE is R.
LINK_COUNT	INTEGER	Number of links configured in the group. This indicates the number of sets of link information columns, with a suffix of _n, that contain values. The information for links greater than LINK_COUNT will contain the null value. Contains the null value if ENTRY_TYPE is R. All the link information columns will contain the null value.
ADDRESS_SPACE_TYPE_1	CHAR(4)	The address family of the first link. IPV4 Internet Protocol Version 4 IPV6 Internet Protocol Version 6
SOURCE_ADDRESS_1	VARCHAR(45)	The local IP address for the first link.
LINE_DESCRIPTION_1	VARCHAR(10)	The local line description for the first link.
VIRTUAL_LAN_ID_1	INTEGER	The local VLAN ID for the first link.
TARGET_ADDRESS_1	VARCHAR(45)	The remote IP address for the first link.
LINK_TYPE_1	CHAR(2)	The link type of the first link. V1 RoCE v1 V2 RoCE v2
LINK_PRIORITY_1	INTEGER	The priority of the first link.
ADDRESS_SPACE_TYPE_2	CHAR(4)	The address family of the second link. IPV4 Internet Protocol Version 4 IPV6 Internet Protocol Version 6
SOURCE_ADDRESS_2	VARCHAR(45)	The local IP address for the second link.
LINE_DESCRIPTION_2	VARCHAR(10)	The local line description for the second link.
VIRTUAL_LAN_ID_2	INTEGER	The local VLAN ID for the second link.
TARGET_ADDRESS_2	VARCHAR(45)	The remote IP address for the second link.
LINK_TYPE_2	CHAR(2)	The link type of the second link. V1 RoCE v1 V2 RoCE v2
LINK_PRIORITY_2	INTEGER	The priority of the second link.
ADDRESS_SPACE_TYPE_3	CHAR(4)	The address family of the third link. IPV4 Internet Protocol Version 4 IPV6 Internet Protocol Version 6
SOURCE_ADDRESS_3	VARCHAR(45)	The local IP address for the third link.
LINE_DESCRIPTION_3	VARCHAR(10)	The local line description for the third link.
VIRTUAL_LAN_ID_3	INTEGER	The local VLAN ID for the third link.
TARGET_ADDRESS_3	VARCHAR(45)	The remote IP address for the third link.
LINK_TYPE_3	CHAR(2)	The link type of the third link. V1 RoCE v1 V2 RoCE v2
LINK_PRIORITY_3	INTEGER	The priority of the third link.
ADDRESS_SPACE_TYPE_4	CHAR(4)	The address family of the fourth link. IPV4 Internet Protocol Version 4 IPV6 Internet Protocol Version 6
SOURCE_ADDRESS_4	VARCHAR(45)	The local IP address for the fourth link.
LINE_DESCRIPTION_4	VARCHAR(10)	The local line description for the fourth link.
VIRTUAL_LAN_ID_4	INTEGER	The local VLAN ID for the fourth link.
TARGET_ADDRESS_4	VARCHAR(45)	The remote IP address for the fourth link.
LINK_TYPE_4	CHAR(2)	The link type of the fourth link. V1 RoCE v1 V2 RoCE v2
LINK_PRIORITY_4	INTEGER	The priority of the fourth link.
ADDRESS_SPACE_TYPE_5	CHAR(4)	The address family of the fifth link. IPV4 Internet Protocol Version 4 IPV6 Internet Protocol Version 6
SOURCE_ADDRESS_5	VARCHAR(45)	The local IP address for the fifth link.
LINE_DESCRIPTION_5	VARCHAR(10)	The local line description for the fifth link.
VIRTUAL_LAN_ID_5	INTEGER	The local VLAN ID for the fifth link.
TARGET_ADDRESS_5	VARCHAR(45)	The remote IP address for the fifth link.
LINK_TYPE_5	CHAR(2)	The link type of the fifth link. V1 RoCE v1 V2 RoCE v2
LINK_PRIORITY_5	INTEGER	The priority of the fifth link.
ADDRESS_SPACE_TYPE_6	CHAR(4)	The address family of the sixth link. IPV4 Internet Protocol Version 4 IPV6 Internet Protocol Version 6
SOURCE_ADDRESS_6	VARCHAR(45)	The local IP address for the sixth link.
LINE_DESCRIPTION_6	VARCHAR(10)	The local line description for the sixth link.
VIRTUAL_LAN_ID_6	INTEGER	The local VLAN ID for the sixth link.
TARGET_ADDRESS_6	VARCHAR(45)	The remote IP address for the sixth link.
LINK_TYPE_6	CHAR(2)	The link type of the sixth link. V1 RoCE v1 V2 RoCE v2
LINK_PRIORITY_6	INTEGER	The priority of the sixth link.
ADDRESS_SPACE_TYPE_7	CHAR(4)	The address family of the seventh link. IPV4 Internet Protocol Version 4 IPV6 Internet Protocol Version 6
SOURCE_ADDRESS_7	VARCHAR(45)	The local IP address for the seventh link.
LINE_DESCRIPTION_7	VARCHAR(10)	The local line description for the seventh link.
VIRTUAL_LAN_ID_7	INTEGER	The local VLAN ID for the seventh link.
TARGET_ADDRESS_7	VARCHAR(45)	The remote IP address for the seventh link.
LINK_TYPE_7	CHAR(2)	The link type of the seventh link. V1 RoCE v1 V2 RoCE v2
LINK_PRIORITY_7	INTEGER	The priority of the seventh link.
ADDRESS_SPACE_TYPE_8	CHAR(4)	The address family of the eighth link. IPV4 Internet Protocol Version 4 IPV6 Internet Protocol Version 6
SOURCE_ADDRESS_8	VARCHAR(45)	The local IP address for the eighth link.
LINE_DESCRIPTION_8	VARCHAR(10)	The local line description for the eighth link.
VIRTUAL_LAN_ID_8	INTEGER	The local VLAN ID for the eighth link.
TARGET_ADDRESS_8	VARCHAR(45)	The remote IP address for the eighth link.
LINK_TYPE_8	CHAR(2)	The link type of the eighth link. V1 RoCE v1 V2 RoCE v2
LINK_PRIORITY_8	INTEGER	The priority of the eighth link.
ADDRESS_SPACE_TYPE_9	CHAR(4)	The address family of the ninth link. IPV4 Internet Protocol Version 4 IPV6 Internet Protocol Version 6
SOURCE_ADDRESS_9	VARCHAR(45)	The local IP address for the ninth link.
LINE_DESCRIPTION_9	VARCHAR(10)	The local line description for the ninth link.
VIRTUAL_LAN_ID_9	INTEGER	The local VLAN ID for the ninth link.
TARGET_ADDRESS_9	VARCHAR(45)	The remote IP address for the ninth link.
LINK_TYPE_9	CHAR(2)	The link type of the ninth link. V1 RoCE v1 V2 RoCE v2
LINK_PRIORITY_9	INTEGER	The priority of the ninth link.
ADDRESS_SPACE_TYPE_10	CHAR(4)	The address family of the tenth link. IPV4 Internet Protocol Version 4 IPV6 Internet Protocol Version 6
SOURCE_ADDRESS_10	VARCHAR(45)	The local IP address for the tenth link.
LINE_DESCRIPTION_10	VARCHAR(10)	The local line description for the tenth link.
VIRTUAL_LAN_ID_10	INTEGER	The local VLAN ID for the tenth link.
TARGET_ADDRESS_10	VARCHAR(45)	The remote IP address for the tenth link.
LINK_TYPE_10	CHAR(2)	The link type of the tenth link. V1 RoCE v1 V2 RoCE v2
LINK_PRIORITY_10	INTEGER	The priority of the tenth link.
ADDRESS_SPACE_TYPE_11	CHAR(4)	The address family of the eleventh link. IPV4 Internet Protocol Version 4 IPV6 Internet Protocol Version 6
SOURCE_ADDRESS_11	VARCHAR(45)	The local IP address for the eleventh link.
LINE_DESCRIPTION_11	VARCHAR(10)	The local line description for the eleventh link.
VIRTUAL_LAN_ID_11	INTEGER	The local VLAN ID for the eleventh link.
TARGET_ADDRESS_11	VARCHAR(45)	The remote IP address for the eleventh link.
LINK_TYPE_11	CHAR(2)	The link type of the eleventh link. V1 RoCE v1 V2 RoCE v2
LINK_PRIORITY_11	INTEGER	The priority of the eleventh link.
ADDRESS_SPACE_TYPE_12	CHAR(4)	The address family of the twelfth link. IPV4 Internet Protocol Version 4 IPV6 Internet Protocol Version 6
SOURCE_ADDRESS_12	VARCHAR(45)	The local IP address for the twelfth link.
LINE_DESCRIPTION_12	VARCHAR(10)	The local line description for the twelfth link.
VIRTUAL_LAN_ID_12	INTEGER	The local VLAN ID for the twelfth link.
TARGET_ADDRESS_12	VARCHAR(45)	The remote IP address for the twelfth link.
LINK_TYPE_12	CHAR(2)	The link type of the twelfth link. V1 RoCE v1 V2 RoCE v2
LINK_PRIORITY_12	INTEGER	The priority of the twelfth link.
ADDRESS_SPACE_TYPE_13	CHAR(4)	The address family of the thirteenth link. IPV4 Internet Protocol Version 4 IPV6 Internet Protocol Version 6
SOURCE_ADDRESS_13	VARCHAR(45)	The local IP address for the thirteenth link.
LINE_DESCRIPTION_13	VARCHAR(10)	The local line description for the thirteenth link.
VIRTUAL_LAN_ID_13	INTEGER	The local VLAN ID for the thirteenth link.
TARGET_ADDRESS_13	VARCHAR(45)	The remote IP address for the thirteenth link.
LINK_TYPE_13	CHAR(2)	The link type of the thirteenth link. V1 RoCE v1 V2 RoCE v2
LINK_PRIORITY_13	INTEGER	The priority of the thirteenth link.
ADDRESS_SPACE_TYPE_14	CHAR(4)	The address family of the fourteenth link. IPV4 Internet Protocol Version 4 IPV6 Internet Protocol Version 6
SOURCE_ADDRESS_14	VARCHAR(45)	The local IP address for the fourteenth link.
LINE_DESCRIPTION_14	VARCHAR(10)	The local line description for the fourteenth link.
VIRTUAL_LAN_ID_14	INTEGER	The local VLAN ID for the fourteenth link.
TARGET_ADDRESS_14	VARCHAR(45)	The remote IP address for the fourteenth link.
LINK_TYPE_14	CHAR(2)	The link type of the fourteenth link. V1 RoCE v1 V2 RoCE v2
LINK_PRIORITY_14	INTEGER	The priority of the fourteenth link.
ADDRESS_SPACE_TYPE_15	CHAR(4)	The address family of the fifteenth link. IPV4 Internet Protocol Version 4 IPV6 Internet Protocol Version 6
SOURCE_ADDRESS_15	VARCHAR(45)	The local IP address for the fifteenth link.
LINE_DESCRIPTION_15	VARCHAR(10)	The local line description for the fifteenth link.
VIRTUAL_LAN_ID_15	INTEGER	The local VLAN ID for the fifteenth link.
TARGET_ADDRESS_15	VARCHAR(45)	The remote IP address for the fifteenth link.
LINK_TYPE_15	CHAR(2)	The link type of the fifteenth link. V1 RoCE v1 V2 RoCE v2
LINK_PRIORITY_15	INTEGER	The priority of the fifteenth link.
ADDRESS_SPACE_TYPE_16	CHAR(4)	The address family of the sixteenth link. IPV4 Internet Protocol Version 4 IPV6 Internet Protocol Version 6
SOURCE_ADDRESS_16	VARCHAR(45)	The local IP address for the sixteenth link.
LINE_DESCRIPTION_16	VARCHAR(10)	The local line description for the sixteenth link.
VIRTUAL_LAN_ID_16	INTEGER	The local VLAN ID for the sixteenth link.
TARGET_ADDRESS_16	VARCHAR(45)	The remote IP address for the sixteenth link.
LINK_TYPE_16	CHAR(2)	The link type of the sixteenth link. V1 RoCE v1 V2 RoCE v2
LINK_PRIORITY_16	INTEGER	The priority of the sixteenth link.

Example

List NRG configuration changes from the last month


SELECT * FROM TABLE(
  SYSTOOLS.AUDIT_JOURNAL_M6(  
      STARTING_TIMESTAMP => CURRENT TIMESTAMP - 1 MONTH
  )
)
WHERE ENTRY_TYPE = 'C';