09-21-2004 10:44 PM
buffer spec in dbutil.pub.sys concerning about the database.
Currently in one of my database I have a setting like: Buffer specifications: 70(1/120)
and I have about 100 users on board. The impact currently that encounter is process deadlock.
Could anyone kindly advise me . Thank you.
09-21-2004 10:59 PM
ps, is the deadlock an image deadlock or a process deadlock?
09-21-2004 11:22 PM
10-26-2004 05:24 AM
The note: KBAN00000399 has details. Basically
This can be used to increase the total number of locks that can be held
for the given database.
But increasing the value will increase the size of the DBG & hence of SR6/7 usage, so should not be done lightly. Look at the application design to see if the number of locks issued can be decreased. Each increase in "level" will increase the lockarea size by 16,384 16 bit words. LOCKSIZELEVEL 1 will give a lockarea size of 49,152 16 bit
words and each increase in LOCKSIZELEVEL will add 16,384 16 bit words to the lockarea.
As a rule, each LOCKSIZELEVEL will allow 100 DBOPENs with 300 predicate locks each. When running out of lockarea, you may see the following errors.
DBG Control Block Full -- Condition 62 returned by DBLOCK
DBG Control Block Full -- Condition -197 returned by DBOPEN
Locksizelevel replaces the option BUFFSPECS. See the TurboImage manual
appendix H for a description of this option.