Informix updated
A user planned to upgrade Informix from 7.30.UC5 to 7.31.UC5 and asked about known problems or tips. Replies warned of bugs in UC5 (server crashes on certain selects such as 'where 99 in (99)' or concatenating a date, and problems creating fragmented temp tables in non-existent dbspaces), plus reported optimiser bugs on HP-UX. The advice was to install 7.31.UC6-1 instead, where those defects are fixed, and to ensure all in-place ALTERs have completed before upgrading. Others reported UC6 stable with improved performance.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi all, I am going to updated Informix from version 7.30-uc5-1 to 7.31-uc5-1 this week. Is there any know problem or any hints before updated to this version. I would be appreciated any comments. Thanks -- Wayne Trieu Sent via Deja.com http://www.deja.com/ Before you buy.
In article <8enkq5$4bk$1@nnrp1.deja.com>, Wayne Trieu <trieu@ti.L- 3Com.com> writes > > >Hi all, > I am going to updated Informix from version 7.30-uc5-1 to >7.31-uc5-1 this week. Is there any know problem or any hints before >updated to this version. I would be appreciated any comments. Thanks > 7.31.UC6-1 is the latest... > >-- >Wayne Trieu > > >Sent via Deja.com http://www.deja.com/ >Before you buy. -- David Williams
Wayne Trieu wrote: > > Hi all, > I am going to updated Informix from version 7.30-uc5-1 to > 7.31-uc5-1 this week. Is there any know problem or any hints before > updated to this version. I would be appreciated any comments. Thanks > > -- > Wayne Trieu > > Sent via Deja.com http://www.deja.com/ > Before you buy. You dont say what OS you're on but I tested this version on HPUX and there are some serious optimiser bugs! I decided not to upgrade, I'm waiting for the latest version -- --------------------------------------- Tony Flaherty aef@mfs.misys.co.uk Analyst Programmer Misys Financial Systems All statements and opinions are my own, Misys don't pay me enough to have opinions on their behalf .
Wayne Trieu wrote: > > Hi all, > I am going to updated Informix from version 7.30-uc5-1 to > 7.31-uc5-1 this week. Is there any know problem or any hints before > updated to this version. I would be appreciated any comments. Thanks > > -- > Wayne Trieu > > Sent via Deja.com http://www.deja.com/ > Before you buy. You dont say what OS you're on but I tested this version on HPUX and there are some serious optimiser bugs! I decided not to upgrade, I'm waiting for the latest version -- --------------------------------------- Tony Flaherty aef@mfs.misys.co.uk Analyst Programmer Misys Financial Systems All statements and opinions are my own, Misys don't pay me enough to have opinions on their behalf .
Found these: 120773 Engine crashes on select with where clause like ‘where 99 in (99)’ 123052 Engine crashes when trying to create fragmented temp table in DBSPACES which do not exists. Regression fix for 109833 123706 Select ‘BLA’||DATE(‘’) from systables CRASHES SERVER But in general, the engine has been stable for me on HP-UX and performance has increased. We upgraded from 7.24. * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!
Most important is to make sure all in-place ALTERs have been completed. Art S. Kagel Wayne Trieu wrote: > > Hi all, > I am going to updated Informix from version 7.30-uc5-1 to > 7.31-uc5-1 this week. Is there any know problem or any hints before > updated to this version. I would be appreciated any comments. Thanks > > -- > Wayne Trieu > > Sent via Deja.com http://www.deja.com/ > Before you buy.
In article <23f38a80.4ba76195@usw-ex0103-023.remarq.com>, bob <bhercerNO bhSPAM@mbna.com.invalid> writes >Found these: > >120773 Engine crashes on select with where clause like ââ¬Ëwhere >99 in (99)ââ¬â¢ > Fixed in 7.31.UC6-1 >123052 Engine crashes when trying to create fragmented temp >table in DBSPACES which do not exists. Regression fix for 109833 > Fixed in 7.31.UC6-1, also 121277 CREATE TEMP TABLE ... FRAGMENTED IN NON EXISTING DBSPACES LEAVES DANGLING FRAGMENTS ALREADY CREATED also fixed in 7.31.UC6-1 >123706 Select ââ¬ËBLAââ¬â¢||DATE(ââ¬Ëââ¬â¢) from systables CRASHES >SERVER > Also Fixed in 7.31.UC6-1 Get UC6-1, it's the latest! >But in general, the engine has been stable for me on HP-UX and >performance has increased. We upgraded from 7.24. > >* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * >The fastest and easiest way to search and participate in Usenet - Free! > -- David Williams