The following connection attributes may need to be set (or considered) by DB2 CLI applications.
Generally this attribute should be set to SQL_AUTOCOMMIT_OFF, since each commit request can generate extra network flow. Only leave SQL_AUTOCOMMIT on if specifically needed.
| Note: | The default is SQL_AUTOCOMMIT_ON. |
This connection attribute determines the isolation level at which the connection or statement will operate. The isolation level determines the level of concurrency possible, and the level of locking required to execute the statement. Applications need to choose an isolation level that maximizes concurrency, yet ensures data consistency.
Refer to the SQL Reference for a complete discussion of isolation levels and their effect.