Free & Used space in MBs

[tsmlover]

please correct the following commands to show the FREE and USED space of specific tape in MBs, I applied these commands on TSM V.5.4 but its not working, some santax error i got, does any buddy know the perfect command with prefrect syntax that does not give any error and simply show me the free and used space in MBs of a specific Tape



For Used Space in MBs
select volume_name, est_capacity_mb * pct_utilized / 100 from volumes
"where volume_name='mt0001'"


For Free Space in MBs
select volume_name, est_capacity_mb - (est_capacity_mb * pct_utilized / 100) from volumes "where volume_name='mt0001'"

 

[toxy13]

can you post your error?

 

[toxy13]

EDIT: select volume_name, est_capacity_mb - (est_capacity_mb * pct_utilized / 100) from volumes where volume_name='mt0001'

remove the " "