Re: Logmode rollforward and incr/full dbbackups

[Warren, Matthew James]

Hello TSM'ers



I am trying to run the following simple SQL query


select db.pct_utilized,log.pct_utilized,(select count(*) from volumes where
access='READONLY'),(select count(*) from volumes where access='UNAVAILABLE')
from db,log


The above works fine, but if I add 'as' into it like so;


select db.pct_utilized,log.pct_utilized,(select count(*) as 'READONLY' from
volumes where access='READONLY'),(select count(*) as 'UNAVAILABLE' from
volumes where access='UNAVAILABLE') from db,log

I get an unexpected literal SQLtoken. Am I worng in how I am writing the
'as' statements?

Also, if I extend the top command to read

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



(the last bracketed select is simply repeated again)

I get nothing but a return code 3 from TSM.


Am I wildy innacurate with my SQL selects, or are there some 'odd
limitations' to TSM's pseudo-select queries.


Thanks,

Matt.