-L Parameter.

Arunselvan

Member
I have studied that -L Parameter is used to Specify the number of entries in the record locking table.

what is record locking table and what is the use of it??????
 

Cringer

ProgressTalk.com Moderator
Staff member
Do you know what a database lock is? Do you know what a transaction is? Do you know anything about transaction scoping?

There's some areas to start your research.
 

RealHeavyDude

Well-Known Member
The record locking table is the table where the database keeps track of records being locked by clients to guarantee consistency. AFAIK the muli-user default is 8192 but you can increase it when you need to. Nevertheless, before increasing it to extremely high values you should always ask yourself whether you really need to have that many records locked at the same time because usually this is an indication of bad application code. Especially in test environments I recommend to use small values to identify such badly coded programs.

Heavy Regards, RealHeavyDude.
 
Top