I'm on the right path, I think.  It's all right there in the dbvolumes, I
just can't get the info to come out right.  I want to find out how large
the unmirrored volumes are, so I can go get the space to mirror them.  I've
tried:

tsm: SERVER>select copy1_name,avail_space_mb from dbvolumes where
copy2_name not like '/%'

tsm: SERVER>select copy1_name,avail_space_mb from dbvolumes where
copy2_status not like 'Sync%'    (can't do the - 'd -  in there, not sure
how to get past that)

tsm: SERVER>select copy1_name,avail_space_mb from dbvolumes where
copy2_name=''

Plus a few variations on those themes, and all I get is the proverbial:

ANR2034E SELECT: No match found using this criteria.
ANS8001I Return code 11.

(And yes, I have unmirrored DB volumes on this machine)

I'm missing some fundamental thing here, (along with my SQL guru to a
vacation...).  Can someone point me in the right direction?  Thanks!

Nick Cassimatis
nickpc AT us.ibm DOT com

Today is the tomorrow of yesterday.