cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Lock table

Former Member
0 Likes
873

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

View Entire Topic
Former Member
0 Likes

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

Former Member
0 Likes

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

Former Member
0 Likes

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