(Apologies. Re-Send with correct subject line)
In addition to what I said below, the following statement generates a return
code 3 from TSM;
select db.pct_utilized,log.pct_utilized,(select count(*) from volumes where
access='READONLY'),(select count(*) from volumes where
access='UNAVAILABLE'),(select count(*) from volumes where
access='UNAVAILABLE') from db,log
but If I change the end very slightly to
select db.pct_utilized,log.pct_utilized,(select count(*) from volumes where
access='READONLY'),(select count(*) from volumes where
access='UNAVAILABLE'),(select count(*) from volumes) from db,log
(removing the : "where access='UNAVAILABLE'")
It works fine!
Is it me, or TSM?
Thanks,
Matt.
|