When a error is logged into the connxjdbc64.log, and when this error is logged in more than 1 line (with complementary information), only the first line have a datestamp.
Please find a example here below :
Mar 16 14:47:46.920 2018@LM_ERROR @ UPTIME:(00 02:49:19.321 ) IP:(10.198.140.106 ) TID:(3496203328)==> 2010(E): (40001): Unable to get record from table (CO_SL_PARAMETERS).
>>> Error Executing Query: STAT:5 ERR:98986 SQLSTATE:S1000 Error retrieving record. %E, target record currently locked by another stream
------------------
So when we want to do a grep on a precise word (like "lock") in the log, we lost the datetime information, as this information is not logged for these precise lines...
[root@dvihcasc1r log]# grep lock connxjdbc64.log
>>> Error Executing Query: STAT:5 ERR:98986 SQLSTATE:S1000 Error retrieving record. %E, target record currently locked by another stream
>>> Error Executing Query: STAT:5 ERR:98986 SQLSTATE:S1000 Error retrieving record. %E, target record currently locked by another stream
>>> Error Executing Query: STAT:5 ERR:98986 SQLSTATE:S1000 Error retrieving record. %E, target record currently locked by another stream
>>> Error Executing Query: STAT:5 ERR:98986 SQLSTATE:S1000 Error retrieving record. %E, target record currently locked by another stream
>>> Error Executing Query: STAT:5 ERR:98986 SQLSTATE:S1000 Error retrieving record. %E, target record currently locked by another stream
>>> Error Executing Query: STAT:5 ERR:98986 SQLSTATE:S1000 Error retrieving record. %E, target record currently locked by another stream
>>> Error Executing Query: STAT:5 ERR:98986 SQLSTATE:S1000 Error retrieving record. %E, target record currently locked by another stream
>>> Error Executing Query: STAT:5 ERR:98986 SQLSTATE:S1000 Error retrieving record. %E, target record currently locked by another stream
Our needs only consist to have a datetime for all the output message, even the complementary information lines.
Created on Brainstorm | 3/23/2018 3:56 |
Brainstorm ID | 5803 |