This may help you to reduce the number of dbvols, hence begin able to reduce
size. You could also acquire another set of disks that you can move the DB
(while live) to. IE lets say you have 5 db vols, even thought you only have
20-30% utilized its probably spread across all the vols making it impossible to
reduce or consolidate on only a few volumes. What we've done to move the DB or
log vols around (consolidate) is to create new DB vols on different set of disk
then start one be one to delete the original DB volumes.
Example (TSM Will automatically move DB Data to new Vols)
Original Volumes (4 volumes + Mirrors)
/dev/vol1
/dev/vol1mir (First Del Mirrors Vols)
/dev/vol2
/dev/vol2mir (First Del Mirrors Vols)
/dev/vol3
/dev/vol4mir (First Del Mirrors Vols)
/dev/vol4
/dev/vol4mir (First Del Mirrors Vols)
Once you have deleted the Mirrors (they wont move you have to do a db copy once
you move primary volumes.
Start to delete the Primary Vol1, it will move to the new vol01 proceed with
the rest. Once the primaries are done you can do you db dopy's to the mir
volumes.
New Vols (2 volumes + Mirrors)
/dev/vol01
/dev/vol01mir
/dev/vol02
/dev/vol02mir
Once this is all done you should be able to reduce the db further. If some one
see's an issue with this process please let me know.
Regards,
Charles
-----Original Message-----
From: French, Michael [mailto:Michael.French AT SAVVIS DOT NET]
Sent: Monday, January 05, 2004 10:33 PM
To: ADSM-L AT VM.MARIST DOT EDU
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.
##############################################################
|