on ‎2011 Apr 07 3:47 PM
My archival jobs continuously fails because of Lock table overflow even after increasing parameter enque/table_size and then bounced.
But in SM12 No lock entries found
Under SM12 EXTRAS -> STATISTICS OR DIAGONOSTIICS are inactive
Job logs as below...
Job started
Step 001 started (program ZRJJARC20, variant CLL4, user ID MINIO)
Archiving session 000078 is being created
Lock table overflow
Job cancelled after system exception ERROR_MESSAGE
Regards,
Peter
Request clarification before answering.
Hi,
I think you are trying this option in SM12 after displaying the list of lock entries and because of that these options are grayed out.
Please go to SM12 and don't click on List. And then try these options, then these options will be visible and you can select that as well.
Thanks
Sunny
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
But i want to know why job fails even after clear lock entries in SM12.
Below find statics of locks
Enqueue Operations 42726
rejected 47
Error occured 1
Dequeue Operations 4349
Error occured 0
Dequeue All Operations 3735
Cleanup Operations 0
Backup Operations 2
Read Operations 5
Compress Operations 0
Verify Operations 0
Records written 29182
to the backup file 4
Maximum Number of Lock Owners 25311
Maximum Fill level 8
Current Fill Level 6
Maximum Number of Lock Arguments 25311
Maximum Fill level 25310
Current Fill Level 6
Maximum Number of Lock Entries 25311
Maximum Fill level 25310
Current Fill Level 6
Update; Fill Level at Maximum 1
Current Fill Level 0
Time in Lock Table /Seconds 2.876618s
Wait for Lock Table /Seconds 0.736393s
Time in Lock Server /Seconds 0.000000s
But i want to know why job fails even after clear lock entries in SM12.
Below find statics of locks
Enqueue Operations 42726
rejected 47
Error occured 1
Dequeue Operations 4349
Error occured 0
Dequeue All Operations 3735
Cleanup Operations 0
Backup Operations 2
Read Operations 5
Compress Operations 0
Verify Operations 0
Records written 29182
to the backup file 4
Maximum Number of Lock Owners 25311
Maximum Fill level 8
Current Fill Level 6
Maximum Number of Lock Arguments 25311
Maximum Fill level 25310
Current Fill Level 6
Maximum Number of Lock Entries 25311
Maximum Fill level 25310
Current Fill Level 6
Update; Fill Level at Maximum 1
Current Fill Level 0
Time in Lock Table /Seconds 2.876618s
Wait for Lock Table /Seconds 0.736393s
Time in Lock Server /Seconds 0.000000s
| User | Count |
|---|---|
| 7 | |
| 5 | |
| 5 | |
| 4 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.