When short transactions are in effect, the DB2 access service is responsible for controlling the commitment of requests. After sending the request to the database, the DB2 access service automatically issues one of the following:
A commit, if the request succeeds
A rollback, if the request fails
While in short transaction mode, the request is a unit of work.
A begin transaction phrase can affect the behavior of a short transaction. If it receives a begin transaction phrase, the DB2 access service:
Triggers a commit of all previous statements in the request.
Temporarily sets TransactionMode to long, although a select @@TransactionMode command returns an answer of short mode. While in temporary long mode, if the batch processes successfully, the SQL statements are committed.
Stays in temporary long transaction mode until a unit of work is completed with a commit or rollback. Then, the DB2 access service reverts TransactionMode to short.
Do not change configuration properties while the request
is in temporary long mode. Once a commit or rollback occurs,
the temporary long mode reverts to short mode.
Copyright © 2005. Sybase Inc. All rights reserved. |
![]() |