Precedence and Default Behavior

In HCL OneDB™, you do not need to specify the lock mode each time you create a new table. You can globally set the locking granularity of all new tables in the following environments:
  • Database session of an individual user

    You can set the IFX_DEF_TABLE_LOCKMODE environment variable to specify the lock mode of new tables during your current session.

  • Database server (all sessions on the database server)

    If you are a DBA, you can set the DEF_TABLE_LOCKMODE configuration parameter in the ONCONFIG file to determine the lock mode of all new tables in the database server.

    If you are not a DBA, you can set the IFX_DEF_TABLE_LOCKMODE environment variable for the database server, before you run oninit, to specify the lock mode of all new tables of the database server.

The LOCK MODE setting in a CREATE TABLE statement takes precedence over the settings of the IFX_DEF_TABLE_LOCKMODE environment variable and the DEF_TABLE_LOCKMODE configuration parameter.

If CREATE TABLE specifies no lock mode setting, the default mode depends on the setting of the IFX_DEF_TABLE_LOCKMODE environment variable or the DEF_TABLE_LOCKMODE configuration parameter. For information about IFX_DEF_TABLE_LOCKMODE, refer to the HCL OneDB Guide to SQL: Reference. For information about the DEF_TABLE_LOCKMODE configuration parameter, refer to the HCL OneDB Administrator's Reference.