ADSM-L

Wider columns in q event command??

2004-09-08 04:29:36
Subject: Wider columns in q event command??
From: Niklas Lundstrom <niklas.lundstrom AT FORENINGSSPARBANKEN DOT SE>
Date: Wed, 8 Sep 2004 10:29:39 +0200
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    
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
<Prev in Thread] Current Thread [Next in Thread>