RE: btree percentages at 95%

Which version of 7.31? What platform? There is a bug - 115327. It sounds like you have it. We had 7.31.UC2 on HP-UX 10.20 - had to upgrade to 7.31.UC4 to fix it. There have been some posts about recreating the indexes. But it is a short-term fix and the problem will come back. You have to upgrade. I'm working on something right now or I would look it up. You might try the iiug archives for more information. Dianne -----Original Message----- From: Doug McAllister [mailto:doug.mcallister@nospam.fmr.com] Sent: December 03,1999 11:52 AM To: informix-list@iiug.org Subject: btree percentages at 95% This is a multi-part message in MIME format. --------------C6239C315D267802C9495942 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all.... We have been analyzing the performance of a particular job and I was wondering if anyone has insight into the following question. The analysis shows that the buffers have 96% btree data and only 3% data. Might this be a symptom of the index bug which shows up in systems that have been migrated from 7.24 to 7.31? The "onstat -p" shows most of my read-aheads occurring for ixda-RA and not idx-RA. Also, the Profile shows that the read/write buffer cache hit ratio is good (99%) so the page vs buffer access are low. Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 63481 91053 114009191 99.94 2473 25449 465944 99.47 isamtot open start read write rewrite delete commit rollbk 111216550 330470 747181 107676672 135508 18757 1536 1973 0 gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs 0 0 0 0 0 0 0 ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes 0 0 0 3338.00 98.54 0 0 bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans 21775 0 39171673 0 0 0 3606 25690 ixda-RA idx-RA da-RA RA-pgsused lchwaits 40287 0 4299 44505 1034787 The Buffer Percentages show: Data 3.12 Btree 96.75 Other 0.13 --------------C6239C315D267802C9495942 Content-Type: text/x-vcard; charset=us-ascii; name="doug.mcallister.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Doug McAllister Content-Disposition: attachment; filename="doug.mcallister.vcf" begin:vcard n:McAllister;Doug tel;work:(603) 791-5688 x-mozilla-html:FALSE url:www.fidelity.com org:Fidelity Investments version:2.1 email;internet:doug.mcallister@fmr.com title:Consulting DBA adr;quoted-printable:;;2 Contra Way=0D=0AT1Q;Merrimack;NH;03054;USA fn:Doug McAllister end:vcard --------------C6239C315D267802C9495942--