SQL Programming Techniques › Managing Concurrent Sessions

Managing Concurrent Sessions

The ability to maintain concurrent active sessions allows the program to access multiple databases with parallel database transactions. For example, one session can retrieve data from one database and, using that data, perform an update operation on another database.

Caution When Transaction Sharing Is Not in Effect

If an application attempts to access the same database in concurrent sessions, there is an inherent risk of deadlock; however, transaction sharing can be used to avoid such deadlocks.

Note: For more information about the use of transaction sharing, see Writing an SQL Program and the CA IDMS Database Administration Guide.