Hi all,

i want to see the real-utilization of tape volumes.

With this SELECT-Command I can display only the estimated capacity and the
percent-utilization, but i want to calculate the real-utilization if a tape
is in filling-status.

select est_capacity_mb, volume_name, pct_utilized from volumes where
stgpool_name='backuptape_copy' and status='FILLING' and access='OFFSITE'

Is is possible to do calculations within this select-command, or must i
read this output with another program for calculation ???
I simply want:                 est_capacity_mb * pct_utilized / 100


thanks for your help

Sabine