Chapter 4 Guidelines on Transaction Design

Table of Contents

General Tips on Managing Transactions

Using Short Transactions and Savepoints

Controlling Locking

Using CS, RC, and RU Isolation Levels

Using Row Level Locking

Benefits of Row Level Locking
Shared Memory Considerations
Page Locking on PUBLICROW Tables

Using KEEP CURSOR

Removing Non-Database Processing from Transactions

Using Procedures and Rules

Tuning Performance of Dynamic Statements

Using Dynamic Parameters
Using Semi-Permanent Sections

Transaction design is important for performance because it determines the type and duration of locks held by your applications. By selecting appropriate lock types, and by avoiding unnecessary locking, you can improve performance. Topics in this chapter include the following:

General Tips on Managing Transactions.
Controlling Locking.
Using Isolation Levels.
Using Row Level Locking.
Using KEEP CURSOR.
Removing Non-Database Processing.
Using Procedures and Rules.
Tuning Performance of Dynamic Statements.

Chapter 4 Guidelines on Transaction Design

Technical documentation

» Table of Contents

» Index