I use _very simple_ SQL Select statements invoked from dsmadmc -comma to
produce comma delimited output which is easily read by SPSS, which is
where I do the real trending, analysis, and reporting.

SPSS has no trouble at all doing things like matching up different
tables. For instance, matching entries in the VolHist file with the list
of Volumes and Libvols, so that when tapes disappear, I can find them
easily. (e.g. It's a Private libvol, but it's neither a Volume nor
in VolHist, nor owned by another server instance. Or if you have multiple
server instances operating out of one library, finding tapes owned by
none of the instances.)

SAS would work equally well, if you know it better. This data is easily
handled by any general-purpose statistical analysis package.

Roger Deschner      University of Illinois at Chicago     rogerd AT uic DOT edu


On Wed, 10 Nov 2004, Nancy L Backhaus wrote:

>Update...
>
>TSM - Version 5.2.3.4
>AIX Operating System - Version 5.2.2.0
>
>Thank You who all replied and the suggestions.
>
>Found the scratch tapes...we had implemented new stg pools(disk/tape) 2
>weeks ago, one of our scripts did not have all the new dr pool logic in
>it...ooops.
>
>But, my next question is regarding trending..date stamp of my tape types,
>scratch, private, on-site,off-site, unavail, reado..and would like to see
>the breakdown in my stgpools...then import it into excel...to see a graph
>at any given time to see what pools are using what tapes.  Right now I
>look at the actlog daily for issues.
>
>  I am a beginner in SQL statements(arrgghh), and just got a book on
>KornShell.   Looking to see what is recommended by other TSMers?   What
>are other AIX folks using for trending?
>
>I have this sql..which helps.
>select stgpool_name, count(*) from volumes group by stgpool_name
>
>
>
>Nancy Backhaus
>Enterprise Systems
>Backhaus.Nancy AT HealthNow DOT org
>Office: (716) 887-7979
>Cell: (716)  609-2138
>
>
>
>
>Richard Sims <rbs AT bu DOT edu>
>11/05/2004 02:07 PM
>
>
>        To:     Nancy L Backhaus <Backhaus.Nancy AT HEALTHNOW DOT ORG>
>        cc:
>        Subject:        Re: Where did my scratch tapes go?
>
>
>On Nov 5, 2004, at 1:59 PM, Nancy L Backhaus wrote:
>
>> 2 libraries - one scratch count is steady, my LTOLIB library scratch
>> count
>> is too low, privates too high.
>>
>> What is happening?   Where do I begin looking?
>
>Nancy -
>
>Try "Shrinking (dwindling) number of available scratch tapes ("tape
>leak")"
>in http://people.bu.edu/rbs/ADSM.QuickFacts to start with.
>
>    Richard
>
>
>
>
>
>CONFIDENTIALITY NOTICE: This email message and any attachments are for the 
>sole use of the intended recipient(s) and may contain proprietary, 
>confidential, trade secret or privileged information.  Any unauthorized 
>review, use, disclosure or distribution is prohibited and may be a violation 
>of law.  If you are not the intended recipient or a person responsible for 
>delivering this message to an intended recipient, please contact the sender by 
>reply email and destroy all copies of the original
>message.
>