Run
help define devclass
and look for FILE.
--
Mark Stapleton ([EMAIL PROTECTED])
-----Original Message-----
From: Helen Tam [mailto:[EMAIL PROTECTED]
Sent: Tue 1/6/2004 11:20
To: [EMAIL PROTECTED]
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 ([EMAIL PROTECTED])
>
>
>-----Original Message-----
>From: French, Michael [mailto:[EMAIL PROTECTED]
>Sent: Mon 1/5/2004 22:33
>To: [EMAIL PROTECTED]
>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: [EMAIL PROTECTED]
>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
>[EMAIL PROTECTED]
>
>
> >>> [EMAIL PROTECTED] 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.
>##############################################################
