RTSV journal record type in IDMS
Article ID: 71581
Updated On:
Products
Issue/Introduction
When are journal records of type RTSV produced?
Environment
Release: All supported releases.
Component: SQLOPT
Resolution
At the start of an SQL command, a "save point" is established.
No journal record is written at that point but the current journal sequence number is noted in a control block.
If for some reason, the SQL processing decides that this one command must be rolled out (e.g. a data exception), then CA-IDMS will roll back the updates of that SQL command back to the saved journal sequence number.
Then an RTSV journal record is written to indicate what happened.
The RTSV record will contain the saved journal sequence number (in field JTRSVSEQ).
If there is an abend later on which requires that the whole transaction be rolled out, then when the RTSV record is encountered, the rollback process will know that all the work for that transaction back to the journal sequence number has already been backed out.
Additional Information
Feedback
