Lawrence Smith wrote: > We have an installation of maxdb running on solaris. We want > to schedule > a cron job that will update the statistics for all databases and all > tables periodically. I am not so much concerned about the specifics of > the cron job needed. However I am not sure of the command to > run. After > trying to find the answer in the documentation I found that I need to > run: exec_xpu <xpu_params> > > Where is this program? What are the options to this program since it > doesn't give them in the docs? How often should it be run? > > I would appreciate if any one could give me a sample ksh/csh/etc.. > script that will log on, execute the optimizer for all databases then > log off. I can then write the cron entry to run this script say every > hour. > > Thanks in advance, Laurence > This Message has been Checked at MSXI for all known Viruses. > You open this at your own risk. Please make sure all replies are > also virus free. > Also we do not accept or send Attachments of the type .exe, .vbs, > scr, or .bat due to the virus risk they can contain. These types of > attachments will be stripped from the message.
You could also use sql_execute within dbmcli to do this. Example: dbmcli -d <dbname> -u <dbmusr,dbmpwd> sql_execute -uSQL <dbausr,dbapwd> "update stat * estimates smaple 10 percent" Kind regards, Holger -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
