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 create RFC CONNECTION between production server and Global trade system. what prerequsite we need for this.

3167


what is the common storage file for oracle ?

1640


What is an ‘ok’ code? What are the differences an ‘ok’ code to a ‘t-code’?

623


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

568


What is MySAP?

667






Do? If another user wants to share that lock but the user using that

1278


When should we use Transactional RFC?

641


Mention what is the purpose of table usr02?

635


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

1926


How to lock or unlock a transaction code using sm01?

1596


In my portal ABAP + JAVA I get a bootstrap error message how do I resolve this erroe

4297


How to transport objects from Production to Development?

1671


What are the different types of job status? Can you unschedule an active job?

656


hi friends, in sap screen with 000 client i unable to logon,with 001 client i can login but i want to log on with 000 client how i can loggin with 000 client intial screen ,please can u help me

6059


How to analysis abap dumps?

683