ADSM-L

Re: Format of output file using select statements

2003-01-07 04:20:29
Subject: Re: Format of output file using select statements
From: Roger Deschner <rogerd AT UIC DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 6 Jan 2003 23:33:54 -0600
Neither of these formats, which were designed to be human-readable, are
particularly easy for re-digestion by a computer program of any kind -
especially when a field is split across lines. Why not use:

  dsmadmc -id=myadmin -pa=xxxxx -comma -outfile=kumquat.cdf q ac
                   -or-
  dsmadmc -id=myadmin -pa=xxxxx -tab -outfile=kumquat.tdf q ac

...depending upon whether it is easier for you to read comma-delimited
or tab-delimited format. I myself read the output from dsmadmc -comma
into SPSS regularly. Piece of cake with SPSS, Excell, Access, etc., or
your own program, and so much easier than picking apart something that
was meant to be read by humans.

Roger Deschner      University of Illinois at Chicago     rogerd AT uic DOT edu
==="If a train station is where a train stops, what's a work station?"==


On Mon, 6 Jan 2003, Andrew Raibeck wrote:

>You can use -DISPLAYMODE=blah option on the dsmadmc command line to force
>the desired format, where 'blah' is either TABLE or LIST, i.e.:
>
>   dsmadmc -id=myadmin -pa=xxxxx -displaymode=list q ac
>
>or
>
>   dsmadmc -id=myadmin -pa=xxxxx -displaymode=table q ac
>
>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.eyebm DOT com (change eye to i to reply)
>
>The only dumb question is the one that goes unasked.
>The command line is your friend.
>"Good enough" is the enemy of excellence.
>
>
>
>
>Andy Carlson <andyc AT ANDYC.CARENET DOT ORG>
>Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>01/02/2003 15:21
>Please respond to "ADSM: Dist Stor Manager"
>
>
>        To:     ADSM-L AT VM.MARIST DOT EDU
>        cc:
>        Subject:        Format of output file using select statements
>
>
>
>I figure this has something to do with running in a terminal or not.  I
>run the following command:
>
>/usr/local/bin/tsmua -outfile=xx run qact.rep
>
>When I run this on a terminal, it returns a format like:
>
> DATE_TIME: 2003-01-01 16:30:00.000000
>     MSGNO: 402
>  SEVERITY: I
>   MESSAGE: ANR0402I Session 73102 started for administrator TS55428
>(AIX)
>             (ShMem).
>ORIGINATOR: SERVER
>  NODENAME:
> OWNERNAME:
> SCHEDNAME:
>DOMAINNAME:
>    SESSID:
>SERVERNAME:
>
>
>but, when I run it from cron, it looks like this:
>
>         DATE_TIME           MSGNO               SEVERITY     MESSAGE
>ORIGINATOR             NODENAME               OWNERNAME
>SCHEDNAME              DOMAINNAME                  SESSID     SERVERNAME
>------------------     -----------     ------------------
>------------------     ------------------     ------------------
>------------------     ------------------     ------------------
>-----------     ------------------
>        2003-01-01             402                      I     ANR0402I
>Session       SERVER
>   16:20:00.000000                                             73098
>started for
>
>Any ideas how I can control this?  I would like scripts to behave the
>same, whether I run them from the terminal, or from cron.  Server is
>5.1.5.4.  Thanks.
>
>Andy Carlson                                    |\      _,,,---,,_
>Senior Technical Specialist               ZZZzz /,`.-'`'    -.  ;-;;,_
>BJC Health Care                                |,4-  ) )-,_. ,\ (  `'-'
>St. Louis, Missouri                           '---''(_/--'  `-'\_)
>Cat Pics: http://andyc.dyndns.org/animal.html
>