Re: What's the best way to uncollocate?
2000-02-17 16:46:33
Hi Bob,
MOVE DATA is certainly the answer. The only possible variation to your approach
would be to do the move from tape to tape. I'd set all of the tapes that you
want to do a move on to READONLY as a first step. If the % utilised is zero
then you have very little data on the tape anyway so it probably doesn't matter
much which order you do it in.
You can found out how much data is on each tape by doing something like:
select count(*),sum(file_size) from contents where
volume_name='volume-name'
Trevor
|
|
|