To: <<mailto:ADSM-L AT VM.MARIST DOT EDU>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
<fontfamily><param>Arial</param>>G'day,
>
>You can also do:
>
>dsmadmc -serv=someserv -id=xxx -pass=yyy -tabdelimited q stg f=d
>
>or
>
>dsmadmc -serv=someserv -id=xxx -pass=yyy -commadelimited q stg f=d
>
>or
>
>use the 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
'(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' -
> | paste -s -d' \n' -
> 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 3590DEVC 0.0 0.0 0.0 90 70
>10YRARCH 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 DISK 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
</fontfamily></excerpt><fontfamily><param>Arial</param>
</fontfamily>
Richard C. Dempsey email: dempsey AT kodak DOT com
Public Online Services pager: 716-975-3539
11th Floor, Bldg 83, RL phone: 716-477-3457
Eastman Kodak Company fax: 716-722-3885
Rochester, NY 14650-2203
|