Call Level Interface Guide and Reference

Setting Common Connection Attributes

The following connection attributes may need to be set (or considered) by DB2 CLI applications.

• SQL_ATTR_AUTOCOMMIT
• SQL_ATTR_TXN_ISOLATION

SQL_ATTR_AUTOCOMMIT

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.

SQL_ATTR_TXN_ISOLATION

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.