Check carefully what else this consultant have done. Descreasing the number
of DB volumes will affect the speed for sure but should not change the hit
ratio.
What means "rebiult the database"? Was this backup/restore DB, dump/load or
DEFine DBVolume/DELete DBVolume?

Zlatko Krastev
IT Consultant





MORGAN TONY <TONY.MORGAN AT FORTISBANK DOT COM> on 23.10.2001 11:54:06
Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To:     ADSM-L AT VM.MARIST DOT EDU
cc:

Subject:        Cache Hit % dropping on NT

Dear *SMers,

I am running TSM V4.1.1.0 on an NT box.

For 10 months I have had not problem with Cache Hit @ 98-99% with
SELFTUNEBUFSIZE on.

In the last 2 weeks the Cache hit rate has dropped dramatically.. I have
manually raised the BUFPOOLSIZE base setting from 32768 in stages to 43008
and the Cache seems fine for a short while, then drops off again.

Is this a sign of a database about to die, or something else horrible?????

I would appreciate some help!!

One thing that did happen... about a month ago the server was rebuilt by a
TSM consultant (yes! I know) and he rebuilt the database into 1 file rather
than my 5 files of similar size... He said that I had got it wrong! (I am
sceptical - as I am old enough to be his father and was tuning databases
before he started on solid food!!!)

Any Ideas??

Many Thanks

Tony Morgan
Fortis Bank UK

============================================================
This e-mail and any files transmitted with it, are confidential and
This e-mail and any files transmitted with it, are confidential and
intended solely for the use of the addressee. The content of this
e-mail may have been changed without the consent of the originator.
The information supplied must be viewed in this context. If you have
received this e-mail in error please notify our Helpdesk by
telephone on +44 (0) 20-7444-8444. Any use, dissemination,
forwarding, printing, or copying of this e-mail or its attachments is
strictly prohibited.