Skip to Content
avatar image
Former Member

Lock Entries in SM12

Hi Experts,

Why does the Lock Entries occur?

Whats the reason behind it?

Please put a light on it.

Thanks in Advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Dec 23, 2014 at 06:25 AM

    Hi Rajesh,

    Please check below concepts related to lock mechanism.

    Lock Mechanism:

    When two process are searching the same source then you may have locking problem. 

    Then you will get the error message 'currently locked by the user', then you can go to the tcode SM12,

    on tool bar your having

    lock entry ---> list all ---> delete, then your locks can be removed.

    About Tcode SM12:

    Managing lock entries lets you monitor your system with regards to lock logic.

    You can determine which locks are being used currently. Locks that have had the backup flag set are highlighted in color.

    You can detect and correct problems by deleting locks that you no longer want. You can also later analyze the cause of lock table overflows using the History.

     

    Mode:

    You can see which type the lock object is

    (S: shared lock, E: exclusive lock, X: exclusive and not cumulative, O: optimistic lock).

    The various lock modes are described in section Functions of the SAP Lock Concept.

     

    Table:

    The Table column contains the tables in which rows are locked.

     

    Lock argument:

    The Lock argument column, you can see the argument (key field) of the lock entry. 

    This corresponds to the entries in the lock table.

     

    The lock entries are shown in different colors:

    Blue means that the locks have already been transferred to the update task (see also The Owner Concept), with the result that the backup flag is set. These locks are also rewritten to the lock table when the enqueue server is restarted.

    Black means that the lock (still) belongs to the dialog owner. The backup flag is not set.

    By choosing Edit -> Sort by, you can display the locks according to user, time, table, or host system (host).

    By double clicking a lock entry, you can display detailed information, including the host name and number of the SAP System in which the lock was generated.  

    Enque Mechanism:

    Enque mechanism will take care of clearing lock entries once the work processes requests get completed.

    we have to delete long runing lock entries if you find any performance issues in system.

    that tooo you have to check corresponding Update entries in SM13 before deleting lock entries.

    Points to remember beforw using Tcode SM12:

    You should never delete a lock when you are unsure and/or don't know what is this lock for.

    You may generate an inconsistence.

    Locks are put on table and / or table entries when a process needs exclusive access to this DB table and/or record.

    Removing this lock could let for example another process to change the same data while the process is still running

    thus generating inconsistence.

    Always try to match a lock with a process in SM66, a background Job in SM37,

    a DB session, in ST04 / detailed analysis / sessions or a user logged in with AL08/SM04.

    If you have identified from where does the lock come, then first try to kill the job,

    then the related process, then kick the user out (best would be to ask him what is he doing)

    and finally the DB session.  Usually one of this action will remove the lock cleanly.

    If it is not the case, deleting a lock in SM12 would be the very last option.

    you can go through below link as well for more information:

    SM12 - Lock Concept - Basis Corner - SCN Wiki

    Different methods to Lock or unlock SAP users

    Hope this will help you.

    Regards,

    Sneha

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 22, 2016 at 11:53 AM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded