John,

from my experience with ADSM 3.1.2 on AIX, I do not think that it can
be done within 12 hours. The DUMPDB is quite fast, but the LOADDB takes
a lot of time (more in the order of days than hours). And it may require
much more space than the original 18 GB.

But again, this is my ADSM 3.1.2 experience. Perhaps things are totally
different with TSM 3.7. I would love to hear that they are, but nobody could
assure me so far.

Even more, I tend to doubt the wisdom of that recommendation. I never
heard, that performance problems could be resolved by a DB reorganization.

Reinhard

John Naylor writes:
 > Hi,
 > I have been recommended a compress of the database ie. unload/reload as a 
 > cure
 > for
 > slow restores with large Novell data servers.
 > Has anybody been through this,  and can confirm my estimate of 6 hours approx
 > for the unload reload part of thr process.
 > We are OS390, TSM 3.7.20.0
 > The database is 84.5% occupied of 18.1gb   8 logical volumes ie :
 > Total Usable Pages: 4,764,672      Used Pages: 4,027,026
 >  Also any feelings on whether this is likely to make a real impact on the
 > database access
 > element of the restores.
 > Thanks, John
 >
 > Has anybody been there, done it, got the figures.
 > I am looking for a nice warm feeling. I cannot have TSM unavailable for more
 > than 12 hours
 > max.
 > Thanks
 >
 >
 > **********************************************************************
 > The information in this E-Mail is confidential and may be legally
 > privileged. It may not represent the views of Scottish and Southern
 > Energy plc.
 > It is intended solely for the addressees. Access to this E-Mail by
 > anyone else is unauthorised. If you are not the intended recipient,
 > any disclosure, copying, distribution or any action taken or omitted
 > to be taken in reliance on it, is prohibited and may be unlawful.
 > Any unauthorised recipient should advise the sender immediately of
 > the error in transmission.
 >
 > Scottish Hydro-Electric and Southern Electric are trading names of
 > Scottish and Southern Energy Group.
 > **********************************************************************

--
Reinhard Mersch                        Westfaelische Wilhelms-Universitaet
Reinhard Mersch                        Westfaelische Wilhelms-Universitaet
Zentrum fuer Informationsverarbeitung - ehemals Universitaetsrechenzentrum
Roentgenstrasse 9-13, D-48149 Muenster, Germany      Tel: +49(251)83-31583
E-Mail: mersch AT uni-muenster DOT de                       Fax: 
+49(251)83-31653