Oninit cdi / Archive
Talk to an expert →

Re: 9.40 behavioural differences

Posted in 2004

Topics: Performance & Tuning, Installation, Setup & Upgrades, Versions, Editions & End-of-Life

Jonathan Leffler — — source: Usenet: comp.databases.informix

Doug Lawry wrote: > A client wants to know if there are any backwardly-incompatible behavioural > differences (not installation problems) in IDS 9.40 compared to 9.30 on HP. > Has anyone encountered any? The fixed bugs don't work the same way they used to. There's always a chance that some change in the optimizer makes some of your optimizer directives into bad news. I'm not aware of any, but that's a risk of using optimizer directives. What's worse, the only symptom will be that the query takes longer than it could - which may not be obvious if the directives produce an answer sufficiently quickly. Some parts of the UC3 and later releases are fussier about permissions than they used to be. If you run a lax system, you might find problems. If you don't play with the permissions set by the install, you should be OK. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/

↪ replying to Jonathan Leffler
Doug Lawry — — source: Usenet: comp.databases.informix

Thanks, Jonathon. Checking the list of fixed bugs is a good tip. This system doesn't make much use of optimizer directives, so that shouldn't be a problem, and I'm sure we will leave file permissions well alone! Cheers, Doug "Jonathan Leffler" <jleffler@earthlink.net> wrote: > Doug Lawry wrote: > > > A client wants to know if there are any backwardly-incompatible behavioural > > differences (not installation problems) in IDS 9.40 compared to 9.30 on HP. > > Has anyone encountered any? > > The fixed bugs don't work the same way they used to. > > There's always a chance that some change in the optimizer makes some > of your optimizer directives into bad news. I'm not aware of any, but > that's a risk of using optimizer directives. What's worse, the only > symptom will be that the query takes longer than it could - which may > not be obvious if the directives produce an answer sufficiently quickly. > > Some parts of the UC3 and later releases are fussier about permissions > than they used to be. If you run a lax system, you might find > problems. If you don't play with the permissions set by the install, > you should be OK. > > -- > Jonathan Leffler #include <disclaimer.h> > Email: jleffler@earthlink.net, jleffler@us.ibm.com > Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/

Glossary