3.3.3 Synchronization point setting and rollback

Table 3-6 explains setting synchronization points and handling transactions.

Table 3-6 Synchronization points and transactions

Synchronization pointSet by:Handling transactions
Set points in UAP by executing SQL statementsExecuting COMMIT statementValidated1
Executing ROLLBACK statementInvalidated1, 2
Set points in HiRDB by executing SQL statementsExecuting definition SQL statementsValidated1
Executing PURGE TABLE statementValidated1
Processing cannot be continued while executing SQL statementsInvalidated3
Set points in HiRDB by terminating UAPUAP normal terminationValidated
UAP abnormal terminationInvalidated2
1 Cannot be executed in the OLTP environment. For details about synchronization point setting and rollback in the OLTP environment, see 3.3.4 UAP transaction management in an OLTP environment.
2 Results in implicit rollback; the following are major causes of implicit rollback:
3 When a transaction is invalidated, all transactions since the most recent synchronization point are invalidated.
  • Deadlock
  • RDAREA page shortage
  • Detection of RDAREA error or shutdown