Hello,
   Pardon my ignorance, what is a file-based device class?
                                                Thanks, Helen


At 09:14 AM 1/6/2004 -0600, you wrote:

Our experience has been that deleting old dbvols does not clean up the db
like an unloaddb/loaddb does.

By all means, run the unload/load to a file-based device class. A tape
dump will take *way* too long.

--
Mark Stapleton (stapleton AT berbee DOT com)


-----Original Message-----
From:   French, Michael [mailto:Michael.French AT SAVVIS DOT NET]
Sent:   Mon 1/5/2004 22:33
To:     ADSM-L AT VM.MARIST DOT EDU
Cc:
Subject:        Re: Unload/LoadDB question
This was actually the first thing I tried.  The DB was originally 177GB
and 20% utilized.  I reduced the DB by 50GB and then deleted volumes and
mirrors.  I tried to shrink it again by another 35-40GB's, but it
complained saying that it could not be reduced by that much, that there
was not enough free table space.  I think the offline unloaddb/loaddb is
the only way to fix this:

tsm: TSM2.USSNTC6>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
---------  --------  ---------  ---------  -------  ---------  ---------
-----  -----
  136,260   119,928     16,332     16,332    4,096  30,701,56  11,396,64
  37.1   38.0
                                                            8          2


-----Original Message-----
From:   ADSM: Dist Stor Manager on behalf of David Longo
Sent:   Mon 1/5/2004 8:02 PM
To:     ADSM-L AT VM.MARIST DOT EDU
Cc:
Subject:        Re: Unload/LoadDB question
Another way to do it is live.  If your utilization is that low AND
you have the DB spread over many volumes, say 10GB in size.

Then do a "reduce DB 10000", takes generally less than a minute.
Then delete one of the dbvols that is that size.  (delete it's mirrors
first).  Any data on the volume is copied to the other dbvols and then
the one requested is deleted from TSM DB.  (This step can take an hour
or two or so depending on system load, etc.  "q pro" shows progress.

You can repeat as needed.  As I said, this can be done live without
the downtime required for DB unload/load and reduces the size of your DB.



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


>>> Michael.French AT SAVVIS DOT NET 01/05/04 08:17PM >>>
System Info:

Solaris 8
Sun E4500 w/ 4 processors & 4GB RAM
TSM 5.1.8.1
TSM DB 119GB (37.1% utilized)

        I tried shrinking the DB down to 85GB and at 100GB, ran into the
"your outta SQL table space" message.   Guess it's time for an
unloaddb/loaddb.  Any ideas at all how long I can expect this to take,
even an educated guess would be a good place to start.  Also, can I dump
the DB to a disk class I define to speed up the process (raw volume
preferably, I will do a DB backup before starting this)?  Thanks.

Michael French
Savvis Communications
IDS01 Santa Clara, CA
(408)450-7812 -- desk
(408)239-9913 -- mobile


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