This will give you the list of backupset volumes form volhistory:

     select volume_name from volhistory  where type='BACKUPSET'

This will give you the NUMBER of backupset volumes from volhistory:

    select count(volume_name) from volhistory where type='BACKUPSET'

This will give you a list of the backupset volumes that are NOT checked in:

   select volume_name from volhistory where type='BACKUPSET' and volume_name
not in (select volume_name from libvolumes)

This will give you the NUMBER of backupset volumes that are NOT checked in:

  select count(volume_name) from volhistory where type='BACKUPSET' and
volume_name not in  (select volume_name from libvolumes)




-----Original Message-----
From: Rainer Wolf [mailto:rainer.wolf AT RZ.UNI-ULM DOT DE]
Sent: Wednesday, December 11, 2002 10:54 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: question on backupset volumes: how to count them ?


Hello,
sorry if this is often asked or I haven't found the doc...
I have the following problem:
We are using aix tsm server 4.2.2.13 and a 3494 Library with k- and j-tapes.
Backupsets of clients are created with duration of 999 and the
only device-class for backupset-voluems is the devclass of the 3494 library.
Now some of the Backupset - tapes are checked out and some are still in
the Library. Some of the online Backupset-Volumes have been once
checked out and are checked in again with status=private-
I have not found something equivalent like 'q drmed ... for
DBBackup-Volumes'
for thoe backupset-volumes.

Now i am looking for a good way to ...
... to count the total number of those 3494 Backupset volumes
  ( online OR offline )
... only to get the number of the currently checked-in backupset volumes
  in the library.
  Maybe a problem is, that some of the online backup-set-volumes
  have been once checked out and then checked in again and may appear
  just as private ( in the q libvol ... ) ?
  So do I have to combine something like 'q libvol' and 'q volhist
t=backupset'
  to get it ?
...  count the number ( online or offline  )
  of tapes depending on the node, for whom this backupset is created ?

Thanks for any help/scripts/macros :-)
Rainer


--
----------------------------------------------------------------------------
---
Rainer Wolf                                     mail:
rainer.wolf AT rz.uni-ulm DOT de
tel: ++49 731 50-22482                          fax:  ++49 731 50-22471
Computing Center, University of Ulm, Germany    web:
http://www.uni-ulm.de/urz