on 09-13-2011 11:37 AM
hi experts,
When I check locked entries in sm12, i found some locked entries which are already past 8 hours and sometimes more. Do those entries contribute to the system's slow performance? When should I delete those entries? I hesitate to delete locked entries and kick users out of the system because they maybe editting some documents and have'nt saved them yet.
Thank you in advance for your response.
Its an automatic mechanism managed internally, Do not delete the lock entries manually.
If you really want to kick off the users from the system, there are some other alternatives like SM04 etc.
Regards,
Nick Loy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks all for your response. I'll check other probable cause of the system's slow performance.
Thank you
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In general Locks doesn't have any impact on performance of the system.
Also don't try to delete the locks manually .we can allow locks for 24 Hrs..if you find any lock older that 24 Hours ..get in touch with the lock owner immediately and try to logoff the user from system through SM04/AL08..
Still if lock is present evenafter logging of the lock owner ,you can delete the lock with approval from Owner.
Regards,
Srinivas Chapa.
Edited by: Srinivasa Rao Chapa on Sep 13, 2011 8:27 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
System Lock mechanism doesn't slow down system. But sometime it's required to delete the entries of hanged uses login processes, which can be done through SM04/AL08 as described by GURUS.
But sometime though you try to delete from these T-Code the process doesn't get delted, then you can proceed for the below mnetioned two steps:
1. SM50 and delete the corresponding process through PROCESS > CANCEL WITHOUT CORE
PROCESS > RESTART AFTER ERROR -> NO
2. If you have access to OS level, then the same can be deleted by following command:
kill -9 <process no.>
In case any issue, please feel free to revert.
Reagrds,
Nilutpal
Do those entries contribute to the system's slow performance?
No, they should not cause any performance problems.
When should I delete those entries?
Deletion of the DB lock should only be done when theres proven certainty that the lock still exist after a particular user activity or transaction have been completed and the lock was not removed for whatever reason. In anycase all other alternatives like closing the user session should be attempted first.
I hesitate to delete locked entries and kick users out of the system because they maybe editting some documents and have'nt saved them yet.
That's a fair assumption.
Regards
Juan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.