ADSM-L

Re: ADSM concern on Database size.

2001-04-03 16:57:01
Subject: Re: ADSM concern on Database size.
From: Steffan Rhoads <arhoads AT PACBELL DOT NET>
Date: Tue, 3 Apr 2001 13:56:21 -0700
Bill,

how quickly does your 121GB db backup & restore?  How long does reclamation
run?

Steffan

At 12:52 PM 4/3/2001 -0400, you wrote:
David - I am running tsm 3.7.4 on os/390 r6.  I do have a much bigger
database.
It has continued to perform well.  Here is a 'q bd'  --
adsm> q db f=d

          Available Space (MB): 121,888
        Assigned Capacity (MB): 121,888
        Maximum Extension (MB): 0
        Maximum Reduction (MB): 12,008
             Page Size (bytes): 4,096
            Total Usable Pages: 31,203,328
                    Used Pages: 28,128,310
                      Pct Util: 90.1
                 Max. Pct Util: 90.2
              Physical Volumes: 52
             Buffer Pool Pages: 65,536
         Total Buffer Requests: 100,564,851
                Cache Hit Pct.: 98.06
               Cache Wait Pct.: 0.00
           Backup in Progress?: No
    Type of Backup In Progress:
  Incrementals Since Last Full: 2
Changed Since Last Backup (MB): 1,152.03
            Percentage Changed: 1.05
Last Complete Backup Date/Time: 04/02/2001 15:36:25


As to worrying about db restore times, as always, it depends.  How fast is
your cpu and disk subsystem?  What restore time is expected? Demanded?
If you can get the disk space for a short time, you can create a new
instance of
tsm and restore your production db into it to practice db restores.


--
--------------------------
Bill Colwell
C. S. Draper Lab
Cambridge, Ma.
bcolwell AT draper DOT com
--------------------------



In <OF26F5AAE2.D76B8B53-ON85256A23.00532334 AT humana DOT com>, on 04/03/01
   at 12:52 PM, "David Browne." <dbrowne AT HUMANA DOT COM> said:

>One of our ADSM databases runs on  OS/390 2.10  and is 44GB.
>Does anybody have a recommendation for how big you should let the database
>get?
>Does anyone have one on OS/390 that's much bigger?
>Is there a limit on the size?
>I'm concerned about the length of time it would take to recover.
> Are there other considerations?
<Prev in Thread] Current Thread [Next in Thread>