I use the following select statement in a server script for figuring out this
kind of information (was more useful in 5.5 and earlier when the REMARKS
field had nice descriptions for each field, too):

   select colname from columns where tabname=upper('$1')

In this case:

   tsm: SERVER>run tbl-desc volumes
   ...
   COLNAME: READ_ERRORS
   ...
   COLNAME: WRITE_ERRORS
   ...

As with the mount count, the error counts and many other values for a volume
are lost/reset when it returns to scratch.

=Dave


On 07/28/2016 10:42 AM, Lamb, Charles P. wrote:
> Would anyone know what the volume I/O error table labels are so the below 
> script could be run on volume I/O errors??
>
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf 
> Of Lee, Gary
> Sent: Thursday, July 28, 2016 10:21 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: [ADSM-L] Re: TSM script for the number of tape mounts per tape 
> volume
>
> Yes, mount count resets to zero when it returns to scratch.
>
>
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf 
> Of David Bronder
> Sent: Thursday, July 28, 2016 11:11 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: [ADSM-L] Re: TSM script for the number of tape mounts per tape 
> volume
>
> Charles,
>
> Note that this number may not mean what you expect it to.  The help for 
> "query volume" notes that this value is the number of times the server opened 
> the volume, which may be more than once per physical mount.  Also, if you use 
> scratch tapes, I'm pretty sure that the value gets discarded when the tape 
> returns to the scratch pool and resets to zero when it's defined to a storage 
> pool again.
>
> =Dave
>
>
> On 07/28/2016 08:45 AM, Koos Rietveld wrote:
>> select char(volume_name, 30) as VOLUME_NAME, times_mounted from
>> volumes where stgpool_name='VDP-DAT' order by times_mounted desc
>>
>>
>>
>> From:        "Lamb, Charles P." <cplamb AT NPPD DOT COM>
>> To:        ADSM-L AT VM.MARIST DOT EDU
>> Date:        28-07-2016 15:27
>> Subject:        [ADSM-L] TSM script for the number of tape mounts per tape
>> volume
>> Sent by:        "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>>
>> ----------------------------------------------------------------------
>> -------
>>
>>
>>
>> Hi...............
>>
>> Could someone share a TSM script for the number of tape mounts per
>> tape volume from highest to lowest??  Tnx's a bunch........
>>
>>
>
>

--
Hello World.                                David Bronder - Systems Architect
Segmentation Fault                                      ITS-EI, Univ. of Iowa
Core dumped, disk trashed, quota filled, soda warm.   david-bronder AT uiowa 
DOT edu