Progress
Startup Command and Parameter
Reference


Lock Table Entries (-L)

Operating 
System
and
Syntax 
UNIX
Windows 
-L n 
Use
With 
Maximum
Value 
Minimum
Value 
Single-user
Default 
Multi-user
Default 
DBS
System dependent1
32
 
8192
  1. Limited by available memory.

n

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

Use Lock Table Entries (-L) to change the limits of the record locking table. 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. Increase the size of the lock table if the following message appears:

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

This message might also 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 that two record locks are acquired when records are accessed with the BREAK BY option (in DO, FOR EACH, or REPEAT statements).

Each lock table entry takes 18 bytes on typical systems, but 14 bytes on nonshared-memory systems.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095