Reinhard,
I think the process may be different or improved under 3.7
I have tried it on our much smaller development TSM database
where I saw :-
Before, the load/reload Total Usable Pages: 607,232 Used Pages: 304,812
After, the load/reload Total Usable Pages: 608,256 Used Pages: 177,578
So the compress was significant and in this case the unload took 9 minutes and
the
load 15 minutes, and that is what I based my 6 hour estimate on, but it is a
lot smaller than my production TSM and I was not sure how safe it was to
extrapolate from such a small database.
As far as the performance gain, I must admit I tend to agree with you, certainly
for backups and
the normal small restores. I am not a database expert, but I suppose it may be
different for large restores.
Any database or os390 gurus out there ?
John
Reinhard Mersch <mersch AT UNI-MUENSTER DOT DE> on 11/08/2000 01:32:46 PM
Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
cc: (bcc: John Naylor/HAV/SSE)
Subject: Re: Unload /Reload timings and efficacy
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
**********************************************************************
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.
**********************************************************************
|
