Re: Informix-SE 4.1 to 7.1 - any problems ?

In article <Sj07HBAaPEczEw1Q@catan.demon.co.uk>, Paul Colton (paulc@catan.demon.co.uk) writes: >We have a 3rd party application that is running against an Informix-SE >4.1 database on HP-UX 9.04. > >We have been told that, as part of an application upgrade we will be >moving to Informix-SE 7.1 on HP-UX 10.20. > >If anyone has experience of this sort of move with Informix I would be >grateful if you could let me know things like: > >- how straightforward an upgrade is it ? >- are there any problems to watch out for ? >- any other relevant advice > >Our systems people have said 'it will be transparent to the user' - >OTOH, I have always been wary of transparency and would appreciate any >helpful comments. > >TIA >Paul. > Paul, I went thru an Informix 5.1 SE to Informix ODS 7.11uc3 (??) conversion back in December 1995. I'm pretty sure, we exported the data to an ASCII file, and then inported the data back into the new database. Here are some of the problems we ran into: 1. Corrupt data in the 5.x SE database; therefore, we had to "strip" the corrupt records out using an editor. 2. The default read was DIRTY READ in the 4.x 4GL tools, but once we migrated to 6.x 4GL; the code had to be changed to include setting reads to DIRTY. If you don't, and you are doing a big query, then it takes a LOT of LOCKS and we all know that we usually do not want a LOT of LOCKS in the online configuration. It took me about a month to convince the developer that he needed to make this change, so naturally do the time it took for him to change all the code, we had LOTS of problems running out of locks in the engine and reports not being generated. 3. It takes longer than you think. Best of Luck! Call if you need some help. David Weis dweis@louisville-i-market.com Louisville Internet Marketing Service 1210 Garvin Place Louisville, KY 40203 502-637-7316 (Voice) 502-636-1553 (FAX) http://www.louisville-i-market.com thank goodness for bookmarks!!