Lock Table Entries (-L)

Use Lock Table Entries (-L) to change the limits of the record locking table.

Operating system and syntax UNIX / Windows -L n
Use with Maximum value Minimum value Single-user default Multi-user default
Database Server System dependent1 32 — 8192
n

The number of entries in the record locking table. If you specify a value that is not a multiple of 32, OpenEdge rounds the value you specify to the next highest multiple of 32.

Each record that is accessed by any user takes one entry. This is true whether the record is accessed with SHARE-LOCK or EXCLUSIVE-LOCK. Each lock table entry is 64 bytes in size.

Increase the size of the lock table if the following message appears: 

SYSTEM ERROR: Record lock table too small. Increase -L parameter.

The value of -L can be increased online with the PROUTIL INCREASETO option.

This message also might indicate that a particular procedure should be restructured into smaller transactions or should be run in single-user rather than multi-user mode. When lock table limits are exceeded, check to make sure transactions are not too large before increasing the lock table size.

If a user process tries to acquire a lock and the lock table overflows, the user's program is aborted, but the server continues to operate. Any partial transactions are undone.

Note: The two record locks are acquired when records are accessed with the BREAK BY option (in DO, FOR EACH, or REPEAT statements).
Note: The OpenEdge RDBMS provides a range of internal validations used to ensure database consistency in both index and data blocks during forward processing. Validations using PROUTIL can be run online as part of routine health checks. For more information, see Manage the OpenEdge Database.
1 Limited by available memory.