Shekhar,
are the cases o.k.? I bet, it should look like
select count (*) from volumes where devclass_name='STK9710'
^^^
Regards,
Reinhard
Shekhar Dhotre writes:
> 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?
> ---------------------------------
>
>
>
>
>
> "[EMAIL PROTECTED]/P=Internet/A= /C=us" on 09/19/2000 01:23:01 PM
> Please respond to "[EMAIL PROTECTED]/P=Internet/A= /C=us" @ X400
> To: "[EMAIL PROTECTED]/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
--
Reinhard Mersch Westfaelische Wilhelms-Universitaet
Zentrum fuer Informationsverarbeitung - ehemals Universitaetsrechenzentrum
Roentgenstrasse 9-13, D-48149 Muenster, Germany Tel: +49(251)83-31583
E-Mail: [EMAIL PROTECTED] Fax: +49(251)83-31653
