Skip to Content
avatar image
Former Member

huge number of lock entires in sm12

Users were using below transaction in DIA mode and executing reports during month End:

  1. VL01N : To create the delivery
  2. VL02N: Change Delivery
  3. VT02N for PGI

we found performance issue due to:

->Huge number of lock entries (around 5K to 6K) found in SM12 ( by same user )

-> All DIA/BGD work processes are occupied in few Application servers

->Found few long running jobs, without any progress.

So Please help us to understand, how a single user can make 5000 to 6000 lock entries in production system.

And also, please guide us to prevent this in future.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Apr 13, 2017 at 06:15 PM

    The quickest and best solution is usually to take the phone and call this user and ask him politely what he just did, how he uses his transaction. You can also explain to him what issues you have, the users usually understand, at least it was so when I was faced with this issue some years ago. Beside of educating the users about a better selection there is also a way to restrict the number of hits in case of insufficient selections

    See the OSS notes 604473 and 36248, the coding changes are probably already in your system, but you have to set the variable to make it active

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 13, 2017 at 05:53 PM

    Hi,

    It could be a system hung situation. Look for long running process by this Id in SM66.

    Kill the session if it is not active (Kill if it is just a hung session and doing nothing), Once it is cleared then all WPs will come back into normal mode.

    Do additional analysis before you kill/cancel any session, look at the jobs too if it is because of any job then ask user if you can cancel it. If locks are getting generated because of space issue in tablespace then extend the tablespace. Check the status of update processes too.

    Regards,

    Harish Karra

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 21, 2017 at 05:07 PM

    Executing a selection in VT01N without entering selection criteria or insufficient criteria will lock all selected deliveries. Was this not clear from the mentioned OSS notes?

    Add comment
    10|10000 characters needed characters exceeded