TTS – Transaction tracking system: - To help
you ensure database integrity
The following
keywords help in integrity checking
Ttsbegin- Indicates the beginning of the transaction
Ttscommit – indicates the successful end of a transaction,
the ensures the transaction performed as intended upon completion
Ttsabort- Used as an exception to abort and roll
back a transaction to the state before the ttsbegin
Nested ttsbegins
and ttscommits are ignored in that a lock is held until the last ttscommit is
reached however the system does keep track of the tts level, Each time a tts
begin is called, the tts level increases by one. Every ttscommit decreases the
level by one.
No comments:
Post a Comment