ADSM-L

column width

2005-05-12 11:22:54
Subject: column width
From: Joni Moyer <joni.moyer AT HIGHMARK DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 12 May 2005 11:20:54 -0400
Hello Everyone!

I have issued a command to find the error and warning messages and have
emailed it to myself.  Here is the command:

select date_time,msgno,message from actlog where
date_time>current_timestamp - 1 day and severity in ('E', 'W')

Is there a way to make the message column wider so that it isn't several
lines long?  Thank you!



         DATE_TIME           MSGNO     MESSAGE
------------------     -----------     ------------------
        2005-05-11            2035     ANR2035E RUN:
   10:45:55.000000                      Administrator
                                        PMSTORAGE is not
                                        authorized to
                                        issue this
                                        command.
                                        (SESSION: 320563)
        2005-05-11            2035     ANR2035E RUN:
   10:45:55.000000                      Administrator
                                        PMSTORAGE is not
                                        authorized to
                                        issue this
                                        command.
                                        (SESSION: 320563)
        2005-05-11            1423     ANR1423W Scratch
   10:46:17.000000                      volume T00953 is
                                        empty but will
                                        not be deleted -
                                        volume access
                                        mode is "offsite-
                                        ".
        2005-05-11            2035     ANR2035E RUN:
   10:49:28.000000                      Administrator
                                        ADMQ is not
                                        authorized to
                                        issue this
                                        command.
                                        (SESSION: 320568)
        2005-05-11            2035     ANR2035E RUN:
   10:49:28.000000                      Administrator
                                        ADMQ is not
                                        authorized to
                                        issue this
                                        command.
                                        (SESSION: 320568)
        2005-05-11             480     ANR0480W Session
   11:00:21.000000                      320586 for node
                                        CS-NICE-STORAGE
                                        (STORAGE_CENTER)
                                        terminated -
                                        connection with
                                        client severed.
                                        (SESSION: 320586)
        2005-05-11             480     ANR0480W Session
   11:00:21.000000                      320588 for node
                                        CS-NICE-STORAGE
                                        (STORAGE_CENTER)
                                        terminated -
                                        connection with
                                        client severed.
                                        (SESSION: 320588)
        2005-05-11             480     ANR0480W Session
   11:00:21.000000                      320590 for node
                                        CS-NICE-STORAGE
                                        (STORAGE_CENTER)
                                        terminated -
                                        connection with
                                        client severed.
                                        (SESSION: 320590)
        2005-05-11             480     ANR0480W Session
   11:00:21.000000                      320592 for node
                                        CS-NICE-STORAGE
                                        (STORAGE_CENTER)
                                        terminated -
                                        connection with
                                        client severed.
                                        (SESSION: 320592)
        2005-05-11             480     ANR0480W Session
   11:00:21.000000                      320594 for node
                                        CS-NICE-STORAGE
                                        (STORAGE_CENTER)
                                        terminated -
                                        connection with
                                        client severed.
                                        (SESSION: 320594)
********************************
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
joni.moyer AT highmark DOT com
********************************

<Prev in Thread] Current Thread [Next in Thread>