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.

==============================================================================

Reply via email to