Hi. Tricky... I don't know why the not like is not working, but you should try: select copy1_name,avail_space_mb from dbvolumes where copy2_status is null
It will do the job. Ran. -----Original Message----- From: Nicholas Cassimatis [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 12:09 AM To: [EMAIL PROTECTED] Subject: Help with select for non-mirrored database volumes 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.
