Table: sl_log_2

8.9. Table: sl_log_2

Stores each change to be propagated to subscriber nodes

Structure of sl_log_2

log_origin

integer

Origin node from which the change came

log_txid

bigint

Transaction ID on the origin node

log_tableid

integer

The table ID (from sl_table.tab_id) that this log entry is to affect

log_actionseq

bigint

log_cmdtype

character(1)

Replication action to take. U = Update, I = Insert, D = DELETE

log_cmddata

text

The data needed to perform the log action

Indexes on sl_log_2

sl_log_2_idx1

log_origin, log_txid, log_actionseq