Lock size

This box contains the size (granularity) of locks used when the table is accessed. To change the lock size, click on the down arrow to display the list and select one.

The lock size can be one of:

ROW

Indicates the use of row locks. This is the default lock size when the table is created.

TABLE

Indicates the use of table locks. With table locks, the appropriate share, update, or exclusive lock is acquired and intent locks (except intent none) are not used.

Table locks may improve the performance of some queries by limiting the number of locks to be acquired, however, concurrency is also reduced because all locks are held over the complete table.

Use of the Lock size control will not prevent normal lock escalation from occurring.

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

[ DB2 List of Books | Search the DB2 Books ]