The tran_log table stores transaction operation information for all replicated transactions.
Table A-13 lists the columns in the tran_log table.
Column name |
Datatype |
Description |
|---|---|---|
conn_id |
numeric(18,0) |
ID of the primary connection this transaction operation came from |
txid_page |
int |
Transaction ID page |
txid_row |
smallint |
Transaction ID row |
log_ts_high |
smallint |
Log timestamp high value |
log_ts_low |
int |
Log timestamp low value |
opid_page |
int |
Operation ID page |
opid_row |
smallint |
Operation ID row |
op_code |
tinyint |
Identifies type of operation |
op_xstat |
int |
Identifies operation as either update or delete |
commit_tstamp |
datetime |
Timestamp of the transaction commit in the Adaptive Server log |
username |
rpl_sysname |
User login that performed the operation |
part_id |
numeric(18,0) |
Primary article ID |
tlog_tstamp |
datetime |
Time stamp of the operation in the transaction log table |
Each row in the tran_log table identifies a single replicated transaction operation from the primary database associated with the primary connection identified by the value in the conn_id column.
The ASE Replicator Publisher component adds rows to the tran_log table when it reads new transaction operations from the native Adaptive Server transaction log.
The tran_log table is truncated by the truncate_queue procedure.
