Previous Topic: SORTDFLT=YES Report Section for RETIXNext Topic: When to Use


Resetting the TSN

The Transaction Sequence Number (TSN), of the transaction that added or last updated each row, is stored in the Record Control Element (RCE) with each row. The TSN is used to ensure that the transaction has ended before granting a row lock to another transaction. A reset sets the TSN in the row to zero (that is never used as a TSN). The TSN is not normally reset because it does not normally need to be reset.