Re: Determining Capacity on ADSM?
2000-09-19 13:59:10
tsm: TSM>select count (*) from volumes where devclass_name='stk9710'
Unnamed[1]
-----------
0
0
tsm: TSM>select count (*) from drmedia
Unnamed[1]
-----------
49
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?
---------------------------------
"DDA.RFC-822=ADSM-L AT VM.MARIST DOT EDU/P=Internet/A= /C=us" on 09/19/2000
01:23:01 PM
"DDA.RFC-822=ADSM-L AT VM.MARIST DOT EDU/P=Internet/A= /C=us" on 09/19/2000
01:23:01 PM
Please respond to "DDA.RFC-822=ADSM-L AT VM.MARIST DOT EDU/P=Internet/A= /C=us"
@ X400
To: "DDA.RFC-822=ADSM-L AT VM.MARIST DOT EDU/P=Internet/A= /C=us"@X400
cc:
Subject: Re: Determining Capacity on ADSM?
>How do I determine how many physical slots my 3494 library has?
mtlib -l /dev/lmcp0 -qL | grep cells
>How do I determine how many tapes are offsite?
a) select count(*) from volumes where stgpool_name='BACKUP3590_OFFSITE'
(where a storagepool is used for offsite.)
b) select count(*) from drmedia
(where DRM is in use.)
c) select count(*) from volumes where access='OFFSITE'
(where you set the access or use DRM.)
Note: tapes may be in transit to-and-from offsite.
Also, db backups are not in the volume table.
>How do I determine how many tapes total I have?
select count(*) from volumes where devclass_name='MAGSTAR3590'
(where your device class name is MAGSTAR3590.)
>How do I determine the average capacity per tape?
>
select avg(EST_CAPACITY_MB) from volumes where devclass_name='MAGSTAR3590'
--
Richard
Richard
|
|
|