Re: Different display of output from query

Use the -DISPLAYMODE=LIST option when invoking dsmadmc, i.e.:

   dsmadmc -id=myid -password=xxxxxx -displaymode=list etc....

See the TSM Administrators Reference, Chapter 3. section "Using
Administrative Client Options" for more info.

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.




Suad Musovich <s.musovich AT AUCKLAND.AC DOT NZ>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
10/14/2002 12:15
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Re: Different display of output from query



It's probably adjusting to the narrow frame width of the browser.

Redirect to a file (" > filename") and look at the output. Not sure if
you can do this with a browser

You can also run a commandline script and use the -commadelimited flag.

Cheers, Suad
--

On Tue, 2002-10-15 at 07:27, brian welsh wrote:
> Hello,
>
> AIX 5.1, TSM-server 4.2.2.8
>
> When I execute command 'select * from auditocc' (without quotes) from
> command-line in Administrator Web-Interface it gives following output:
> NODE_NAME: CLIENT
> BACKUP_MB: 1000
> BACKUP_COPY_MB: 0
> ARCHIVE_MB: 0
> ARCHIVE_COPY_MB: 0
> SPACEMG_MB: 0
> SPACEMG_COPY_MB: 0
> TOTAL_MB: 1000
> and so on
>
> When I execute same command from Administrator Command Line, it gives
> sameoutput:
> tsm: SERVER>select * from auditocc
>
> But when I redirect output of command within AIX-script to a file, it
gives
> following output:
> NODE_NAME  BACKUP_MB  BACKUP_COPY_MB  ARCHIVE_MB  ARCHIVE_COPY_MB .....
> ---------  ---------  --------------  ----------  --------------- .....
> CLIENT      1000            0             0             0          aso
>
> The script is displaying the output in horizontal way in stead of
displaying
> it in vertical way.
> For some reasons I want to execute the command within a script and
redirect
> output to a file, but I want the same kind of output it gives when I
execute
> the command from command-line Administrator Web-Interface or
Administrator
> Command Line. I guess maybe it's a missing parameter.
>
> I hope that someone can give me a hint.
>
> Regards,
>
> Brian