column width
2005-05-12 11:22:54
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>
|
- column width,
Joni Moyer <=
|
|
|