Niklas,

I don't know exactly what you're trying to achieve, but maybe you could use "dsmadmc 
-displaymode=table" and then "q ev ... > /tmp/some_file" and some shell scripting to 
get what you need. To my knowledge, there is no way increasing the length of columns 
for an internal TSM command ...
Hope this helped !
Cheers. 

Arnaud 

******************************************************************************
Panalpina Management Ltd., Basle, Switzerland, CIT Department
Viadukstrasse 42, P.O. Box 4002 Basel/CH
Phone:  +41 (61) 226 11 11, FAX: +41 (61) 226 17 01
Direct: +41 (61) 226 19 78
e-mail: [EMAIL PROTECTED]
******************************************************************************

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Niklas Lundstrom
Sent: Wednesday, 08 September, 2004 10:30
To: [EMAIL PROTECTED]
Subject: Wider columns in q event command??

Hello
 
When I issue  q event * * exceptipnsonly=yes I get
 
tsm: SPADAB-PROD>q event * * exceptionsonly=yes
 
Scheduled Start      Actual Start         Schedule Name Node Name     Status
-------------------- -------------------- ------------- ------------- ------
09/08/2004 03:00:00                       INCRBACK3     SFFPROD2DB    Missed
09/08/2004 05:00:00                       INCRBACK1     STMFSPAS01AD- Missed
                                                         001
09/08/2004 05:00:00  09/08/2004 05:00:21  INCRBACK1     STMFSPAS01EX- Failed
                                                         002
09/08/2004 05:00:00  09/08/2004 05:33:21  INCRBACK1     STMFSPAS01EX- Failed
                                                         005
09/08/2004 05:00:00  09/08/2004 05:00:33  PRIME_POSTSC- PRIMEDB1      Failed
                                           HEDULE_CMD
09/08/2004 05:00:00                       PRIME_POSTSC- PRIMEDB2      Missed
                                           HEDULE_CMD
09/08/2004 07:00:00  09/08/2004 08:33:35  REST_OBTAIN   SP77777WS210  Failed
 
However some of my schedule and nodenames are too long to fit within the Schedule Name 
and Node Name row, so I get a line with just a few charachters in the output I want it 
to look something like:
 
Scheduled Start         Actual Start                  Schedule Name                    
     Node Name                Status
--------------------            --------------------                -------------      
                             -------------                   ------
09/08/2004 05:00:00                                      INCRBACK1                     
          STMFSPAS01AD001 Missed
09/08/2004 05:00:00    09/08/2004 05:00:21    INCRBACK1                                
STMFSPAS01EX002 Failed
09/08/2004 05:00:00    09/08/2004 05:33:21    INCRBACK1                                
STMFSPAS01EX005 Failed
09/08/2004 05:00:00    09/08/2004 05:00:33    PRIME_POSTSCHEDULE_CMD   PRIMEDB1        
       Failed

I looked at select * from events but I only see the most recent events there
 
Is there a way to increase the number of charachters in the rows?
 
Regards
Niklas Lundström
Swedbank

Reply via email to