ADSM-L

Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS

2002-04-01 11:00:25
Subject: Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
From: "Mr. Lindsay Morris" <lmorris AT SERVERGRAPH DOT COM>
Date: Mon, 1 Apr 2002 10:45:21 -0500
We have a short article and a couple of scripts that will help you clean up
TSM query output so you can work on it with grep / awk / spreadsheets, etc.
See
http://www.servergraph.com/techtip.shtml


----------------------------
Mr. Lindsay Morris
Mr. Lindsay Morris
CEO
Applied System Design
www.servergraph.com
859-253-8000 ofc
425-988-8478 fax



> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
> MC Matt Cooper (2838)
> Sent: Monday, April 01, 2002 10:08 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
>
>
> Ike,
>         I got it to work with some help from Dennis Glover.  He sent me an
> example of something that worked.  The big difference was that the -COMMA
> option MUST BE LISTED BEFORE THE MACRO option.   So
> DSMADMC -ID=xxxxx -PA=xxxxx  -COMMA MACRO DD:D2    works fine but
> DSMADMC -ID=xxxxx -PA=xxxxx  MACRO DD:D2 -COMMA     does not!
> Matt
>
> -----Original Message-----
> From: Ike Hunley [mailto:bizzorg AT WORLDNET.ATT DOT NET]
> Sent: Thursday, March 28, 2002 5:44 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
>
> Matt,
>
> I have not found a way to get my data on one line either.  I
> input the data
> into REXX code to reformat it the way I want.  What would you like your
> output to look like? I could send you a REXX exec.
>
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
> MC Matt Cooper (2838)
> Sent: Wednesday, March 27, 2002 2:25 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
>
>
>
> I have tried everyone's suggestions.  I believe the fact that I
> have one  AS
> statement in the script that it will ignore the attempts of fixing the
> output into a 1 line per node output.  The -COMMAdelimited ,
> -TABdelimited,
> -OUT didn't work.   I was able to get a 1 line output, with a
> title line and
> some other 'extra' lines of TSM header and msgs.   The only way I seem to
> have in controlling this is with the suggestion from Paul, using an AS "
> big area  " .   This whole 'programming' area seems to go by a lot of
> undocumented rules.  Why don't they document them somewhere?  Or give a
> direct reference to which other product doc to look at?   I am able to
> directly control the length of a numeric output with 'decimal(xx)'
> statement.  What about character output?   I am still disappointed that I
> can not seem to get an output that would be nothing more than
> what I really
> want 12 character node name delimiter 4 digit number of days since last
> access  delimiter   contact field name of 20 characters,    then the next
> line .... . The best I came up with is as follows.
> SCRIPT...
>
> select node_name as "NODE", -
>   cast((current_timestamp-lastacc_time)days as decimal(4)) as "DAYS", -
>  contact as "           CONTACT              "  from nodes where -
>   cast((current_timestamp-lastacc_time)days as decimal) >= 7
>
> OUTPUT FILE .....
>
> ADSTAR Distributed Storage Manager
>
> Command Line Administrative Interface - Version 3, Release 1, Level 0.7
>
> (C) Copyright IBM Corporation, 1990, 1999, All Rights Reserved.
>
>
>
> ANS8000I Server command: 'select node_name as "NODE",
> cast((current_timestamp-
>
>
> NODE                        DAYS                CONTACT
>
> ------------------                 ------
> --------------------------------
> AG570                          58     Elliott/desktop
>
> DEFIANT                      12     R.Schulte, D.Harrison
>
> DSS1OLD                    343     Connie Brooks
>
> WIN2KAD                     34     Karlene Michael
>
> ANS8000I Server command: 'COMMIT'
>
>
>
> ANS8002I Highest return code was 0.
>
>
> -----Original Message-----
> From: Seay, Paul [mailto:seay_pd AT NAPTHEON DOT COM]
> Sent: Wednesday, March 27, 2002 11:13 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
>
> That will help, but you can also do the AS "[ lots of spaces ]"
> to lengthen
> the output field.  What we really need is a set displaymode=fixedraw.
>
> This is an example of something that I do:
>
> select stgpool_name as "Storage Pool Name         ",
> cast(sum(est_capacity_MB*pct_utilized/100/1024) as decimal(7,3)) as "Total
> GB in Pool", cast(avg(est_capacity_MB*pct_utilized/100/1024) as
> decimal(7,3)) as "AVG GB / Tape", cast(count(volume_name) as decimal(4,0))
> as "Tapes " from volumes where stgpool_name like 'CPY%' or
> stgpool_name like
> 'TAPE%' group by stgpool_name
>
> Notice that he stgpool_name field is lenghtened to prevent the wrap by
> adding the spaces.
>
> -----Original Message-----
> From: Rejean Larivee/Quebec/IBM [mailto:rlarivee AT CA.IBM DOT COM]
> Sent: Wednesday, March 27, 2002 10:46 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
>
>
> Hello Matt,
> remove the -TAB and use -DISPLAY=LIST instead.
> I believe this is what you are looking for.
>
> -----------------------------------------------------------------
> Rejean Larivee
> IBM TSM/ADSM Level 2 Support
>
>
>
>
>                       "MC Matt Cooper
>                       (2838)"                   To:
> ADSM-L AT VM.MARIST DOT EDU
>                       <Matt.Cooper@AMGRE        cc:
>                       ETINGS.COM>               Subject:  Re: NEED HELP
> CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
>                       Sent by: "ADSM:
>                       Dist Stor Manager"
>                       <[email protected].
>                       EDU>
>
>
>                       03/27/2002 11:00
>                       AM
>                       Please respond to
>                       "ADSM: Dist Stor
>                       Manager"
>
>
>
>
>
> Ike,
>         I am running the following batch job.  I added the  -TAB and tried
> -OUTFILE with a redirect in the macro to the data set and that didn't work
> either.  So I tried a few different variation of the above and even went
> back to adding a / after the ADSMC as the book says.  None of it made a
> difference.  It always came back with the output looking the
> same.  Ideally
> I would want just the needed fields, with fixed length 1 per line. Matt
>
> THE JOB.....
>
> //TSMJOB1  EXEC PGM=IKJEFT01
> //STEPLIB  DD   DSN=SYS1.CEE.SCEERUN,
> //             DISP=SHR
> //DSCLANG  DD DSN=SYS1.TSM.SANSMSG(ANSMENU),DISP=SHR
> //DSCOPT   DD DSN=AGPP.TSM.TSOADMIN.OPTIONS,DISP=SHR
> //SYSHELP  DD DSN=SYS1.TCPIP.SEZAHELP,DISP=SHR
> //SYSIN  DD  DUMMY
> //D1  DD  DSN=AGPP.TSM.INACTIVE.NODES,DISP=SHR
> //SYSTSIN DD *
> DSMADMC -ID=ADMINJOB -PASSWORD=xxxxxxxx -OUTFILE=DD:D1 MACRO
> DD:D2 -TAB //D2
> DD * select node_name,lastacc_time,contact from nodes where -
>   cast((current_timestamp-lastacc_time)days as -
>   decimal) >= 7
>
> /*
> //SYSTSPRT  DD SYSOUT=*
> //SYSUDUMP DD SYSOUT=*
>
> THE OUTPUT FILE ....
>
> ADSTAR Distributed Storage Manager
>
> Command Line Administrative Interface - Version 3, Release 1, Level 0.7
>
> (C) Copyright IBM Corporation, 1990, 1999, All Rights Reserved.
>
>
>
> ANS8000I Server command: 'select node_name,lastacc_time,contact from nodes
> where
>
>
> NODE_NAME                    LASTACC_TIME            CONTACT
>
> ------------------                ------------------
> ------------------
> DTE-1710                       2002-03-15                Dan
>                           09:28:26.000000                 Harrison/Desktop
> DTE-1720                       2002-03-15                SUE
>                           23:27:49.000000                NEBINGER/DESKTOP
>
>
> -----Original Message-----
> From: Hunley, Ike [mailto:Ike.Hunley AT BCBSFL DOT COM]
> Sent: Wednesday, March 27, 2002 8:21 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
>
> Matt,
>
> What do you do to execute the select command in the z/OS environment?
>
>
>
> -----Original Message-----
> From: MC Matt Cooper (2838) [mailto:Matt.Cooper AT AMGREETINGS DOT COM]
> Sent: Wednesday, March 27, 2002 8:15 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
>
>
> Hello all,
>         I am trying to write a simple script that shows the nodes
> that were
> not accessed by TSM for more than x days and then do an E-mail
> notification
> from there.  I AM RUNNING TSM 4.1.5 on z/OS 1.1.  The select
> command to get
> the node name, last access date, and contact name (the e-mail
> address) seems
> easy enough. BUT I want the output from this to be in one line, preferably
> with fixed position or filed lengths.  ( I will be using SAS processing to
> setup the job that will actually do the EMAIL).  I have tried the approach
> documented in the 3rd chapter of the TSM Refernece manual but I
> can not get
> the desired results.  It always comes back with the output for 1 node with
> last access and contact name using two lines.   Has anyone ever had any
> success with this in OS390 environment?  I could go a long way with an
> example . Thanks Matt
>
>
>
> Blue Cross Blue Shield of Florida, Inc., and its subsidiary and affiliate
> companies are not responsible for errors or omissions in this e-mail
> message. Any personal comments made in this e-mail do not reflect
> the views
> of Blue Cross Blue Shield of Florida, Inc.
>