Nicholas try this: select copy1_name, avail_space_mb from dbvolumes where copy2_name is null
It worked for me from the web interface. Raminder Braich SAP/ORACLE/TSM DBA The Davey Tree Expert Company Kent, OH 44240 330-673-9515 Ext 270 -----Original Message----- From: Nicholas Cassimatis [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 6:09 PM 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.
