HI ,
As an SAP BASIS member , Why do we need to monitor lock
entries(SM12) and Update Errors(SM13) , wht is the trouble
shooting for those ?

Answer Posted / srikanth

We need to monitor atleast once in a day whether we have
many exclusive locks. There are different types of locks
which can be put on tables. If it is an exclusive lock then
that particular user who put the lock on the table only
willl be able to access it. If at the sametime someother
user or someother background job which tries to access the
sam table to hold out and those transactions will be struck
until the table is released. Well if thee are many locks on
many tables the transactions in SAP will be awaiting and
they are not processed further and it may effect the
business seriously. If there are many locks see who locked
it. Then go for Tcode "al08" and see whether the user is
active. If he is not then try to comminicate with him and
delete the lock. If he is not and lock is continued from a
long time and affecting the business then delete the lock
after the confirmation from the user.

Is This Answer Correct ?    30 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you view locked transactions?

630


When we are doing cash sales, free goods and discount, How many pricing procedure do we need to create..? Only one PP required or have to create multiple PP..? and how many condition type we need to create..?

883


How would you troubleshoot the 'system seems slow'?

653


How to uncar car/sar files in a single shot?

793


I would like to know the version or name of SAP that is implemented in real time?

674






Which transaction do you use to check buffer statistics ?

708


i'm new for security, pls help if assign the t-code to parent it wll effect to child role or not. can we assign to t-code directly to child role? it wll work or not?

3775


What is the purpose of webdisptcher and Installing and configuring Web Dispatcher what are the prerequisites?

1991


If brtools is not working how you will add datafile?

2056


Explain segment?

695


what post steps and pre steps db refresh

2692


what is sox and sod in sap ?

1303


Explain kernel upgrade?

623


How do you create an instance?

623


What are the different types of rfc and explain what transactional rfc is?

586