Re: testing memory parameters

From: Serge Rielau <>
Date: Mon, 17 Mar 2008 22:31:59 -0400
Message-ID: <>

DA Morgan wrote:
> Serge Rielau wrote:

>>> Below what value is BCHR "bad"?
>> In DB2 I treat any OLTP app with less than 90% hit ratio as troubled.
>> Anything less than 80% I'd call a mess requiring some serious 
>> explanation.

> Because, in DB2, you don't have sufficient instrumentation to look
> inside and see what is happening.

Ah, Daniel, you never fail to live up to my expectation of taking a cheap shot wherever you can. What would you know about DB2's state of perf tuning tools...
But I digress. I got the answers I needed.

Thanks Ana

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Received on Mon Mar 17 2008 - 21:31:59 CDT

Original text of this message