Yes, you can put this in a file and call it like a macro or define a script
similar to this one I run.

I call it Q_LIBSPACE

define script q_libspace "select volume_name, stgpool_name, pct_utilized
from volumes where volume_name in (select volume_name from libvolumes)"
description='Query Library Space'

You execute the script by:


run q_libspace


It will not show Database Backup volumes or others not in the volume table.

Bill Slaughter
Tupperware