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 to find users used transaction codes which are not authorized for?

1903


What are the errors you got while applying support pack?

1389


What is your UNIX experience and the types of UNIX systems you have worked on.

1597


What is password policy?

794


In a situation where my sap system is down (users unable to login to sap system), how to analyze the problem?

905






Difference between system refresh and client copy?

2345


Briefly explain a recent problem you faced, which u felt proud by solving that? And how will u solved?

1952


Explain the system trace?

642


what is the use of tcode SUSHARE in SAP and how the mass user authorizations compared?

2010


the difference between part number and serial number

2543


Have u applied patches what is the transaction code?

645


What is transport layer and domain controller? In which system you have create domain control?

1407


what are the pros and cons of auto extend of table spaces?

1730


I want to let sap skip printing cover pages during printing for any kind of report. How can this be done?

715


What are the daily transactions?

654