ADSM-L

Re: very very big DB!!!!

2005-06-09 10:31:49
Subject: Re: very very big DB!!!!
From: Robin Sharpe <Robin_Sharpe AT BERLEX DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 9 Jun 2005 10:31:31 -0400
FYI...  my database is 300GB!  (Yes, I am planning to split it):

tsm: TSM_WAYNE>q db f=d

          Available Space (MB): 307,852
        Assigned Capacity (MB): 307,852
        Maximum Extension (MB): 0
        Maximum Reduction (MB): 18,848
             Page Size (bytes): 4,096
            Total Usable Pages: 78,810,112
                    Used Pages: 73,989,129
                      Pct Util: 93.9
                 Max. Pct Util: 93.9
              Physical Volumes: 23
             Buffer Pool Pages: 300,000
         Total Buffer Requests: 796,977,754
                Cache Hit Pct.: 95.48
               Cache Wait Pct.: 0.00
           Backup in Progress?: No
    Type of Backup In Progress:
  Incrementals Since Last Full: 0
Changed Since Last Backup (MB): 2,874.37
            Percentage Changed: 0.99
Last Complete Backup Date/Time: 06/08/05   13:08:57


tsm: TSM_WAYNE>

Robin Sharpe
Berlex Labs




                      Douglas Currell
                      <dlcurrell@YAHOO
                      .COM>            To:     ADSM-L AT VM.MARIST DOT EDU
                      Sent by: "ADSM:  cc:
                      Dist Stor        Subject:
                      Manager"                 Re: very very big DB!!!!
                      <[email protected]
                      T.EDU>


                      06/09/2005 10:23
                      AM
                      Please respond
                      to "ADSM: Dist
                      Stor Manager"





30 GB is not outrageously large. I've worked with one
that was almost twice that size. You can unload and
load the database or perhaps do an audit on it.
There's an entire section called utilities in the
Admin Reference. Be forewarned that an audit could
take days if not weeks...!!!
--- Mario Di Pede <mario.dipede AT GIDI DOT IT> wrote:

> Hi
> I have a TSM DB of 30 Gb - there are a utilities for
> cleaning its?????
>
> thank's all
>


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

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