IDS 7.31 -> IDS.2000 9.21 upgrade 
Author Message
 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.



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. IDS.2000 9.21 + IConnect + ISQL 7.31

2. IDS 9.21 to IDS 9.3 upgrade

3. Performance Degradation IDS 7.31 to 9.21

4. Migration between IDS 7.23 and IDS 2000 9.21

5. Migration between IDS 7.23 and IDS 2000 9.21

6. Restoring IDS 7.31 on IDS 2000

7. Upgrade 7.31 TC5 ==> 9.21 Tc 3

8. IDS 2000 vrs IDS 7.31

9. IDS.2000 and IDS 7.31 on one unix box

10. Upgrade IDS 7.31/Sol 2.6 --> IDS 9.21/Sol 2.8?

11. Upgrade 7.31 to 9.21

12. Problems with upgrade from 7.31 to 9.21


 
Powered by phpBB® Forum Software