What are journal records of type RTSV ?

Document ID : KB000071581
Last Modified Date : 06/03/2018
Show Technical Document Details
When are journal records of type RTSV produced?
At the start of an SQL command, we establish what is known as a save point.
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 juornal 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:
#JTRDS dsect: https://docops.ca.com/ca-idms-ref/19/en/dsect-reference/ca-idms-dsect-files/jtrds