RE: Urgent: Informix upgrade from 7.24 UC4 to 7.30 UC8

Mosser, Thanks for your suggestion. I advised my company about this but as they already have purchased the s/w (7.30 UC8), they want to go with it. By the way are there any problems/bugs etc in 7.30 UC8. Can we find any info on the web regarding problems/bugs etc in 7.30 UC8. I have installed it on a test box and had some users and developers on it for testing the applications. They are finding it faster than 7.24 UC4. Thanks again Vinod Bhansali >From: mosserp@WellsFargo.COM >To: iiug@hotmail.com >CC: informix-list@iiug.org >Subject: RE: Urgent: Informix upgrade from 7.24 UC4 to 7.30 UC8 >Date: Tue, 13 Jun 2000 13:54:09 -0700 > >Strongly suggest that you go to 7.31 or even to 9.2x. Support for 7.30 >moves to category 4 ("Time and Materials" -- see >http://www.informix.com/informix/services/ilink/plc/plccat4.htm) at the end >of this year. > >HTH, >Paul Mosser > >-----Original Message----- >From: Vinod Bhansali [mailto:iiug@hotmail.com] >Sent: Tuesday, June 13, 2000 1:08 PM >To: informix-list@iiug.org >Subject: Urgent: Informix upgrade from 7.24 UC4 to 7.30 UC8 > > >Hi, > >We are planning upgrade our Informix from 7.24 UC4 to 7.30 UC8. >I had some queries as below : >We have already purchased 7.30 UC8 long back. Should we install that >version > >or should we go for more latest version of 7.3x? > >When contacted tech support regarding the change in the kernel parameter >values they say the kernel parameter values should be equal to the values >given in the release notes. If the kernel parameter existing value is >greater than the value specified in release notes it can be left unchanged. >What is your opinion? > >Below I have just listed the steps to do the upgrade process, let me know >if > >they are ok, or if I need to change any of the sequence, or if I need to >add > >any other step : >- Imp files backup : hosts, services, onconfig, sqlhost, .profile, > rhosts, message log, osahosts, ,tctermcap, termcap, set, env, cron >- File system backup >- 0 level archive >- Backup log files >- Check Extents, Reserved pages, DB catalog using oncheck >- Stop the cron jobs >- Bring Informix offline >- Apply OS latest patches if required >- Modify kernel parameters as per release notes >- Relink kernel >- Install Informix 7.3 in new directory >- Copy sqlhost,onconfig, alarmprogram >- Set environment variables >- Change msgpath >- Bring Informix online >- Verify the integrity of the data, indexes using oncheck. >- Test applications programs (C,Cobol,Power Builder, Shell Scripts, > Cron Jobs) >- Make an initial, complete backup of the database server. >- Run UPDATE STATISTICS medium for all databases. >- Verify the access path of your SQL statements. > >Also thanks for your replies for my queries on : >- Warning in message log after tuning CLEANERS >- Errors in log file while creating shared memory >- Detecting system paging or swapping >- Killing a session using onmode -z > > > >Thanks in advance for all your replies. >Vinod Bhansali. >________________________________________________________________________ >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

And 7.31 is faster than 7.30 and 9.20 is faster than 7.31! Informix has been putting tons of work into optimizing IDS over the last 18 months! Art S. Kagel Vinod Bhansali wrote: > > Mosser, > > Thanks for your suggestion. I advised my company about this but as they > already have purchased the s/w (7.30 UC8), they want to go with it. By the > way are there any problems/bugs etc in 7.30 UC8. Can we find any info on the > web regarding problems/bugs etc in 7.30 UC8. I have installed it on a test > box and had some users and developers on it for testing the applications. > They are finding it faster than 7.24 UC4. > > Thanks again > Vinod Bhansali > > >From: mosserp@WellsFargo.COM > >To: iiug@hotmail.com > >CC: informix-list@iiug.org > >Subject: RE: Urgent: Informix upgrade from 7.24 UC4 to 7.30 UC8 > >Date: Tue, 13 Jun 2000 13:54:09 -0700 > > > >Strongly suggest that you go to 7.31 or even to 9.2x. Support for 7.30 > >moves to category 4 ("Time and Materials" -- see > >http://www.informix.com/informix/services/ilink/plc/plccat4.htm) at the end > >of this year. > > > >HTH, > >Paul Mosser > > > >-----Original Message----- > >From: Vinod Bhansali [mailto:iiug@hotmail.com] > >Sent: Tuesday, June 13, 2000 1:08 PM > >To: informix-list@iiug.org > >Subject: Urgent: Informix upgrade from 7.24 UC4 to 7.30 UC8 > > > > > >Hi, > > > >We are planning upgrade our Informix from 7.24 UC4 to 7.30 UC8. > >I had some queries as below : > >We have already purchased 7.30 UC8 long back. Should we install that > >version > > > >or should we go for more latest version of 7.3x? > > > >When contacted tech support regarding the change in the kernel parameter > >values they say the kernel parameter values should be equal to the values > >given in the release notes. If the kernel parameter existing value is > >greater than the value specified in release notes it can be left unchanged. > >What is your opinion? > > > >Below I have just listed the steps to do the upgrade process, let me know > >if > > > >they are ok, or if I need to change any of the sequence, or if I need to > >add > > > >any other step : > >- Imp files backup : hosts, services, onconfig, sqlhost, .profile, > > rhosts, message log, osahosts, ,tctermcap, termcap, set, env, cron > >- File system backup > >- 0 level archive > >- Backup log files > >- Check Extents, Reserved pages, DB catalog using oncheck > >- Stop the cron jobs > >- Bring Informix offline > >- Apply OS latest patches if required > >- Modify kernel parameters as per release notes > >- Relink kernel > >- Install Informix 7.3 in new directory > >- Copy sqlhost,onconfig, alarmprogram > >- Set environment variables > >- Change msgpath > >- Bring Informix online > >- Verify the integrity of the data, indexes using oncheck. > >- Test applications programs (C,Cobol,Power Builder, Shell Scripts, > > Cron Jobs) > >- Make an initial, complete backup of the database server. > >- Run UPDATE STATISTICS medium for all databases. > >- Verify the access path of your SQL statements. > > > >Also thanks for your replies for my queries on : > >- Warning in message log after tuning CLEANERS > >- Errors in log file while creating shared memory > >- Detecting system paging or swapping > >- Killing a session using onmode -z > > > > > > > >Thanks in advance for all your replies. > >Vinod Bhansali. > >________________________________________________________________________ > >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > > ________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

Also, there is an obscure bug in 7.30 that, under rare circumstances, can corrupt the physical log and, during a reboot, wipe out system tables. It took Informix a few versions to fix, but they figured it was so obscure that no one would find it before it was fixed. We did. My company lost their database during a normal bounce. Fortunately, we have good backups. I cannot give you the technical details, but Informix has downed systems engineers who can. Do not use a 7.x series version less than 7.31. -- T.C. Thomas misfit@pobox.com In article <394FABB6.8A13E897@bloomberg.net>, kagel@bloomberg.net wrote: > And 7.31 is faster than 7.30 and 9.20 is faster than 7.31! Informix has > been putting tons of work into optimizing IDS over the last 18 months! > > Art S. Kagel > > Vinod Bhansali wrote: > > > > Mosser, > > > > Thanks for your suggestion. I advised my company about this but as they > > already have purchased the s/w (7.30 UC8), they want to go with it. By the > > way are there any problems/bugs etc in 7.30 UC8. Can we find any info on the > > web regarding problems/bugs etc in 7.30 UC8. I have installed it on a test > > box and had some users and developers on it for testing the applications. > > They are finding it faster than 7.24 UC4. > > > > Thanks again > > Vinod Bhansali > > > > >From: mosserp@WellsFargo.COM > > >To: iiug@hotmail.com > > >CC: informix-list@iiug.org > > >Subject: RE: Urgent: Informix upgrade from 7.24 UC4 to 7.30 UC8 > > >Date: Tue, 13 Jun 2000 13:54:09 -0700 > > > > > >Strongly suggest that you go to 7.31 or even to 9.2x. Support for 7.30 > > >moves to category 4 ("Time and Materials" -- see > > >http://www.informix.com/informix/services/ilink/p lc/plccat4.htm) at the end > > >of this year. > > > > > >HTH, > > >Paul Mosser > > > > > >-----Original Message----- > > >From: Vinod Bhansali [mailto:iiug@hotmail.com] > > >Sent: Tuesday, June 13, 2000 1:08 PM > > >To: informix-list@iiug.org > > >Subject: Urgent: Informix upgrade from 7.24 UC4 to 7.30 UC8 > > > > > > > > >Hi, > > > > > >We are planning upgrade our Informix from 7.24 UC4 to 7.30 UC8. > > >I had some queries as below : > > >We have already purchased 7.30 UC8 long back. Should we install that > > >version > > > > > >or should we go for more latest version of 7.3x? > > > > > >When contacted tech support regarding the change in the kernel parameter > > >values they say the kernel parameter values should be equal to the values > > >given in the release notes. If the kernel parameter existing value is > > >greater than the value specified in release notes it can be left unchanged. > > >What is your opinion? > > > > > >Below I have just listed the steps to do the upgrade process, let me know > > >if > > > > > >they are ok, or if I need to change any of the sequence, or if I need to > > >add > > > > > >any other step : > > >- Imp files backup : hosts, services, onconfig, sqlhost, .profile, > > > rhosts, message log, osahosts, ,tctermcap, termcap, set, env, cron > > >- File system backup > > >- 0 level archive > > >- Backup log files > > >- Check Extents, Reserved pages, DB catalog using oncheck > > >- Stop the cron jobs > > >- Bring Informix offline > > >- Apply OS latest patches if required > > >- Modify kernel parameters as per release notes > > >- Relink kernel > > >- Install Informix 7.3 in new directory > > >- Copy sqlhost,onconfig, alarmprogram > > >- Set environment variables > > >- Change msgpath > > >- Bring Informix online > > >- Verify the integrity of the data, indexes using oncheck. > > >- Test applications programs (C,Cobol,Power Builder, Shell Scripts, > > > Cron Jobs) > > >- Make an initial, complete backup of the database server. > > >- Run UPDATE STATISTICS medium for all databases. > > >- Verify the access path of your SQL statements. > > > > > >Also thanks for your replies for my queries on : > > >- Warning in message log after tuning CLEANERS> > >- Errors in log file while creating shared memory > > >- Detecting system paging or swapping > > >- Killing a session using onmode -z > > > > > > > > > > > >Thanks in advance for all your replies. > > >Vinod Bhansali. > > >_________________________________________________ _______________________ > > >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > > > > __________________________________________________ ______________________ > > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > Sent via Deja.com http://www.deja.com/ Before you buy.