Previous Topic: Beginning and Ending an SQL SessionNext Topic: Managing Nonshareable Transactions


Database Transactions

A database transaction is a unit of recovery representing work done by one or more database sessions. All access to CA IDMS data from within an SQL session is done under the control of a database transaction.

Transactions can be associated with one or more database sessions. A transaction can be associated with more than one session only if a session is eligible to share its transaction with other sessions. Transactions started by sessions that are not eligible to share their transaction are called nonshareable transactions.