: Wednesday, February 19, 2003 10:07 PM
To: [EMAIL PROTECTED]
Subject: [new] DB Cache Hit Rate Question
Hi Guys!
In following this thread, I thought I'd check out customer experience with a
stock TSM server they have.
q db f=d showed the DB hit rate at 85%
q opt showed the bufpoolsize at
Hi Guys!
In following this thread, I thought I'd check out customer experience
with a stock TSM server they have.
q db f=d showed the DB hit rate at 85%
q opt showed the bufpoolsize at 2350
This was with auto tuning.
After disabling auto-bufpool tuning, I increased the
bufpoolsize to 1310
>...Should the cache hit rate consistently be above 98%? ...
In a single word: No. The 99%+ is the fairy tale objective.
You'll find numerous postings in the List archives advising of
the real world behavior of caches which, as you've seen with
Backups, cause the number to drop,
f the time, i.e. when running backups etc, it drops to
as low as 95%.
Should the cache hit rate consistently be above 98%? This is the answer I
cannot find.
Many thanks again to all who have provided help with this.
Farren Minns - John Wiley & Sons
Please respond to "ADSM: Dist St
>Can anybody tell me where I can locate a copy of the TSM 3.7 Technical
>Ref Redbook.
>I assume it is a seperate entity to the Admin Guide and Admin Reference.
Farren - Yes... All redbooks are separate from the main manuals.
The redbooks are at http://www.redbooks.ibm.com .
There, you wou
PROTECTED]]
Sent: Wednesday, February 19, 2003 11:15
To: [EMAIL PROTECTED]
Subject: Re: DB Cache Hit Rate Question
Can anybody tell me where I can locate a copy of the TSM 3.7 Technical Ref
Redbook.
I assume it is a seperate entity to the Admin Guide and Admin Reference.
Thanks
Farren Minns
John
: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Subject: Re: DB Cache Hit Rate Question
>I'm a little confused about the cache hit ratio information. If I run
>expiration on a database, surely the TSM server has to trawl t
rom: Farren Minns [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 18, 2003 8:25 AM
To: [EMAIL PROTECTED]
Subject: DB Cache Hit Rate Question
Good afternoon all TSMers.
I'm a little confused about the cache hit ratio information. If I run
expiration on a database, surely the TSM server has to
>I'm a little confused about the cache hit ratio information. If I run
>expiration on a database, surely the TSM server has to trawl through the
>entire thing on disk as it does not already reside in the buffer. So how
>would I expect to see hit ratios of 99% or higher. I won't go into details
>her
Good afternoon all TSMers.
I'm a little confused about the cache hit ratio information. If I run
expiration on a database, surely the TSM server has to trawl through the
entire thing on disk as it does not already reside in the buffer. So how
would I expect to see hit ratios of 99% or higher. I wo
.
Zlatko Krastev
IT Consultant
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
Sent by:"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Subject:Antwort: Re: cache hit rate
Hi,
an IBM Technician gave me the f
espond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:(bcc: John Naylor/HAV/SSE)
Subject: Re: cache hit rate
**
The information in this E-Mail is confidential and may be legally
L. Nick"
Subject: Re: cache hit rate
S
cc:
Sent by: "ADSM: Dist Stor Subject: Re: cache hit rate
Another point that I have not seen yet on this thread...
[WinNT 4.0 SP6a]
I used to have a problem with cache hit rate... and just kept increasing the
Buffer Pool Size..
A temporary improvement would be seen, but this would soon be lost and the
rate would fall dramatically.. I once saw 67
34:34 PM
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:(bcc: John Naylor/HAV/SSE)
Subject: Re: cache hit rate
**
The information in this E-Mail is confidential a
Hi,
an IBM Technician gave me the following rule:
bufpoolsize = 10% of your memory.
I think 49152 is ok ...
MfG
Sascha Bräuning
Sparkassen Informatik, Fellbach
OrgEinheit: 6322
Wilhelm-Pfitzer Str. 1
70736 Fellbach
Telefon: (0711) 5722-2144
Telefax: (0711) 5722-1630
Mailadr.: [EMAIL
o experience. I fact I'm learning from your experience. While you say
"from my training at IBM that a cache hit rate of 99% and above is
recommended"
I found the following statement in the web interface.
The server database performs best with a cache hit ratio above 97% in the
dat
To: [EMAIL PROTECTED]
cc:
Subject:Re: cache hit rate
No experience. I fact I'm learning from your experience. While you say
"from my training at IBM that a cache hit rate of 99% and above is
recommended"
I found the following statement in the web inter
"KEN HORACEK"
cc:
Sent by: "ADSM:
No experience. I fact I'm learning from your experience. While you say
"from my training at IBM that a cache hit rate of 99% and above is
recommended"
I found the following statement in the web interface.
The server database performs best with a cache hit ratio above 97%
, 21. August 2002 16:34
An: [EMAIL PROTECTED]
Betreff: Re: cache hit rate
On woensdag, augustus 21, 2002, at 09:46 , Sascha Braeuning wrote:
> Hi all,
>
> first I've to thank all participants for the amount of answers I got on
> my
> latest questions. Now I've got a new
On woensdag, augustus 21, 2002, at 09:46 , Sascha Braeuning wrote:
> Hi all,
>
> first I've to thank all participants for the amount of answers I got on
> my
> latest questions. Now I've got a new one which relates on the
> bufferpoolsize and the cache hit rate on OS
Hi all,
first I've to thank all participants for the amount of answers I got on my
latest questions. Now I've got a new one which relates on the
bufferpoolsize and the cache hit rate on OS/390 TSM-Servers.
we use the following bufpoolsize: 32768
our chache hit rate:97,7
ation than you'd think" -
Scott Adams/Dilbert
-Original Message-
From: MORGAN TONY [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 11, 2002 4:19 AM
To: [EMAIL PROTECTED]
Subject: Cache Hit Rate, Bufpoolsize Size and N
Another week another problem... Hi Guys!!
I have a DB (shown Below) which I am having trouble with. The Cache Hit %
was static for months at 98%+, but since the database was rebuilt by a
friendly consultant (nice bloke!) I have been unable to achieve consistant
results above the mid 90's.
The B
26 matches
Mail list logo