Chapter 12. Application Program Features

• 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.

Commit, Rollback, and Savepoint Operations

More than one application process might request access to the same data at the same time. Locking is used to maintain data integrity under ...

Get DB2® for z/OS® Version 8 DBA Certification Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.