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
integer not null
Primary key of a replicated table.
varchar(20) not null
Other attribute of a replicated table.
smallint not null
Identifies the database where the transaction originated.
integer not null
Identifier given by the DBMS Server to the original transaction.
integer not null
The sequence of the operation (insert, update, delete) within the original transaction.
Last modified date: 01/30/2023