Re: Dynamic Cursors in ESQL/C

> We have an experience that the performance of our system is gradually > decreasing while it is running. Because we use dynamic cursors, the explain > plan only shows once while we have set explain on. The plan shows that it is > index read but we discover that the time is gradually increasing of retriving > records. > > The workload of CPU is concentrated on 'oninit' and the usage of i/o is low by > sar 2 5, sar -d 2 5 and top. The percentage of 'oninit' is above 90%. We think > it is abnormal. > > We have update statistics high, Informix Online 7.11UC1 and HP-UX 10.01 Erk. I think the problem is the combination of OnLine 7.11 and HPUX 10.01. There have been dozens of complaints with this combo - try upgrading to HPUX 10.10 (do this first) and OnLine 7.12... HTH. -- Ciao, Billy +------------------------------------------------------------------------------+ | Billy Wheeler Junior Programmer / Director The West Solutions Group | +------------------------------------------------------------------------------+ | (E) billy@west.co.za (U) http://www.west.co.za/billy.html | +------------------------------------------------------------------------------+ | A WAY COMPUTERS CHANGED THE WORLD: 1 million banking errors | +------------------------------------------------------------------------------+