Fwd: Coexistance of different versions IDS
We are are planning to upgrade our informix IDS version 7.3 to IDS 10. As we have 3 computers installed with IDS 7.3, we try to do the upgrade on 3 different weekends. Some of our applications need to get data from databases on different computers. Will we have problems to retrieve data from the different IDS versions? Has anybody done this before? Regards, W.
In general the only problem you will see is if a session attached to a 7.xx server is trying to retrieve data from an IDS 10.00 instance that includes datatypes the 7.xx does not support. Art S. Kagel ----- Original Message ----- From: Dwilla <ids@iiug.org> At: 2/ 9 8:47 We are are planning to upgrade our informix IDS version 7.3 to IDS 10. As we have 3 computers installed with IDS 7.3, we try to do the upgrade on 3 different weekends. Some of our applications need to get data from databases on different computers. Will we have problems to retrieve data from the different IDS versions? Has anybody done this before? Regards, W. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
If you use synonyms between the different databases you can run into problems. At least some older IDS 7.3x versions don't support synonyms to IDS 9.x databases. If you have synonyms: Try to create synonyms between your IDS7 and new IDS9 (test) instance. If you have problems creating/using the synonyms: Try to fiind an upgrade order that you have only synonyms from IDS 9.x to IDS 7.x. Regards, Andreas Kutsche > ------------------------------------------- SPAR Oesterreichische Warenhandels-AG Hauptzentrale Europastrasse 3 A - 5015 Salzburg Tel: +43 662 4470 24223 Mobile: +43 664 6259575 E-Mail: Andreas.KUTSCHE@spar.at Internet: http://www.spar.at ------------------------------------------- -----Ursprüngliche Nachricht----- > Von: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]Im Auftrag von > ART KAGEL, .... > Gesendet: Donnerstag, 09. Februar 2006 14:55 > An: ids@iiug.org > Betreff: Re: Fwd: Coexistance of different versions IDS [6337] > > > > In general the only problem you will see is if a session > attached to a 7.xx > server is trying to retrieve data from an IDS 10.00 instance > that includes > datatypes the 7.xx does not support. > > Art S. Kagel > ----- Original Message ----- > From: Dwilla <ids@iiug.org> > At: 2/ 9 8:47 > > We are are planning to upgrade our informix IDS version 7.3 > to IDS 10. As we > have 3 computers installed with IDS 7.3, we try to do the > upgrade on 3 > different weekends. > Some of our applications need to get data from databases on different > computers. > Will we have problems to retrieve data from the different IDS > versions? Has > anybody done this before? > > Regards, > W. > > > ************************************************************** > ***************** > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ************************************************************** > ***************** > Forum Note: Use "Reply" to post a response in the discussion forum. > >
W
How are you applications obtaining the data, do any users/dbas run queries
using dbaccess/isql There is a known bug where certain queries run from
9.4 and accessing 9.4 and 7.31 run OK thru' dbaccess, but will freeze and
eventually crash the 9 engine is run thru' isql. (Just been bit !!). You
will also see many log entries on the 7 side concerning PAM errors (You can
ignore them).
As others have said test, test, test and then test again.
Keith
-----Original Message-----
From: dwilla [mailto:dwilla@gmail.com]
Sent: Thursday, February 09, 2006 1:47 PM
To: ids@iiug.org
Subject: Fwd: Coexistance of different versions IDS [6336]
We are are planning to upgrade our informix IDS version 7.3 to IDS 10. As we
have 3 computers installed with IDS 7.3, we try to do the upgrade on 3
different weekends.
Some of our applications need to get data from databases on different
computers.
Will we have problems to retrieve data from the different IDS versions? Has
anybody done this before?
Regards,
W.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
********************************************************************************
**
This message is sent in strict confidence for the addressee only. It may
contain legally privileged information. The contents are not to be disclosed
to anyone other than the addressee. Unauthorised recipients are requested
to preserve this confidentiality and to advise the sender immediately of any
error in transmission.
This footnote also confirms that this email message has been swept for the
presence of computer viruses, however we cannot guarantee that this message
is free from such problems.
********************************************************************************
**