on 06-13-2010 4:06 PM
Hello Experts,
Need one help regarding the history of lock entries.
We have a requirement from the customer to provide the details like which all objects are locked by which all resources and the time stamp info also if possible.
Believe that this information will be stored in some of the tables.
Kindly let me know if somebody can provide any info regarding this.
Thanks & Regads,
Abin
Hello
Transaction ST04 could help you to see the Blocking Lock Hisory.
All the Best
Miguel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
SAP enque mechanism uses a shared memory rather than a database table for holding lock details. This details are flushed during a restart. Enque uses work process traces for minor logging details and hence a centralized complete history of enque logging is not possible. However you can obtain the following information :
A) SM12 choose the menu option Extras > Top Capacity Used> Current ,History
Last 10 lock table overflows is saved:
· The three lock owners with the most locks
· The three lock arguments with the most locks
B) You may activate enque logging as mentioned in SAP Note 125041 - Analysis of enqueue errors with enqueue logging .
NOTE: Logging should be performed only for short periods *
SAP Standalone enque servers logs much more details nevertheless even then a complete history of lock entries is not possible.
For a complete understanding of SAP Lock management and logging you may refer to the following:
-
-
http://help.sap.com/saphelp_nw70/helpdata/en/d3/43d2416d9c1c7be10000000a1550b0/frameset.htm
SAP Note 5424 - Questions and answers on enqueue/locking
SAP Note 658495 - Improved options with enqueue logging
-
-
cheers !
PRADi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.