Re: Upgrade gotchas?

I found a problem quite similar on HP-UX with ISQL (it didn't work when installed in the same INFORMIXDIR than the server - support told us it was a bug and our customer didn't want it installed at last), and another one on Linux (message files didn't install if 4GL was installed first - must install IDS in another directory and must copy the files to the final place). Most time I truly believe IBM is enhancing the products. But sometimes I wonder if they try the products. Or at least the intall process. Everett Mills wrote: > Malc- > I see that you're planning to install the 7.32 version of the > tools. You need to be aware that all of the tools IBM uploaded to their > PPA site on July 13th are suspect at best. All of the tools are > mislabeled, and some of the tar files (4GL runtime 7.32.FC3, 4GL > development and runtime 7.32.HC3) are unreadable after you figure out > which ones you need and download them. IBM is aware of the problem and > the PPA guys and the development guys are pointing fingers at each > other, but (as of this morning) the problem remains. It may be useful > if you were to download some of the products, verify that they are not > usable, call tech support and apply a bit more pressure to get the PPA > website straightened out. > The 7.32.xC2 version of ISQL for HPUX has an issue with file > locations. If you type the name of the SQl or form you want to run, it > will tell you it doesn't exist. You can still navigate to it. This is > supposed to be fixed in 7.32.xc3, which is why I've been trying to > download that version of the tools. > Something else we noticed, is that due to a change in the > optimizer, if your 4GL program builds a table or temporary table and > fills it, the program must execute UPDATE STATISTICS for that table > before it will use any indexes you create on it. We only had to change > a couple of programs, but it was a pain to figure out what was wrong. > Otherwise we have found the 7.32.xc2 version of 4GL to be better than > 7.31 and you also get a few added commands and functions. > > > --EEM > > > > >>-----Original Message----- >>From: malc_p@btinternet.com [mailto:malc_p@btinternet.com] >>Sent: Monday, August 08, 2005 8:34 AM >>To: informix-list@iiug.org >>Subject: Upgrade gotchas? >> >>Request for info / experiences please... >>We're on HP-UX 11i and have tools (4gl (rds, idb & i4gl) and sql) at >>7.20, engine at 9.30. We're running a medium sized (200Gb) OLTP >>database and about 1,000 executable 4ge's, plus a bit of java in the >>engine. >> >>We've taken a deep breath and are going to move to tools V7.32, engine >>V10, the 'H' versions, not the 'F'. >>Best advice so far is to do tools first (to ensure the most recent >>libraries are in place) and then engine. We reckon on a month to do a >>proof-of-concept test of the tools on a development box followed by a >>month of user testing on the same machine, then a live install, and >>then the same process with the engine. >> >>I know when we tried to go to 7.30 (and also 7.31) tools we came > > across > >>a couple of problems so backed out (4gl screen handling and reports >>issues). >> >>Does anyone here have experience of a similar set of upgrades, know >>anything that's going to bite our arses, got some heads-ups etc etc > > etc > >>etc? >> >>Any and all info gratefully received, no matter how trivial you think >>it may be I'd love to hear from you. >> >>Many thanks >> >>Malc >> >>PS I can be contacted directly at malcolm <dot> perrior <at> cap1ta >><dot> co <dot> uk - replace the '1' with an 'i' > > > > sending to informix-list > -- Jos' Luis Matute Mart'nez Responsable Divisi'n Sistemas Contacto Local del Grupo de Usuarios de Informix en Espa'a D&D Grupo Dydes Poligono EUROPOLIS Edif. Al Andalus Calle X, n' 4 y 6 28230 Las Rozas (Madrid) Tf: +34 91 6407080 Fax: +34 91 6373280 sending to informix-list