>G'day,
>
>You can also do:
>
>dsmadmc -serv=3Dsomeserv -id=3Dxxx -pass=3Dyyy -tabdelimited q stg =
f=3Dd
>
>or
>
>dsmadmc -serv=3Dsomeserv -id=3Dxxx -pass=3Dyyy -commadelimited q stg =
f=3Dd
>
>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=3Dsomeserv -id=3Dxxx -pass=3Dyyy q stg f=3Dd | 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
|