Re: 7.23 UC4 vs. 7.30 UC3

"Bernstein, Rick" <rbernste@alarismed.com> writes: > Hvae you run consistency checks with IDS 7.30.UC3? > We found that oncheck -cI will run for days using IDS 7.30.UC3-1 software. > However, a patched IDS 7.30.UC3X3 version seems to have resolved that > problem. > > We are also specifying "NO_SUBQF=1" to disable sub-query flattening. > With this release, sub-query flattening can yield incorrect results. > Informix personnel informed me that this "bug" is fixed in IDS 7.31. We are having problems with wrong passwords from setnet (I-net on PC's) causes the CPU vp to enter an infinite loop. Also some queries (probably only those with order by-clauses, but not all of them) seem to choose the wrong query path, regardless of the cost. This seems like a bug, but it is not verified by Informix yet. Lastly we have had 2 panics in oninit in 2 weeks. Nothing verified there, either. This is IDS 7.30.UC3 on HP-UX 10.20 with lots of patches. -- 'yvind Gjerstad Systems dept Tollpost-Globe AS N-6301 'ndalsnes/Norway E-mail: ogj@it.tollpost.no Phone: +47 7122 6663 Fax: +47 7122 6694