Appendix A: Distribution Database Schema

Transaction log table

The tran_log table stores transaction operation information for all replicated transactions.

Table A-13 lists the columns in the tran_log table.

**Table A-13: Transaction 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.

View this book as PDF