Number of statements (transaction type)

Select the type of transactions in your database. Note that long transactions tend to consume more resources for a longer period of time than do short transactions.

More than 10 (long transactions)

Each transaction has 10 or more SQL statements in a single unit of work.

Fewer than 10 (short transactions)

Each transaction has 1 to 9 SQL statements in a single unit of work.

Default Value

long transactions

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]