-----Original Message-----
From: Richard C. Dempsey <dempsey AT KODAK DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU <ADSM-L AT VM.MARIST DOT EDU>
Date: Wednesday, May 05, 1999 5:30 AM
Subject: Re: Formatting of Query Outputs

Greetings, Leo,

Where do I find a) the ODBC driver to install on my PC,
and b) documentation on how to link in the ADSM tables.
As I understand it, the issue is what to connect to at
the server end. Or does you note presume running the
ADSM server on NT? We're running on Solaris.

Thanks,
Rich

At 07:56 PM 5/4/99 +1000, you wrote:
>>>>

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: <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

>G'day,
>
>You can also do:
>
>dsmadmc -serv=someserv -id=xxx -pass=yyy -tabdelimited q stg -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 -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' -
> 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 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 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

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