JADE_TRAN_INFO Table

Product Information > JADE Synchronized Database Service (SDS) Administration Guide > Chapter 2 - Relational Population Service (RPS) Support > JADE_TRAN_INFO Table

JADE_TRAN_INFO Table

The optional JADE_TRAN_INFO table records the transaction id, transaction start time, and transaction end time. This table has the following columns.

tranid bigint
start_time datetime (SqlServer 2000 or 2005) or start_time datetime2 (SqlServer 2008 or higher)
end_time datetime

The creation and use of the JADE_TRAN_INFO table is controlled by the UseTranInfoTable parameter in the [JadeRps] section of the JADE initialization file.

If the UseTranInfoTable parameter is defined and it is set to true:

The table is created, if it does not exist
A row is added to the table for every transaction to record id, start time, and end time
The row is committed to the relational database as part of the transaction
Rows are never deleted from the table by the JADE RPS node

It is your responsibility to delete the rows from the table when they are no longer required.