Advantages/Disadvantages of Upgrading a 9.21 32-Bi
I seem to recall going through a 32-bit to 64-bit upgrade in my past 18 years using Informix; however, I do not recall any pain during this process. Since I am getting a few (okay, a lot of) gray hairs, I thought I would ask the community a few questions. Do you have any recommendations one way or the other regarding this type of upgrade? I do not remember having to unload and reload the data . which is what I would consider being the biggest pain. Advantages of such an upgrade? Disadvantages? Both the UNIX and IFMX upgrade would occur on the same UNIX server that the current AIX/IFMX resides upon. Take care. Clifton M. Bean Informix DBA / AIX System Admin Currency Technics & Metrics 1431 Greenway Drive #700 Irving, Texas 75038 Main (972) 812-1411 x244 Toll Free (800) 834-8807 x244 Fax (469) 417-0665
Hi, the biggest advantage of 64-bit: 'unlimited' shared memory is available (only limited by physical RAM). E.g. if you have a big machine with much memory and you want to configure a big informix instance (or many smaller ones) than 64bit is the right way to go. If you only have a small machine or small shared memory footprints there is no need to switch to 64bit . Regards, Andreas > ------------------------------------------- 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 Wichtiger Hinweis: Der Inhalt dieser E-Mail kann vertrauliche und rechtlich geschützte Informationen, insbesondere Betriebs- oder Geschäftsgeheimnisse, enthalten, zu deren Geheimhaltung der Empfänger verpflichtet ist. Die Informationen in dieser E-Mail sind ausschließlich für den Adressaten bestimmt. Sollten Sie die E-Mail irrtümlich erhalten haben so ersuchen wir Sie, die Nachricht von Ihrem System zu löschen und sich mit uns in Verbindung zu setzen. Über das Internet versandte E-Mails können leicht manipuliert oder unter fremdem Namen erstellt werden. Daher schließen wir die rechtliche Verbindlichkeit der in dieser Nachricht enthaltenen Informationen aus. Der Inhalt der E-Mail ist nur rechtsverbindlich, wenn er von uns schriftlich bestätigt und gezeichnet wird. Sollte trotz der von uns verwendeten Virus-Schutzprogramme durch die Zusendung von E-Mails ein Virus in Ihre Systeme gelangen, haften wir nicht für evtl. hieraus entstehende Schäden. Wir danken für Ihr Verständnis. Important notice: The contents of this e-mail may contain confidential and legally protected information that is in particular related to operational and trade secrets, which the recipient is obliged to treat as confidential. The information in this e-mail is made available exclusively for use by the addressee. In the event that the e-mail may have been sent to you in error, we would ask you to kindly delete this communication from your system and to contact us. E-mails sent via the Internet can be easily manipulated or sent out under someone else's name. We therefore do not accept legal liability for the information contained in this communication. The contents of the e-mail are only legally binding if they have been confirmed and signed by us in writing. If, in spite of our using Antivirus protection software, a virus may have penetrated your system through the sending of this e-mail, we do not accept liability for any damage that may possibly arise as a result of this. We trust that you appreciate our position. ------------------------------------------- -----Ursprüngliche Nachricht----- > Von: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]Im Auftrag von > Clifton Bean > Gesendet: Donnerstag, 05. Oktober 2006 17:50 > An: ids@iiug.org > Betreff: Advantages/Disadvantages of Upgrading a 9.21 3.... [7580] > > > > I seem to recall going through a 32-bit to 64-bit upgrade in > my past 18 > years using Informix; however, I do not recall any pain > during this process. > Since I am getting a few (okay, a lot of) gray hairs, I > thought I would ask > the community a few questions. > > Do you have any recommendations one way or the other > regarding this type of > upgrade? I do not remember having to unload and reload the > data . which is > what I would consider being the biggest pain. Advantages of such an > upgrade? Disadvantages? > > Both the UNIX and IFMX upgrade would occur on the same UNIX > server that the > current AIX/IFMX resides upon. > > Take care. > > Clifton M. Bean > Informix DBA / AIX System Admin > Currency Technics & Metrics > 1431 Greenway Drive #700 > Irving, Texas 75038 > > Main (972) 812-1411 x244 > > Toll Free (800) 834-8807 x244 > > Fax (469) 417-0665 > > > ************************************************************** > ***************** > Forum Note: Use "Reply" to post a response in the discussion forum. > >
I remember a few issues. We're on sun/solaris and our default compiler compiles to 32-bit. So, we had to modify the c4gl command to compile using the flag for 64-bit. We have plenty of C and ESQL/C code. The 64-bit compiler on Solaris now sees a long as a 64-bit, whereas it used to consider a long 32-bit with the 32-bit compiler. int types are still 32-bit. So, we had to evaluate our use of "long" data types in our C code and ended up changing many of them to int. We still haven't upgraded our 4J's code to 64 bit. Our C functions behave very mysteriously. It's probably the gcc compiler that 4Js requires. We just haven't had the time to spend to go back and figure out the problem and covert the application. Clifton Bean (cbean@ctm.com) wrote : > I seem to recall going through a 32-bit to 64-bit upgrade in my past 18 > years using Informix; however, I do not recall any pain during this process. > Since I am getting a few (okay, a lot of) gray hairs, I thought I would ask > the community a few questions. > > Do you have any recommendations one way or the other regarding this type of > upgrade? I do not remember having to unload and reload the data . which is > what I would consider being the biggest pain. Advantages of such an > upgrade? Disadvantages? > > Both the UNIX and IFMX upgrade would occur on the same UNIX server that the > current AIX/IFMX resides upon. > > Take care. > > Clifton M. Bean > Informix DBA / AIX System Admin > Currency Technics & Metrics > 1431 Greenway Drive #700 > Irving, Texas 75038 > > Main (972) 812-1411 x244 > > Toll Free (800) 834-8807 x244 > > Fax (469) 417-0665 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > -- ______________________________________________________________________ Joel Schumacher JCPenney Co. - UNIX Network Systems jschumac@jcpenney.com 6501 Legacy Drive M/S 6108 (972) 431-4044 Plano, TX 75024 The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer.
Hi, If you use IP to connect to your db, no changes of your clients should be necessary. The only need to have client-side 64 bit code is in case you use (and need to have) shared memory access. Otherwise, setting INFORMIXSERVER to a TCP-Connection should do the trick and all your apps still work. It should also be possible to install a clientsdk 32bit and server 64 bit on the same machine (maybe in two different informix dirs). Regarding unload/load, it should not be necessary (my personal opinion). We have upgraded some databases in the past (I think it was 9.30) from 32 bit to 64 bit. It was always in place, no problems encountered. The only thing is when you upgrade from 9.40 from a lower version (e.g. 9.21), you will need plenty of space depending on your database size (we had very many tables > 200000), because the internal structures are converted to a different scheme during update. But this was not depending on the 32/64 issue. Read the upgrade notes for this and check back with your reseller. Marcus -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Joel Schumacher Sent: Thursday, October 05, 2006 6:21 PM To: ids@iiug.org Subject: Re: Advantages/Disadvantages of Upgrading a 9..... [7582] I remember a few issues. We're on sun/solaris and our default compiler compiles to 32-bit. So, we had to modify the c4gl command to compile using the flag for 64-bit. We have plenty of C and ESQL/C code. The 64-bit compiler on Solaris now sees a long as a 64-bit, whereas it used to consider a long 32-bit with the 32-bit compiler. int types are still 32-bit. So, we had to evaluate our use of "long" data types in our C code and ended up changing many of them to int. We still haven't upgraded our 4J's code to 64 bit. Our C functions behave very mysteriously. It's probably the gcc compiler that 4Js requires. We just haven't had the time to spend to go back and figure out the problem and covert the application. Clifton Bean (cbean@ctm.com) wrote : > I seem to recall going through a 32-bit to 64-bit upgrade in my past > 18 years using Informix; however, I do not recall any pain during this process. > Since I am getting a few (okay, a lot of) gray hairs, I thought I > would ask the community a few questions. > > Do you have any recommendations one way or the other regarding this > type of upgrade? I do not remember having to unload and reload the > data . which is what I would consider being the biggest pain. > Advantages of such an upgrade? Disadvantages? > > Both the UNIX and IFMX upgrade would occur on the same UNIX server > that the current AIX/IFMX resides upon. > > Take care. > > Clifton M. Bean > Informix DBA / AIX System Admin > Currency Technics & Metrics > 1431 Greenway Drive #700 > Irving, Texas 75038 > > Main (972) 812-1411 x244 > > Toll Free (800) 834-8807 x244 > > Fax (469) 417-0665 > > > **************************************************************************** *** > Forum Note: Use "Reply" to post a response in the discussion forum. > -- ______________________________________________________________________ Joel Schumacher JCPenney Co. - UNIX Network Systems jschumac@jcpenney.com 6501 Legacy Drive M/S 6108 (972) 431-4044 Plano, TX 75024 The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.
Hi, If you use IP to connect to your db, no changes of your clients should be necessary. The only need to have client-side 64 bit code is in case you use (and need to have) shared memory access. Otherwise, setting INFORMIXSERVER to a TCP-Connection should do the trick and all your apps still work. It should also be possible to install a clientsdk 32bit and server 64 bit on the same machine (maybe in two different informix dirs). Regarding unload/load, it should not be necessary (my personal opinion). We have upgraded some databases in the past (I think it was 9.30) from 32 bit to 64 bit. It was always in place, no problems encountered. The only thing is when you upgrade from 9.40 from a lower version (e.g. 9.21), you will need plenty of space depending on your database size (we had very many tables > 200000), because the internal structures are converted to a different scheme during update. But this was not depending on the 32/64 issue. Read the upgrade notes for this and check back with your reseller. Marcus -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Joel Schumacher Sent: Thursday, October 05, 2006 6:21 PM To: ids@iiug.org Subject: Re: Advantages/Disadvantages of Upgrading a 9..... [7582] I remember a few issues. We're on sun/solaris and our default compiler compiles to 32-bit. So, we had to modify the c4gl command to compile using the flag for 64-bit. We have plenty of C and ESQL/C code. The 64-bit compiler on Solaris now sees a long as a 64-bit, whereas it used to consider a long 32-bit with the 32-bit compiler. int types are still 32-bit. So, we had to evaluate our use of "long" data types in our C code and ended up changing many of them to int. We still haven't upgraded our 4J's code to 64 bit. Our C functions behave very mysteriously. It's probably the gcc compiler that 4Js requires. We just haven't had the time to spend to go back and figure out the problem and covert the application. Clifton Bean (cbean@ctm.com) wrote : > I seem to recall going through a 32-bit to 64-bit upgrade in my past > 18 years using Informix; however, I do not recall any pain during this process. > Since I am getting a few (okay, a lot of) gray hairs, I thought I > would ask the community a few questions. > > Do you have any recommendations one way or the other regarding this > type of upgrade? I do not remember having to unload and reload the > data . which is what I would consider being the biggest pain. > Advantages of such an upgrade? Disadvantages? > > Both the UNIX and IFMX upgrade would occur on the same UNIX server > that the current AIX/IFMX resides upon. > > Take care. > > Clifton M. Bean > Informix DBA / AIX System Admin > Currency Technics & Metrics > 1431 Greenway Drive #700 > Irving, Texas 75038 > > Main (972) 812-1411 x244 > > Toll Free (800) 834-8807 x244 > > Fax (469) 417-0665 > > > **************************************************************************** *** > Forum Note: Use "Reply" to post a response in the discussion forum. > -- ______________________________________________________________________ Joel Schumacher JCPenney Co. - UNIX Network Systems jschumac@jcpenney.com 6501 Legacy Drive M/S 6108 (972) 431-4044 Plano, TX 75024 The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.