Enterprise Edition Home | Express Edition Home | Previous Page | Next Page   Locking >

Configuring Lock Mode

When you create a table, the default lock mode is page. If you have many users accessing the same tables, you can increase concurrency by using a smaller locking granularity. If you know that most of your applications might benefit from a lock mode of row, you can take one of the following actions:

If you change the lock mode with the IFX_DEF_TABLE_LOCKMODE environment variable or DEF_TABLE_LOCKMODE configuration parameter, the lock mode of existing tables are not affected. Existing tables continue to use the lock mode with which they were defined at the time they were created.

In addition, if you previously changed the lock mode of a table to ROW, and subsequently execute an ALTER TABLE statement to alter some other characteristic of the table (such as add a column or change the extent size), you do not need to specify the lock mode. The lock mode remains at ROW and is not set to the default PAGE mode.

You can still override the lock mode of individual tables by specifying the LOCK MODE clause in the CREATE TABLE statement or ALTER TABLE statement. The following list shows the order of precedence for the lock mode on a table:

Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]