Tsm server v5.1.6.2 on solaris 2.8.  Have a magstar 3494 with approximately
1500 slots.
I would like to be able to count how many tapes we are using in onsite
pools, offsite pools, db backups, and scratches.

Got the on and offsite count easily enough.  I also have a script for
counting scratches.
Is there a way in SQL to save the output of selects, then some them to reach
a final value?

>> Only via arithmetic in the SQL, if you are running a straight TSM script
and not a host script.

This works for me; you will have to doctor it a little to match your own
class names:

select -
    count(distinct a.volume_name) + count(distinct b.volume_name) +
count(distinct c.volume_name) -
    as "Tapes in Use "  -
    from volumes a, libvolumes b , volhistory c -
    where a.devclass_name <> 'DISK' and -
    b.status='Scratch' and -
    c.type in ('BACKUPFULL','DBSNAPSHOT','BACKUPINCR','EXPORT') and -
    c.devclass = 'LTOTAPE'

Wanda Prather
Johns Hopkins University Applied Physics Laboratory
443-778-8769

"Intelligence has much less practical application than you'd think" -
Dilbert/Scott Adams