TextSize  Version

Chapter 2: Creating and Configuring DB2 Access Services

TransactionMode

Specifies whether the DB2 access service or the client application manages commits and rollbacks.

Syntax

TransactionMode=[short | long]

Default

short

Values

long specifies the DB2 access service to give commitment control to the client application. The DB2 access service holds open the connection to the target database until the client application issues a commit or rollback or until the ClientIdleTimeout value (see “ClientIdleTimeout”) is exceeded. If ClientIdleTimeout is exceeded, the transaction rolls back.

short indicates that the DB2 access service issues a commit or a rollback after each request.





Copyright © 2005. Sybase Inc. All rights reserved. Version

View this book as PDF