Was this helpful?
Archive Table
The archive table contains all the replicated columns in the base table, and the replicated transaction key, which is made up of the following information:
Database number of the originating database
Transaction ID
Transaction sequence number
Each row in the archive table reflects a row that was in the shadow table.
This is an example of a replicated archive table:
Column Name
Data Type
Description
column1
integer not null
Primary key of a replicated table.
column2
varchar(20) not null
Other attribute of a replicated table.
sourcedb
smallint not null
Identifies the database where the transaction originated.
transaction_id
integer not null
Identifier given by the DBMS Server to the original transaction.
sequence_no
integer not null
The sequence of the operation (insert, update, delete) within the original transaction.
Last modified date: 06/10/2024