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  

wat would be ideal set command for clear script

February 20 2012 at 12:52 PM
No score for this post
wat would be ideal set command for clear scri 
from IP address 199.89.170.91

 
ANy information will help,
our scripts for clear are taking
anywhere between 70 secs to 4 hours...
such a huge variation.

Thanks

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



96.48.5.24

Re: wat would be ideal set command for clear script

No score for this post
February 25 2012, 1:54 PM 

Use MAXL:
alter database appname.dbname reset data;

This should only take a few seconds... everytime.

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
Current Topic - wat would be ideal set command for clear script
  << Previous Topic | Next Topic >>Return to Index  
 Copyright © 1999-2014 Network54. All rights reserved.   Terms of Use   Privacy Statement  

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.