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