Kbase P106110: Error 915 on a batch job, how to increase -L
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
SYMPTOM(s):
mbpro <db> -L <max_value> -p <program>
_progres <db> -b -L <max_value> -p <program>
prowin32 <db> -b -L <max_value> -p <program>
batch job running on the server
Lock table overflow, increase -L on server (915)
CAUSE:
-L is not a Client parameter but a Database Server parameter
FIX:
1. Check the current value of -L for the Database Server running
For example: grep "(4241)" yourdb.lg
11:05:55 BROKER 0: Current Size of Lock Table (-L): 8192. (4241)
2. Stop the Database Server
For example: proshut yourdb -by
3. Restart the Database Server
For example: proserve yourdb -L 10000
4. Rerun the batch job
For example: mbpro yourdb -p program1.r