Re: upgrade to IDS 7.30 UC2-1

From: "Ralf Peters" <RalfP.remove.@marlows.com.au> > >After we upgraded to version 7.30 UC2-1 IDS running under DG/UX 4.20, the >engine seems to run like a dog , nothing else has changed. it seems that >after running update statistics it is even worse . > >ONSTAT - R >Informix Dynamic Server Version 7.31.UC2 -- On-Line (CKPT REQ) -- Up 20 >days 0 >2:22:15 -- 190512 Kbytes >Blocked:CKPT > >8 buffer LRU queue pairs priority levels ># f/m pair total % of length LOW MED_LOW MED_HIGH HIGH > 0 f 3123 76.5% 2390 0 974 1357 59 > 1 m 23.5% 733 0 636 97 0 > 2 f 3123 76.9% 2403 0 947 1402 54 > 3 m 23.1% 720 0 639 81 0 > 4 f 3123 77.4% 2416 0 973 1397 46 > 5 m 22.6% 707 0 601 106 0 > 6 f 3122 75.6% 2360 0 952 1349 59 > 7 m 24.4% 762 0 676 86 0 > 8 f 3122 82.3% 2568 0 1193 1327 48 > 9 m 17.7% 554 0 473 81 0 >10 f 3122 76.4% 2386 0 964 1370 52 >11 m 23.6% 736 0 636 100 0 >12 F 3123 77.6% 2422 0 1010 1340 72 >13 m 22.4% 701 0 618 83 0 >14 f 3123 79.4% 2480 0 1085 1334 61 >15 m 20.6% 643 0 548 95 0 >5556 dirty, 24981 queued, 25000 total, 32768 hash buckets, 2048 buffer size >start clean at 60% (of pair total) dirty, or 1875 buffs dirty, stop at 50% >0 priority downgrades, 0 priority upgrades > > > >ONSTAT -P >......SNIP > >Totals: 25000 13282 10250 1468 0 2479 > >Percentages: >Data 41.00 >Btree 53.13 <<<< this one gets up to 95% at times >Other 5.87 > > >We are thankful for any clues Try dropping all your indexes and rebuilding them. HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com