> We accidentally turned on collocation.  This caused 300 scratch tapes to
> become used (e.g., status=filling).  We've turned off collocation, but now
> I want to get all those tapes back into scratch status.  We thought that
> daily space reclamation would do that for us, but that's not happening for
> these tapes... (is that cuz they're in "filling" status?).  I plan to use
> MOVE DATA (to as disk storage pool) to free up each tape unless someone has
> a better approach.  I'd like to process the tapes that have the least
> amount of data, but the PCT UTILIZED and PCT RECLAIMABLE on almost all the
> "filling" tapes show up as zeros.  So, how can I identify the tapes with
> the smallest amount of data?  Environment is 3494/3590/AIX with ADSM
> v3.1.2.20.

I don't think that it matters very much. If the percentage utilization rounds
to zero, the time required to move the data will probably be small compared to
the mounting and demounting time in any case. If you really want to pick out
the least-used tapes, I suppose you could add up the size values from 'query
content' with 'format=detailed'. In principle, you could get the same
information using the 'select' command on the 'contents' table. However, my
experience indicates that select operations against that table take too long
to be practical on a production server. You might be better off picking tapes
with the smallest number of files rather than tapes with the smallest number
of bytes, since the amount of database update activity involved in carrying
out a 'move data' command depends on the number of files to be moved.