• Commit, rollback, and savepoint operations
• Global transactions
• Fetching for limited rows
• Identity columns
• Sequence objects
All SQL programs execute as part of an application process, which involves the execution of one or more programs and is the unit to which DB2 allocates resources and locks. Different application processes might involve the execution of different programs or different executions of the same program. The means of initiating and terminating an application process are dependent on the environment.
More than one application process might request access to the same data at the same time. Locking is used to maintain data integrity under ...