ADSM-L

Re: buffer pool page size

2002-07-23 14:49:16
Subject: Re: buffer pool page size
From: David Longo <David.Longo AT HEALTH-FIRST DOT ORG>
Date: Tue, 23 Jul 2002 14:47:18 -0400
No, because you are getting 98% + "Cache Hit Pct" which is about
as good as it gets.  This doesn't impact DB backup/restore I don't think.
You need to increse size of DB itself at 99% full that is probably
a problem.  Maybe need two TSM servers with load split between them.

David Longo

>>> jdawes AT CHUBB DOT COM 07/23/02 12:19PM >>>
Can increasing the database buffer pool size increase the backup and
restore performance of theTSM database. see following:

          Available Space (MB): 164,000
        Assigned Capacity (MB): 162,500
        Maximum Extension (MB): 1,500
        Maximum Reduction (MB): 1,420
             Page Size (bytes): 4,096
******************
            Total Usable Pages: 41,600,000
                    Used Pages: 41,211,591
                      Pct Util: 99.1
                 Max. Pct Util: 99.1
              Physical Volumes: 154
             Buffer Pool Pages: 65,536
         Total Buffer Requests: 1,370,119,337
                Cache Hit Pct.: 98.76
               Cache Wait Pct.: 0.00
           Backup in Progress?: Yes
    Type of Backup In Progress: Incremental
  Incrementals Since Last Full: 3
Changed Since Last Backup (MB): 11.36
            Percentage Changed: 0.01



"MMS <health-first.org>" made the following
 annotations on 07/23/2002 02:48:39 PM
------------------------------------------------------------------------------
---
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>