Table Clear

The Table Clear events clear data in a table on the source system. Depending on the type of Table Clear event that has taken place on the source system, CDC Replication supports an IBM® i journal code.

The following list describes the IBM i journal codes for Table Clear events:

CR

Indicates that a file, table, or member has been cleared on the source system.

MD

Indicates that a file, table, or member has been deleted on the source system. This uses journal control fields for auditing replication activities.

RS

Indicates that prior to a refresh, a file, table, or member has been cleared on the source system. In this case, the refresh is a result of an implied table restore.

AY

Journal Change Apply Start, which indicates the starting point for a set of journal entries applied to a file, table, or member on the source system. CDC Replication appends this entry to the audit table on the target system.

AZ

Journal Change Apply End, which indicates the ending point for a set of journal entries applied to a file, table, or member on the source system. CDC Replication appends this entry to the audit table on the target system.

RC

Journal Change Remove Start, which indicates the starting point for a set of journal entries and reverses previous applies that were made to a file, table, or member on the source system. CDC Replication appends this entry to the audit table on the target system.

RZ

Journal Change Remove End, which indicates the ending point for a set of journal entries and reverses previous applies that were made to a file, table, or member on the source system. CDC Replication appends this entry to the audit table on the target system. RZ is a journal code generated by CDC Replication. It is not an IBM i journal code.

JM

Indicates that journaling on the file or table has been started on the source system.

EJ

Indicates that journaling on the file or table ended on the source system.

RG

Indicates that a file, table, or member has been reorganized on the source system.

MN

Before Rename, which indicates when the file or member has been renamed on the source system. CDC Replication appends this entry to the audit table on the target system.

NZ

After Rename, which indicates that a new name has been given to a file or member on the source system. CDC Replication appends this entry to the audit table on the target system.

MM

Before Publication File Move, which indicates when the file has been moved on the source system. CDC Replication appends this entry to the audit table on the target system.

MZ

After Publication File Move, which indicates a new location for a file that has been moved on the source system. CDC Replication appends this entry to the audit table on the target system. MZ is a journal code generated by CDC Replication. It is not an IBM i journal code.

MR

Indicates that a file on the source system has been restored.

CH

Indicates that a file on the source system has been changed. When a non-schema change is applied to the audit table on the source system, CDC Replication appends this entry to the audit table on the target system.