RE: Upgrade gotchas?

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