tsm: TSM>select count (*) from volumes where devclass_name='stk9710'

 Unnamed[1]
-----------
          0

tsm: TSM>select count (*) from drmedia

 Unnamed[1]
-----------
         49

tsm: TSM>select avg(EST_CAPACITY_MB) from volumes where
devclass_name='stk9710'

                       Unnamed[1]

whats wrong with first and third query? or not applicable to stk?
---------------------------------

This is user-defined at installation/configuration.
Do a "query devclass" and see what your tapes are using.
(Case counts to select....)
Mine show:

tsm: ADSM>q devclass

Device        Device         Storage     Device        Format
Est/Max      Mount
Class         Access            Pool     Type
Capacity      Limit
Name          Strategy         Count                                  (MB)
---------     ----------     -------     ---------     ------
--------     ------
--------     ------
DISK          Random               3
DISK          Random               3
LOOPBACK      Sequential           0     SERVER
10,240.0          2
MAGSTAR3-     Sequential           7     3590          DRIVE
0.0          3
 590



on another note:

m147397@f1n01 $mtlib -?

Usage: mtlib -[acdfiklmnqstvCDV?]
Arguments: -f[filename]   device special Filename, i.e. "/dev/rmt0".
           -x[number]     device number, i.e. "518350".
           -l[filename]   Library special filename, i.e. "/dev/lmcp0".
           -q[type]       Query library information option.
                          type should be one of the following:
                               V  Volume data.
                               L  Library data.
                               S  Statistical data.
                               I  Inventory data.
                               C  Category inventory data.
                               D  Device data.
                               E  Expanded volume data.
                               K  inventory volume count data.
                               R  Reserved Category List
                               A  Category Attribute List
                               M  All Mounted Volumes
           -m             Mount option.
           -d             Demount option.
           -D             List of devices in library.
           -E             Used with -D option for expanded device list
           -c[request id] Cancel pending request option.
           -n             No wait mode.
           -i[request id] Query request id status option.
           -C             Change the category of a volume.
           -a             Audit the specifed volume.
           -k[flags]      Assign a category to a device in the Library.
                          flags should be the following:
                               O  Enable Category Order
                               C  Clear out ICL
                               G  Generate First Mount
                               A  Enable Auto Mount
                               X  Remove category assignment from drive
                               Valid combinations: OG, OA, GA, OGA
                          Loader associated with the Library.
           -r             Reserve a category
           -R             Release a category
           -S             Set category attribute
           -s[category]   Source or starting category.
           -t[category]   Target category.
           -L[list]       List of Volume serial numbers
           -V[volser]     Volume serial number
           -N[name]       Category Name Attribute to assign to category.
           -h[hostid]     host id for reserve/release category
                          or R/A option for query command
           -u             Include usage date in expanded volume data.
                          Default is ISO format with period separator.
           -F[flags]      Format and/or separator for volume usage date
                          flags can be:
                               I  ISO/Japan yyyy.mm.dd
                               E  European dd.mm.yyyy
                               U  USA mm.dd.yyyy
                               p  period separator mm.dd.yyyy
                               d  dash separator mm-dd-yyyy
                               s  slash separator mm/dd/yyyy
           -v             Verbose.
           -#[number]     Category sequence number or number of
                          categories to reserve.
           -A             Query library addresses and status
           -?             this help text.

NOTE:   The  -l argument is required.
--
Richard
Richard