on 02-08-2007 5:21 PM
Dear Friends,
What does Live Cache Lock mean? How do we use this and what is it for? How to manage in APO? Can anyone let me know answers pls. Thanks in advance.
Regards
Bala
Hi Bala,
When you create, change and delete orders, rows in relational tables are changed or deleted in the liveCache. The corresponding records stay locked until the end of the transaction. The maximum number of locks on relational records is determined with parameter MAXLOCKS.
If a transaction requires more than 10% of the lock list for locks onto a table, all the multiple row locks are converted into a single table lock (this is called an 'escalation'). If several transactions escalate at the same time, wait situations occur since only one transaction can set the table lock.
There is no 'management' of locks required in APO. If you are seeing many lock escalations in liveCache, an increase in the MAXLOCKS parameter might be necessary.
Thanks,
Ashwath
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ashwath,
Thanks for your reply and it is very helpful to me. Meanwhile, how do I set the Maxlock i.e, whats the transaction for this?
Regards
Bala
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.