Migration from IDS 7.25 to 7.31

Hi ALL Excuse me i am an old infromix adm, but my expirence was developed in Online 5.x and 4GL RDS 4.x , this year migrate to IDS 7.25 and 4gl 7.20 intalled on an RS6000 f50 AIX 4.3, in these moths we get some performance problems, concentrate in a few days of high activity, we get a bug know : Bug de Informix --- Bug: 105813 SM_POLL THREAD CAN ASSERT FAIL BECAUSE OF TIMING ISSUE BETWEEN AN INTERUPTED SHARED MEMORY CONNECTION AND ITSELF we still waiting for a 7.24.UC9 from Agost, a few days ago we have recived a 7.31 as an UPDATE. are there some advice about this new version?, somebody knows a migration way, is it a good solution to fix the bug?

Daniel Esquerre Fernandez wrote: > > Hi ALL > > Excuse me i am an old infromix adm, but my expirence was developed > in Online 5.x and 4GL RDS 4.x , this year migrate to IDS 7.25 and 4gl 7.20 > intalled on an RS6000 f50 AIX 4.3, in these moths we get some performance > problems, concentrate in a few days of high activity, we get a bug know : > > Bug de Informix --- > > Bug: 105813 SM_POLL THREAD CAN ASSERT FAIL BECAUSE OF TIMING ISSUE > BETWEEN AN INTERUPTED SHARED MEMORY CONNECTION AND ITSELF Someone interrupted a user program using kill -9 or kill -TERM or ^C and left some shared memory data corrupted. The engine crashed because it could not figure out how to correct the problem. > we still waiting for a 7.24.UC9 from Agost, a few days ago we have recived a > 7.31 as an UPDATE. are there some advice about this new version?, somebody > knows a migration way, is it a good solution to fix the bug? Version 7.31 can upgrade you from 7.24 automatically, as long as you do not have any incomplete In-Place ALTERs in progress. You can check this with oncheck -pT database:table. At the end of the report is a report of the different record versions contained in the table and how many of each there are. For any tables which have any rows for a version other than (current) execute an update of every row by setting some column to itself. This will force the engine to complete the ALTER and update every row to the new format. IDS 7.31 is significantly faster than 7.24 and less buggy to boot. If you have 7.31UC3 or earlier upgrade to get a version that does not have a particular bug (#115327) which is either 7.31UC3 or UC4 I don't remember. Art S. Kagel