DEF_TABLE_LOCKMODE

onconfig.std value

PAGE

if not present

PAGE

range of values

PAGE = sets lock mode to page for new tables
ROW = sets lock mode to row for new tables

takes effect

When the database server is shut down and restarted

environment variable

IFX_DEF_TABLE_LOCKMODE

refer to

The following material:

• Environment variables in the IBM Informix Guide to SQL: Reference
• Setting lock modes, in the IBM Informix Guide to SQL: Tutorial
• Configuring lock mode, in the IBM Informix Performance Guide

If DEF_TABLE_LOCKMODE = ROW, it sets the lock mode to row for every newly created table for all sessions that are connected to logging or nonlogging databases. This parameter has no effect on the lock mode for existing tables.

The rules of precedence for setting the lock mode are as follows.

Precedence

Command

1 (highest)

CREATE TABLE or ALTER TABLE statement that use the LOCK MODE clause

2

IFX_DEF_TABLE_LOCKMODE environment variable set on the client side

3

IFX_DEF_TABLE_LOCKMODE environment variable set on the server side

4

DEF_TABLE_LOCKMODE value in ONCONFIG file

5 (lowest)

Default behavior (page-level locking)