Informix 7.25 SE on Digital Unix 5.1

Hi all, We testing in order to migrate to Informix 7.25 SE (yes, a bit old) on a Dec Tru64 5.1 and found some performance issues. The previuos instante was running in a DecUnix 4.0d with Informix 7.24 SE in a less powerful machine. Testing the same query on both boxes, in the 7.25-Tru5.1 one it takes about 20 secs to complete and in the old one results are almost inmediate. DB has been imported from unload recently and should have no degradation. We have some issues with 7.25 and C2 security and seemed to be resolved, turning it off for informix user. We have no idea of what can be causing this delay. No disk bottleneck is found (no I/O traffic or swapping) The only strange thing is that kernel activity raises more (20% or so) than the old version on 4.0d Any ideas for this performance issue? Regards Carlos

Carlos Alonso wrote: > Hi all, > > We testing in order to migrate to Informix 7.25 SE (yes, a bit old) > on a Dec Tru64 5.1 and found some performance issues. The previuos > instante was running in a DecUnix 4.0d with Informix 7.24 SE in a less > powerful machine. > > Testing the same query on both boxes, in the 7.25-Tru5.1 one it takes > about 20 secs to complete and in the old one results are almost > inmediate. DB has been imported from unload recently and should have > no degradation. > > We have some issues with 7.25 and C2 security and seemed to be > resolved, turning it off for informix user. We have no idea of what > can be causing this delay. No disk bottleneck is found (no I/O traffic > or swapping) The only strange thing is that kernel activity raises > more (20% or so) than the old version on 4.0d > > Any ideas for this performance issue? > > Regards > > Carlos Have you updated statistics after the load post the results of set explain on from the old and the new