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