|
Re: LIBVOL Scratch Count
2005-04-21 11:21:29
Make a note of the casing of the word "Scratch" in your SELECT statement
(don't ask me why it is in mixed case...).
Regards,
Andy
Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com
The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 2005-04-21
07:56:05:
> Hello Everyone!
>
> I am trying to get a count of how many scratch tapes I have in NASLIB. I
> issue the following command, but it comes up with 0. Would you happen
to
> know what I am doing wrong? Thanks!
>
> select count(*) as "NAS Scratch Tape Count" from libvolumes where
> library_name='NASLIB' and status='SCRATCH'
>
> Library Name Volume Name Status Owner Last Use Home E
> Device
> lement
Type
>
> ------------ ----------- ---------- ---------- --------- -------
> ------
> NASLIB N00000 Scratch
>
> NASLIB N00001 Scratch
>
> NASLIB N00002 Scratch
>
> NASLIB N00003 Scratch
>
> NASLIB N00004 Scratch
>
> NASLIB N00005 Scratch
>
> NASLIB N00006 Scratch
>
> NASLIB N00007 Scratch
>
> NASLIB N00010 Private Data
>
> NASLIB N00017 Scratch
>
> NASLIB N00018 Scratch
>
> NASLIB N00019 Scratch
>
> NASLIB N00020 Scratch
>
> NASLIB N00021 Scratch
>
> NASLIB N00022 Scratch
>
> NASLIB N00023 Scratch
>
> NASLIB N00024 Scratch
>
> NASLIB N00025 Scratch
>
> NASLIB N00026 Scratch
>
> NASLIB N00027 Scratch
>
>
> ********************************
> Joni Moyer
> Highmark
> Storage Systems
> Work:(717)302-6603
> Fax:(717)302-5974
> joni.moyer AT highmark DOT com
> ********************************
|
|
|
