Do a: reset bufpool
This will reset the negative and 3 other stats on this command. Then notice what
they start showing. I trhink the counter gets so big that it increments the
"negative" bit. Someone else had similar situation a week or two ago. If your cahe
hit Pct is still low as shown then you definitely need to increase BUFPOOLSIZE to get
this to aroung 98-99%.
I would say that your DB is too small if it is 88 Pct utilized, need to increase. I
forget specifics but I think some suggestions are not to be over 75% or maybe less in
some cases. I am running a 13GB DB and it is 65-70% Util.
David B. Longo
System Administrator
Health First, Inc.
3300 Fiske Blvd.
Rockledge, FL 32955-4305
PH 321.434.5536
Pager 321.634.8230
Fax: 321.434.5525
[EMAIL PROTECTED]
>>> [EMAIL PROTECTED] 05/08/01 11:21AM >>>
I was doing some statistic checking on my TSM 4.1.2 server and came
across a puzzling situation. Looking at my DB I get the following
output:
Available Space (MB): 24,576
Assigned Capacity (MB): 24,576
Maximum Extension (MB): 0
Maximum Reduction (MB): 2,880
Page Size (bytes): 4,096
Total Usable Pages: 6,291,456
Used Pages: 5,545,979
Pct Util: 88.2
Max. Pct Util: 88.3
Physical Volumes: 6
Buffer Pool Pages: 49,152
Total Buffer Requests: -1,132,081,689
Cache Hit Pct.: 74.83
Cache Wait Pct.: 0.00
Backup in Progress?: Yes
Type of Backup In Progress: Full
Incrementals Since Last Full: 0
Changed Since Last Backup (MB): 0.03
Percentage Changed: 0.00
Last Complete Backup Date/Time: 05/07/2001 11:43:29
I noticed that my Cache Hit Pct. is way lower than what is recommended.
I have BUFPoolsize set to 196608. My server contains 2GB of memory
and lsps -a shows 192MB.
The thing I am most concerned about is the negative number on Total
Buffer Requests. I've been looking through the documentation and the
ADSM-L archive and haven't found any reference as to what a negative
number here represents. Can anyone point me in the right direction?
Thanks in advance.
--
Jeff Rankin
Associate Technical Analyst, Excel Corporation
Phone: 316-291-2903
Fax: 316-266-4415
Email: [EMAIL PROTECTED]
"MMS <health-first.org>" made the following
annotations on 05/08/01 11:48:15
------------------------------------------------------------------------------
This message is for the named person's use only. It may contain confidential,
proprietary, or legally privileged information. No confidentiality or privilege is
waived or lost by any mistransmission. If you receive this message in error, please
immediately delete it and all copies of it from your system, destroy any hard copies
of it, and notify the sender. You must not, directly or indirectly, use, disclose,
distribute, print, or copy any part of this message if you are not the intended
recipient. Health First reserves the right to monitor all e-mail communications
through its networks. Any views or opinions expressed in this message are solely
those of the individual sender, except (1) where the message states such views or
opinions are on behalf of a particular entity; and (2) the sender is authorized by
the entity to give such views or opinions.
==============================================================================