ADSM-L

Re: TSM Database Question

2001-05-08 11:46:10
Subject: Re: TSM Database Question
From: David Longo <David.Longo AT HEALTH-FIRST DOT ORG>
Date: Tue, 8 May 2001 11:46:53 -0400
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
david.longo AT health-first DOT org


>>> Jeff_Rankin AT CARGILL DOT COM 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
Jeff Rankin
Associate Technical Analyst, Excel Corporation
Phone:   316-291-2903
Fax:     316-266-4415
Email:   Jeff_Rankin AT cargill DOT com 



"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 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.

==============================================================================
<Prev in Thread] Current Thread [Next in Thread>