Skip to Main Content
Due to the recent acquisition by IBM, the Adabas & Natural Ideas Portal does not contain ideas from products ApplinX and EntireX any longer. Please refer to the IBM Ideas Portal for these products from now on (IBMid required). Existing content will be migrated during the next few weeks.
Status Released
Workspace CONNX
Created by Stephane Moreau
Created on Jul 27, 2021

missing datestamp/datetime for for lines in the connxjdbc64.log file

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