Replication Server uses the information in the rs_lastcommit table to find the last transaction committed from each data source.
The rs_lastcommit table is stored in each user database, not in the RSSD.
Column |
Datatype |
Description |
|---|---|---|
origin |
int |
ID number for the primary database a row represents. |
origin_qid |
binary |
Identifies the last committed transaction in the stable queue for the origin database. |
secondary_qid |
binary |
If a subscription materialization queue exists for the origin database, this column contains the last transaction in that queue that has been committed in the replicate database. |
origin_time |
datetime |
Time at origin for the transaction. |
dest_commit_time |
datetime |
Time the transaction was committed at the destination. |
pad1 |
binary(255) |
Filler to pad the row so only one row fits on a database page. |
pad2 |
binary(255) |
Filler to pad the row so only one row fits on a database page. |
pad3 |
binary(255) |
Filler to pad the row so only one row fits on a database page. |
pad4 |
binary(255) |
Filler to pad the row so only one row fits on a database page. |
pad5 |
binary(255) |
Filler to pad the row so only one row fits on a database page. |
pad6 |
binary(255) |
Filler to pad the row so only one row fits on a database page. |
pad7 |
binary(255) |
Filler to pad the row so only one row fits on a database page. |
pad8 |
binary(83) |
Filler to pad the row so only one row fits on a database page. |