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 [EMAIL PROTECTED] Today is the tomorrow of yesterday.
