M9 (Db2 Mirror Replication State) journal entries

This table provides the format of the M9 (Db2® Mirror Replication State) 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_M9 table function: AUDIT_JOURNAL_M9

Table 1. M9 (Db2 Mirror Replication State) journal entries. QASYM9J5 Field Description File
Offset Field Format Description
J5
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.
C
Change to the replication state of an ASP
Start of changeMEnd of change
Start of changeChange to migration processingEnd of change
611 ASP Name Char(10)

When Entry type (J5 offset 610) is C this field contains the ASP name for which the replication state changed. This field may contain *SYSBAS.

Start of changeWhen Entry type (J5 offset 610) is M this field contains the migration type.
IFS RST
Migration processing for Integrated File System (IFS) object synchronization.
MANAGER
Processing related to the Migration Manager.
OBJECT MIR
Migration processing for objects within libraries that use the Db2 Mirror method of synchronization.
OBJECT RST
Migration processing for objects within libraries that use the save and restore method of synchronization.
End of change
621 Replication State Char(12)
When Entry type (J5 offset 610) is C this field contains the Db2 Mirror replication state.
ACTIVE
The nodes are communicating with each other and are actively sending and receiving changes to replicated objects.
BLOCKED
Active replication is suspended and replicated objects on the secondary node can be referenced, but the objects can be missing changes made on the primary node. Any attempt to change replicated objects will be blocked until active replication is resumed.
NOT MIRRORED
The product is not installed or the initial configuration is not complete.
TRACKING
Active replication is suspended and changes to replicated objects are allowed on the primary node and are tracked by Db2 Mirror.
Start of changeWhen Entry type (J5 offset 610) is M this field contains the migration phase.
FINAL SETUP
Final environment configuration is being performed to complete the system migration stage.
FINAL SYNC
Final synchronization is being performed to complete the migration of objects during the data synchronization stage.
PAUSED
Synchronization of objects has stopped. Changes to objects on the source node are being tracked on the source node.
SETUP
Initial environment configuration is being performed to set up the Db2 Mirror Migration Feature.
SWAPPING
A primary node role swap is being performed.
SYNC
Changes to objects on the source node are being synchronized to the copy node.
SYNC CMPLT
The data synchronization stage is complete. The migration manager is ready to perform the primary node role swap.
End of change
633 Previous Replication State Char(12)

When Entry type (J5 offset 610) is C this field contains the previous Db2 Mirror replication state.

Start of changeWhen Entry type (J5 offset 610) is M this field contains the previous migration phase.End of change
645 Start of changeMigration Phase DetailEnd of change Char(1) Start of changeWhen Entry type (J5 offset 610) is M this field contains the migration phase detail.
A
Processing is actively being performed.
C
Processing is complete.
E
Processing encountered an error.
I
No processing is being performed.
P
Processing is actively being performed in preparation putting the source node into a restricted state..
R
Preparations before putting the source node into a restricted state has successfully completed.
End of change
646 Reason for Change Bin(5)

When Entry type (J5 offset 610) is C this field contains the reason the replication state changed to BLOCKED or TRACKING. For a description of the reason codes see Replication detail info. This field will only contain data when the Replication State (J5 offset 621) is BLOCKED or TRACKING.

Start of changeWhen Entry type (J5 offset 610) is M this field contains additional information about processing defined by Migration phase detail (J5 offset 645).End of change
650 (Reserved Area) Char(100)