>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
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