ADSM-L

Re: TSM Database Reorg

2006-08-31 13:26:27
Subject: Re: TSM Database Reorg
From: jsiegle <jsiegle AT PSU DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 31 Aug 2006 13:23:20 -0400
David Longo wrote:
How big is that DB?  This thing really works still?
tsm: DATAKEEP.CAC.PSU.EDU>q db

Available Assigned   Maximum   Maximum    Page     Total      Used   Pct  Max.
   Space Capacity Extension Reduction    Size    Usable     Pages  Util   Pct
    (MB)     (MB)      (MB)      (MB) (bytes)     Pages                  Util
--------- -------- --------- --------- ------- --------- --------- ----- -----
 479,940  398,972    80,968   119,400   4,096 102,136,8 68,015,29  66.6  66.6
                                                     32         2



Used pages used to be around 110 Million.
And 95% used!

How long does expiration take, etc, etc.?

Expiration now takes 6 hours a day tops. Large jobs now take about 1/10 of the 
time they did before.

-Jonathan

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.5509
david.longo AT health-first DOT org


Jonathan Siegle <jsiegle AT PSU DOT EDU> 08/31/06 10:52 AM >>>
Did a restore/upgradedb/unload/load onto a new AIX box while going
from
TSM 5.1 -> 5.3 . The size of the database before was 460 GB(95% used).
I
trimmed 131 GB off my db by doing the unload/load. Now this procedure
was never done before on this db and it has been running since 1990
from
what I understand.

-Jonathan Siegle

##############################################################
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>