Also, perhaps the index records on a tape or tapes used for the restore
has become corrupt, and the slow restore time could be due to the tape
index being rebuilt as as TSM seeks through the tape.

Matt.


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Stapleton, Mark
Sent: Tuesday, October 26, 2004 7:57 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Poor restore performance Windows-client

From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On 
Behalf Of Mike Hagery
>Last week we did a restore of 15 MB and 4000 small html-files. 
>The performance was bad, it took 57 minutes to restore the 
>4000 html-files and 15 MB.
>
>The back-up is very fast. FTP between client and server is 
>also fast. A restore of a big(ger) file is no problem. 
>Collocation is on and data is only on one tape. During restore 
>we see no mediawaits, so that's not the problem.

Try this select statement:

select distinct volume_name from volumeusage where
stgpool_name='PRIMARYSTORAGEPOOL' and node_name='YOURNODENAME'

All node and storagepool entries must be in uppercase. This will tell
you how many tapes you'd have to mount to restore an entire node's worth
of data.

Your restore problem probably stems from how scattered your data is
across your primary storage pool. It has nothing to do with database
fragmentation.

--
Mark Stapleton (stapleton AT berbee DOT com)
Berbee Information Networks
Office 262.521.5627  


___________________________ 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. 

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