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
How can you view locked transactions?
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..?
How would you troubleshoot the 'system seems slow'?
How to uncar car/sar files in a single shot?
I would like to know the version or name of SAP that is implemented in real time?
Which transaction do you use to check buffer statistics ?
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?
What is the purpose of webdisptcher and Installing and configuring Web Dispatcher what are the prerequisites?
If brtools is not working how you will add datafile?
Explain segment?
what post steps and pre steps db refresh
what is sox and sod in sap ?
Explain kernel upgrade?
How do you create an instance?
What are the different types of rfc and explain what transactional rfc is?