Automating the optimization task

[treadltly]

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]

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]

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

Thanks for your help.

Chad

[IBMrc]

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:

   
• SQL 2005/2008: http://www-01.ibm.com/support/docview.wss?uid=swg21396973
• Oracle: http://www-01.ibm.com/support/docview.wss?uid=swg21346962

However, I suspect that you are interested in scheduling/automating an 'internal' (application) database optimise. This is not possible.

   
• Instead, please read my Technote here to read what the internal database optimise does: http://www-01.ibm.com/support/docview.wss?uid=swg21367485