
IDS 7.31 -> IDS.2000 9.21 upgrade
CAUTION CAUTION CAUTION CAUTION CAUTION CAUTION
If you use stored procedures in your IDS application, you can have VERY
SEVERE problems upon conversion to 9.21.
If your stored procedures use the TRIM function, the converted stored
procedures will BECOME UNUSABLE AND WILL CRASH THE DATBASE SERVER.
Informix is aware of this problem, and are working very hard to resolve the
bug.
However, for the time, if you use stored procedures, drop them prior to
upgrade, and recreate them after your upgrade process is complete.
CAUTION CAUTION CAUTION CAUTION CAUTION CAUTION
If you have a very large database schema (mine was > 2GB with 1100+ stored
procedures), dbaccess may have problems in attempting to run the full
database schema into a new database. In my circumstance, I was using the
shared memory connection, and dbschema core-dumped.
2 workarounds have been suggested by Informix:
1 - set the environment variable INFORMIXSHMBASE
2 - use the TCP/IP connection
---------------------------------------------------------
After encountering these problems, we have made the decision to revert to
7.31 and not proceed with IDS.2000 at this time.
The final nail in the coffin was this: one of Informix's technical support
people has said that this release is as problematic as 7.11.UC1.