If you are unable to create a new account, please email support@bspsoftware.com

Author Topic: Automating the optimization task  (Read 4385 times)

treadltly

  • Guest
Automating the optimization task
« on: 08 Jan 2009 08:58:28 am »
We recently implemented Controller and currently have to manually run the optimization task twice per monthly cycle. I was wondering if anyone knew of a way to run the optimization task via script or a command line batch job.  Or is it something that the Oracle DBA's could do outside of the application?

Thanks in advance,

Chad

ducthcogtechie

  • Guest
Re: Automating the optimization task
« Reply #1 on: 08 Jan 2009 04:31:42 pm »
Yes, as described in page 102 of the Controller install guide (on the server).
C:\Program Files\Cognos\c8\webcontent\documentation\en\ctrl_inst.pdf

treadltly

  • Guest
Re: Automating the optimization task
« Reply #2 on: 12 Jan 2009 02:50:10 pm »

Thanks, mine wasn't on 102, but I did find it in the document.

Thanks for your help.

Chad

IBMrc

  • Guest
Re: Automating the optimization task
« Reply #3 on: 15 Oct 2013 07:05:53 am »
I realise that this topic is old, but hopefully the information below is useful to someone:)

Database server best practices are in my Technotes here:However, I suspect that you are interested in scheduling/automating an 'internal' (application) database optimise. This is not possible.