It is different from DBBackup - there are specific load/unload abilities
in TSM. The process results in the DB being re-orged. We recently went
through the process and approximatley halved  the size of our 120GB DB,
the gain is fairly short lived though. The re-org was around 8 weeks ago
and the DB is back up to 80% of its original size.


Matt.

Computer says 'No'..

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Lawrence Clark
Sent: Thursday, June 09, 2005 3:33 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: very very big DB!!!!

unload / load? you mean backup then restore. will that reorg the db?

>>> dlcurrell AT YAHOO DOT COM 06/09/2005 10:23:23 AM >>>
30 GB is not outrageously large. I've worked with one
that was almost twice that size. You can unload and
load the database or perhaps do an audit on it.
There's an entire section called utilities in the
Admin Reference. Be forewarned that an audit could
take days if not weeks...!!!
--- Mario Di Pede <mario.dipede AT GIDI DOT IT> wrote:

> Hi
> I have a TSM DB of 30 Gb - there are a utilities for
> cleaning its?????
>
> thank's all
>


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com



___________________________ Disclaimer Notice __________________________
This message and any attachments are confidential and should only be read by 
those to whom they are addressed. If you are not the intended recipient, please 
contact us, delete the message from your computer and destroy any copies. Any 
distribution or copying without our prior permission is prohibited.

Internet communications are not always secure and therefore Powergen Retail 
Limited does not accept legal responsibility for this message. The recipient is 
responsible for verifying its authenticity before acting on the contents. Any 
views or opinions presented are solely those of the author and do not 
necessarily represent those of Powergen Retail Limited. 

Powergen Retail Ltd is authorised and regulated by the Financial Services 
Authority for the sale and service of general insurance products.

Registered addresses:

Powergen Retail Limited, Westwood Way, Westwood Business Park, Coventry, CV4 
8LG.
Registered in England and Wales No: 3407430

Telephone +44 (0) 2476 42 4000
Fax +44 (0) 2476 42 5432