O'Reilly logo

DB2® for z/OS® Version 8 DBA Certification Guide by Susan Lawson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required