Greetings,
I run the TSM Administrative Command line interface on Windows. I use
batch/command files to perform a number of functions. I could use some help
in formatting the output of the SQL SELECT statement.
In this case, what I am trying to do is track tape drive utilization in
order to better understand the impact of the TSM administrative schedules
like storage pool backup and reclamation. So, I start with this SQL select
statement:
select date_time,message from actlog where msgno in (8337,8468)
and the results look like this:
DATE_TIME MESSAGE
------------------ ------------------
2001-01-02 ANR8337I 3590
00:02:54.000000 volume K20252
mounted in drive
3590DRIVE2
(/dev/rmt2).
Now I need to set SQLDISPLAYMODE wide and use the SELECT variable_name AS
option to try to spread this out. So, I use redirection in Windows to pump
multiple commands into DSMADMC to issue a SET SQL DISPLAYMODE WIDE command
before the SQL SELECT command. I also change the SELECT to select MESSAGE AS
and the results are:
set sqldisplaymode wide
select date_time,message as "Message_text_________________________" from
actlog where msgno in (8337,8468)
DATE_TIME: 2001-01-02 00:02:54.000000
Message_text_________________________: ANR8337I 3590 volume K20252 mounted
in
drive 3590DRIVE2 (/dev/rmt2).
I must add that while this is running, not only is the output being
redirected into a file but I am also seeing it scroll on the monitor.
Well, this isn't quite right, so I use the -displaymode=table option on
DSMADSC and I get:
set sqldisplaymode wide
select date_time,message as "Message_text_________________________" from
actlog where msgno in (8337,8468)
DATE_TIMEMessage_text_________________________
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
------------------------------------------------
2001-01-02 00:02:54.000000ANR8337I 3590 volume K20252 mounted in drive
3590DRIVE2 (/dev/rmt2).
A little bit better, but strange. Am I the only one that is struggling with
this SQL formatting concept?
Is there a DSMADMC startup parameter like '-outfile' that is equivalent to
SET SQLDISPLAYMODE WIDE? What are others doing to provide decent output from
a DSMADMC SQL SELECT and Windows?"
John G. Talafous IS Technical Principal
The Timken Company Global Software Support
P.O. Box 6927 Data Management
1835 Dueber Ave. S.W. Phone: (330)-471-3390
Canton, Ohio USA 44706-0927 Fax : (330)-471-4034
[EMAIL PROTECTED] http://www.timken.com
