M7 (Db2 Mirror Replication Services) journal entries

This table provides the format of the M7 (Db2® Mirror Replication Services) journal entries. These journal entries are sent from the Db2 Mirror for i product.

Information from this audit journal entry can be queried with the SYSTOOLS.AUDIT_JOURNAL_M7 table function: AUDIT_JOURNAL_M7

Table 1. M7 (Db2 Mirror Replication Services) journal entries. QASYM7J5 Field Description File
Offset	Field	Format	Description
J5	Field	Format	Description
1			Heading fields common to all entry types. See Standard heading fields for audit journal entries QJORDJE5 Record Format (*TYPE5) for field listing.
610	Entry Type	Char(1)	The type of entry. A Add active replication criteria rule D Duplicate replication criteria rules (a rename library was performed) P Activate pending replication criteria rules R Remove active replication criteria rule S Resynchronization of eligible objects U User deferred or deleted entries in the Object Tracking List (OTL) using the SQL QSYS2.CHANGE_RESYNC_ENTRIES procedure V Generic versioning
611	Action	Char(3)	Action to perform. When Entry type (J5 offset 610) is V (Generic versioning) this field can contain: ADD Register (add) an applied version information entry for a specific feature or function in the Mirror Version List (MVL). APY Apply pending version information entries. RMV Unregister (remove) an applied version information entry from the Mirror Version List (MVL). RFS Refresh the version information entries in Mirror Version List by running user specified Version Handlers.
614	Rule Identifier	Bin(5)	When Entry type (J5 offset 610) is A, D, or R this is the identifier for this replication criteria rule. When Entry type (J5 offset 610) is V and Action (J5 offset 611) is ADD or RMV, this is the version entry number. This is a 4 byte field and contains the same value as the 8 byte Rule Identifier (J5 offset 856) field. When this value is 0 and the Entry type (J5 offset 610) is A, D, R, or V, the value is too large for this field and the 8 byte field must be used.
618	Resync Type	Char(10)	When Entry type (J5 offset 610) is S this is the type of resynchronization performed. RESUME Resynchronization of objects that are on the Object Tracking List (OTL) because the node was previously blocked. RECLONE Resynchronization of actively replicating objects. When Entry type (J5 offset 610) is V this is the version group.
628	Inclusion State	Char(10)	When Entry type (J5 offset 610) is A or D this is the inclusion state of the replication criteria rule. DEFINITION Objects that best match this replication criteria rule are replicated. Only the definition of the object is replicated. EXCLUDE Objects that best match this replication criteria rule are not replicated INCLUDE Objects that best match this replication criteria rule are replicated When Entry type (J5 offset 610) is V and Action (J5 offset 611) is ADD or RMV this is the version entry activation state indicator. IMMEDIATE This version entry can be activated immediately from an applied state. RESUME This version entry can be activated from an applied state the next time replication is resumed.
638	ASP Name	Char(10)	ASP Name or *SYSBAS. When entry type (J5 offset 610) is A, D, P, S, or R this field contains the name of the ASP associated with this replication criteria rule. This field will be blank if System value (J5 offset 686) or Environment variable (J5 offset 696) contain a value. When entry type (J5 offset 610) is U this field contains the ASP associated with the SQL QSYS2.CHANGE_RESYNC_ENTRIES procedure.
648	Library Name	Char(10)	The library name. When entry type (J5 offset 610) is A, D, R this field contains the name of the library associated with the replication criteria rule. If this field is blank and ASP name (J5 offset 638) contains a value, then all supported objects in all libraries in the ASP will be operated on. When entry type (J5 offset 610) is U this field contains the name of the library associated with the SQL QSYS2.CHANGE_RESYNC_ENTRIES procedure.
658	Object Type	Char(8)	The object type. When Entry type (J5 offset 610) is A, D, R this is the object type associated with the replication criteria rule. If this field is blank and Library name (J5 offset 648) contains a value, then all objects of all supported object types in that library will be operated on. When Entry type (J5 offset 610) is U this is the object type associated with the SQL QSYS2.CHANGE_RESYNC_ENTRIES procedure.
666	Object Name	Char(10)	The name of the object. When entry type (J5 offset 610) is A, D, or R this field contains the name of the object associated with this replication criteria rule. If this field is blank and Library name (J5 offset 648) contains a value, then all objects of Object type (J5 offset 658) in that library will be operated on. When entry type (J5 offset 610) is U this field contains the name of the object associated with the SQL QSYS2.CHANGE_RESYNC_ENTRIES procedure.
676	Original Library Name	Char(10)	Original library name. This field only contains data when Entry type (J5 offset 610) is D.
686	System Value	Char(10)	The name of the system value. When Entry type (J5 offset 610) is A or R this field contains the system value associated with this replication criteria rule. This field will be blank if Object name (J5 offset 666) or Environment variable (J5 offset 696) contain a value.
696	Environment Variable	Char(128)	When Entry type (J5 offset 610) is A or R this field contains the environment variable associated with this replication criteria rule. This field will be blank if Object name (J5 offset 666) or System value (J5 offset 686) contains a value. When Entry type (J5 offset 610) is V this field contains the version name. If this field is blank and Version Group (J5 offset 618) contains a value, all version names in that group will be operated on.
824	Apply Label	Char(26)	When Entry type (J5 offset 610) is A, P, or R this is the label used to identify replication criteria rules. When Entry type (J5 offset 610) is V and Action (J5 offset 611) is ADD or RMV this is the version identifier. The format is xxx.yyy.zzz where each piece of the version contains the digits 0-9: xxx The major version number. This value is always present for a version number. yyy An optional minor version number. zzz An optional revision number.
850	(Reserved Area)	Char(2)
852	Number of Objects	Bin(5)	When Entry type (J5 offset 610) is A, P, R, or S this is the number of Save/Restore entries added to the OTL for objects affected by this operation. When Entry type (J5 offset 610) is U this is the number of OTL rows affected by the SQL QSYS2.CHANGE_RESYNC_ENTRIES procedure. This is a 4 byte field and contains the same value as the 8 byte Number of Objects (J5 offset 864) field. When this value is -1, the value is too large for this field and the 8 byte field must be used.
856	Rule Identifier	BIN(10)	When Entry type (J5 offset 610) is A, D, or R this is the identifier for this replication criteria rule. When Entry type (J5 offset 610) is V and Action (J5 offset 611) is ADD or RMV, this is the version entry number.
864	Number of Objects	Bin(10)	Entry type (J5 offset 610) is A, P, R, or S this is the number of Save/Restore entries added to the OTL for objects affected by this operation. When Entry type (J5 offset 610) is U this is the number of OTL rows affected by the SQL QSYS2.CHANGE_RESYNC_ENTRIES procedure.
872	(Reserved Area)	Char(100)