Run
 
help define devclass
 
and look for FILE.
 
--
Mark Stapleton (stapleton AT berbee DOT com)

        -----Original Message----- 
        From: Helen Tam [mailto:hht1 AT NYU DOT EDU] 
        Sent: Tue 1/6/2004 11:20 
        To: ADSM-L AT VM.MARIST DOT EDU 
        Cc: 
        Subject: Re: Unload/LoadDB question
        
        

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