Help SQL Replication

How the Capture program processes journal entry types for SQL Replication (System i)

The following table describes how the Capture program processes different journal entry types.

Table 1. Capture program processing by journal entry
Journal code1 Entry type Description Processing
C CM Set of record changes committed Insert a record in the UOW stable.
C RB Rollback No UOW row inserted.
F AY Journaled changes applied to physical file member Issue an ASN2004 message and full refresh of file.
F CE Change end of data for physical file Issue an ASN2004 message and full refresh of file.
F CR Physical file member cleared Issue an ASN2004 message and full refresh of file.
F EJ Journaling for physical file member ended Issue an ASN200A message and full refresh of the file. A full-refresh occurs whenever the Capture program reads an EJ journal entry, regardless of whether the user or the system caused journaling to end. Refer to the appropriate System i® documentation for information about implicit end-journal events for a file.
F IZ Physical file member initialized Issue an ASN2004 message and full refresh of file.
F MD Member removed from physical file (DLTLIB, DLTF, or RMVM) Issue an ASN200A message and attempt a full refresh.
F MF Storage for physical file member freed Issue an ASN200A message and full refresh of file.
F MM Physical file containing member moved (Rename Object (RNMOBJ) of library, Move Object (MOVOBJ) of file) Issue an ASN200A message and attempt a full refresh.
F MN Physical file containing member renamed (RNMOBJ of file, Rename Member (RNMM)) Issue an ASN200A message and attempt a full refresh.
F MR Physical file member restored Issue an ASN2004 message and full refresh of file.
F RC Journaled changes removed from physical file member Issue an ASN2004 message and full refresh of file.
F RG Physical file member reorganized If the RRN of the source table is being used as the replication key, issue an ASN2004 message and full refresh of file.
J NR Identifier for next journal receivers Reset the Capture program.
J PR Identifier for previous journal receivers Increment the unique sequence number counter.
R DL Record deleted from physical file member Insert a DLT record in the CD table.
R DR Record deleted for rollback Insert a DLT record in the CD table.
R PT Record added to physical file member Insert an ADD record in the CD table.
R PX Record added directly to physical file member Insert an ADD record in the CD table.
R UB Before-image of record updated in physical file member See note 2.
R UP After-image of record updated in physical file member See note 2.
R BR Before-image of record updated for rollback See note 3.
R UR After-image of record updated for rollback See note 3.
Note:
  1. The following values are used for the journal codes:
    C
    Commitment control operation
    F
    Database file operation
    J
    Journal or journal receiver operation
    R
    Operation on specific record
  2. The R-UP image and the R-UB image form a single UPD record in the CD table if the PARTITION_KEYS_CHG column in the register table is N. Otherwise, the R-UB image inserts a DLT record in the CD table and the R-UP image inserts an ADD record in the CD table.
  3. The R-UR image and the R-BR image form a single UPD record in the CD table if the PARTITION_KEYS_CHG column in the register table is N. Otherwise, the R-BR image inserts a DLT record in the CD table and the R-UR image inserts an ADD record in the CD table.

All other journal entry types are ignored by the Capture program.


Send your feedback | Information roadmap | The Q+SQL Replication Forum

Update icon Last updated: 2013-10-25