This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
  << Previous Topic | Next Topic >>Return to Index  

AUTOMATE THE UNLOCK OBJECTS - NEED URGENT HELP

August 15 2012 at 6:14 PM
No score for this post
PVP 
from IP address 168.161.192.16

Hello,

I am admin in Company,Here My issue is, There are some people in Support Team locking the objects every day(Outline, Calc scripts etc), After Office hours, some business users( They do have APP Manager Access) are trying open Outline or Run calc script, But It's already locked by support team. Then, Business people are really fluctuating.

To avoid this, I would like to automate the script which i want to unlock all the object those are only locked by Support Team NOT by users.

Could some one please help me how to do this. I appreciated if you could response asap.

PVP.

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
AuthorReply



72.64.81.64

Re: AUTOMATE THE UNLOCK OBJECTS - NEED URGENT HELP

No score for this post
August 15 2012, 9:08 PM 

Look at Mr Hankey's suggestion here:

http://www.network54.com/Forum/58296/thread/1093298656/1093371585/Esscmd%2C+MaxL+-+unlocking+ALL+objects

Basically: Use your favorite command line interface to list the locks, then parse the output and write (and run) a script that unlocks the objects that meet your criteria.

But, why not work to prevent the locks in the first place? Should support really be opening these objects? If so, shouldn't they be unlocking them, and if not, isn't that a job performance issue?

Heidi Ho!

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
Jared

149.128.8.245

Try "Alter database unlock all objects;"

No score for this post
August 16 2012, 12:27 PM 

I guess you'd have to do it for every database.

I don't know how you'd differentiate between object locks by Support Team and objects by the users, though. It might just be a matter of telling your support team to not lock objects!

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
Current Topic - AUTOMATE THE UNLOCK OBJECTS - NEED URGENT HELP
  << Previous Topic | Next Topic >>Return to Index  

RSS feed for this forum - http://www.network54.com/Forum/58296?xml=rss. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.