ERROR on optimizedb

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nionio_usa - 02 May 2007 10:58 GMT

Hi All,
When running the optimizedb, I'm having the foloowing error!
Any help will be welcome!

Thanks in advance.

optimizedb -ustkex -zk stkex -rp253sat
E_OP0018 optimizer timeout abort
- query optimization/execution aborted
(Wed May 2 11:57:17 2007)

Reply to this Message

nionio_usa - 02 May 2007 14:41 GMT

> Hi All,
> When running the optimizedb, I'm having the foloowing error!
[quoted text clipped - 6 lines]
> - query optimization/execution aborted
> (Wed May 2 11:57:17 2007)

Even tried command in different order and have the same result.

Reply to this Message

martin.bowes@ctsu.ox.ac.uk - 02 May 2007 15:01 GMT

> Even tried command in different order and have the same result.

I presume that was: optimizedb -zk -ustkex stkex -rp253sat

Do you have any value set for opf_timeout_abort in your config.dat?

Martin Bowes

> _______________________________________________
> Info-Ingres mailing list
> Info-Ingres@kettleriverconsulting.com
> http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres

Reply to this Message