[no subject]

G'day again Trevor,

Have a go at installing the ODBC driver and link the ADSM tables to microsoft access.

Then you can create quiries and change the format of your output the way you like it.

Leo Humar
LCS Pty Ltd
lhumar AT vic.bigpond.net DOT au

No trees were killed in the sending of this message.

However a large number of electrons were terribly inconvenienced.

-----Original Message-----
From: Trevor Foley <Trevor.Foley AT BANKERSTRUST.COM DOT AU>
To: ADSM-L AT VM.MARIST DOT EDU <ADSM-L AT VM.MARIST DOT EDU>
Date: Tuesday, May 04, 1999 10:18 AM
Subject: Re: Formatting of Query Outputs

>G'day,
>
>You can also do:
>
>dsmadmc -serv=someserv -id=xxx -pass=yyy -tabdelimited q stg f=d
>
>or
>
>dsmadmc -serv=someserv f=d
>
>or
>
>dsmadmc -serv=someserv -id=xxx -pass=yyy -commadelimited q stg f=d
>
>or
>
>use the -commadelimited q stg f=d
>
>or
>
>use the SELECT SELECT command against the STGPOOLS table
>
>The "set sqldisplaymode wide" command will only make a difference if you are doing SELECT rather than QUERY.
>
>
>regards,
>
>Trevor
>
>
>-----Original Message-----
>From: Dwight Cook [mailto:decook AT AMOCO DOT COM]
>Sent: Tuesday,4 May 1999 6:12
>To: ADSM-L AT VM.MARIST DOT EDU
>Subject: Re: Formatting of Query Outputs
>
>
>     Ya want something like :
>
>      10YRARCH 3590DEVC 0.0 0.0 0.0 90 70
>      10YRARCHCP1 RMTSRV01 0.0 0.0
>      3590P1 3590DEVC 9,192,543.9 7.7 11.0 90 70
>      DISKPOOL1 DISK 71,519.0 1.2 1.2 10 0 3590P1
>      PR3590 3590DEVC 14,698,668.0 64.2 65.1 100 99
>      PRPOOL DISK 334,330.0 84.5 22.3 10 0 PR3590
>      VIRTTAPE RMTSRV05 2,547,593.9 0.1 0.2 90 70
>
>     these are the columns of a regular 'q stg' which are space
>     separated...
>
>     I did it by... (whew!)
>     #!/bin/ksh
>     dsmadmc -serv=someserv -id=xxx -pass=yyy q stg f=d | egrep -pass=yyy q stg f=d | egrep '(Storage
>     Pool '(Storage
>     Pool Name:|Device Class Name:|Estimated Capacity|Pct Util:|Pct
>     Migr:|High Mig Pct:|Low Mig Pct:|Next Storage Pool:)' | cut -d':' -f2
>     | paste -s -d'       \n' -d'       \n' -
>     -
>     exit
>
>     here is the normal exit
>
>     here is the normal stuff...
>adsm> q stg
>
>Storage      Device       Estimated    Pct    Pct High Low Next
>Pool Name    Class Name    Capacity   Util   Migr   Mig Mig Storage
>                               (MB)                 Pct Pct Pool
>----------- ---------- ---------- ----- ----- ---- --- -----------
>10YRARCH     -----------
>10YRARCH     3590DEVC           3590DEVC           0.0    0.0    0.0    90   70
>10YRARCHCP1 RNTSRV01           0.0    0.0
>3590P1       3590DEVC    9,192,543.    7.7   11.0    90   70
>                                  9
>DISKPOOL1    DISK          71,519.0    1.2    1.2    10    0 3590P1
>PR3590       3590DEVC    14,698,668   64.2   65.1   100   99
>                                 .0
>PRPOOL       DISK         334,330.0   84.5   21.6    10    0 PR3590
>VIRTTAPE     RMTSRV05    2,547,593.    0.1    0.2    90   70
>                                  9
>
>
>
>
>
>
>______________________________ Reply Separator _________________________________
>Subject: Re: Formatting of Query Outputs
>Author: Steven.Chaba (Steven_Chaba AT RGE DOT COM) at unix,mime
>Date:    5/3/99 12:30 PM
>
>
>I tried this, no difference.
>
>Have I angered the ADSM or SQL dieties?
>
>Steven.
>
>
>
>
>
>
>Leo Humar <lhumar AT VIC.BIGPOND.NET DOT AU> on 05/03/99 10:58:53 AM
>
>Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>
>To:   ADSM-L AT VM.MARIST DOT EDU
>cc:    (bcc: Steven Chaba/RG&E)
>Subject: Re: Formatting of Query Outputs
>
>
>
>
>
>G'day
>
>If you send the output to a file it will be formatted on one line.
>
>in NT the command would be "query stgpool > stgpool.txt"
>
>Leo Humar
>LCS Pty Ltd
>lhumar AT vic.bigpond.net DOT au
>
>
>-----Original Message-----
>Fr
>From: Steven Chaba <Steven_Chaba AT RGE DOT COM>
>To: ADSM-L AT VM.MARIST DOT EDU <ADSM-L AT VM.MARIST DOT EDU>
>Date: Tuesday, May 04, 1999 12:41 AM
>Subject: Formatting of Query Outputs
>
>
>>(Runing server version 3.1.1.5 on AIX.)
>>Here's a "pretty" question. When we do a "query stgpool", we get the
>>following:
>>
>>ANS8000I Server command: 'query stgpool'
>>
>>Storage         Device          Estimated       Pct       Pct     High
>>Low     Next
>>Pool Name       Class Name       Capacity      Util      Migr      Mig
>>Mig     Storage
>>                                     (MB)                          Pct
>>Pct     Pool
>>-----------     ----------     ----------     -----     -----     -----     -----     ----
>>---     ----
>>---     -----------
>>ARCHIVEPOOL     -----------
>>ARCHIVEPOOL     DISK           &nbDISK              8,672.0       1.8       1.8       90
>>70     ARCHIVETAP-
>>EPOOL
>>ARCHIVETAP-     RGE            8,075,153.       0.2       0.5       90
>>70
>> EPOOL                                  9
>>BACKUPPOOL      DISK             43,360.0      62.7      62.7       90
>>70     BACKUPTAPE-
>>POOL
>>BACKUPTAPE-     RGE            6,044,151.      48.5      70.4       90
>>70
>> POOL                                   9
>>COPYARCHIV-     RGE                   0.0       0.0
>> EPOOL
>>COPYBACKUP-     RGE            7,750,533.      14.3
>> POOL                                   0
>>
>>How do we get the various columns (especially the Estimated Capacity) to
>>not wrap, but be displayed on a single line for better readibility? I
>tried
>>the "set sqldisplaymode wide" command, but it didn't seem to make any
>>difference. This undesirable wrapping also is seen in the outputs of other
>>commands.
>>
>>TIA
>>Steven
>>
>>Steven Chaba
>>ADSM Admin(-in-Training)
>>Rochester Gas & Electric
>>Rochester, NY USA
>>716.771.2137v   771.724.8227f Steven_Chaba AT rge DOT com ------=_NextPart_000_0026_01BE9668.442CBB60-- =======================================================================