Nonstop Database, HiRDB Version 9 UAP Development Guide
The following table explains the setting of synchronization points and the handling of transactions.
Table 3-6 Synchronization points and transactions
Synchronization point | Set by: | Handling transactions |
---|---|---|
Set points in UAP by executing SQL statements | Executing COMMIT statement | Validated#1 |
Executing ROLLBACK statement | Invalidated#1, #2 | |
Set points in HiRDB by executing SQL statements | Executing definition SQL statements | Validated#1 |
Executing PURGE TABLE statement | Validated#1 | |
Processing cannot be continued while executing SQL statements | Invalidated#3 | |
Set points in HiRDB by terminating UAP | UAP normal termination | Validated |
UAP abnormal termination | Invalidated#2 |
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.