Saturday, June 11, 2005

Informix Update

I spent the better part of Thursday and Friday, and a bit of today, working on testing the "latest" Informix 7.31.UD8 (an upgrade for a customer's 7.31.UC7 system). I was told I could just drop it in, but thought I'd double-check (been burned before by that one).

With the exception of one configuration file change (shared memory location, SHMBASE), the upgrade went on without a hitch. Was able to test backup (ontape), restore (ontape), dropping / loading tables and data, database validation (oncheck -cDI), and the dropping / recreation of table distribution (onStats script from Art Kagel, downloadable at IIUG). Flawless.

Transferred the binaries to the client side location, double-checked my commands, and brought down the production system, upgraded, and back up it went. Flawless. Even the reports (4GL statically compiled) work fine.

It will be very interesting to see how the Informix development (and community) continue to work with IBM as IBM wrestles with Informix, DB2, and Cloudscape (now open sourced to Derby). I have a feeling that DB2 and Informix will be merged over the next few years, but that's just conjecture.

1 Comments:

At 8:37 AM, betoreyez said...

I understand that this version 7.31.UD8 is free of charge, right? I'd like to make some tests with it, do you have the installer?

Thanks in advance

 

Post a Comment

<< Home