Johnn,
Run this select:
select stgpool_name, maxscratch from stgpools
Then run this one:
select stgpool_name, -
count(*) as qty -
from volumes -
where scratch='Yes' -
group by stgpool_name
Compare the QTY shown for each storagepool in the second query with the
value shown by the first query.
My guess is that you will find that one or more of your storagepools have
hit the wall of the number of allowable scratch tapes defined for that
storagepool. You can increase the value by issuing the command "upd stg
{stgpoolname} maxscr={bignumber}"
HTH,
Ted
