Informix Logocal Logs

Posted in 2005

Summary

A user asked whether any tool exists to read Informix logical log files, or whether one could write a C program to parse them. Several replies pointed to the bundled onlog utility, which is documented and dumps logical log records. One poster recalled writing a custom C parser years ago for Standard Engine, but others countered that doing so against modern log formats would be "practically impossible." An IBM engineer asked what the underlying goal was, but the original poster never replied, so no further resolution is recorded beyond the onlog suggestion.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: Logging & Checkpoints

Deenadhayalan Subramani — Fri, 01 Jul 2005 08:38:13 — source: IIUG Forums & Mailing Lists

Hi All Is there any tool available to read from the Informix log files ? or can we write a C program to read from the logical logs ?. Thanks Deena --------------------------------- Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football

↪ replying to Deenadhayalan Subramani

Danny Wright — Fri, 01 Jul 2005 14:47:44 — source: IIUG Forums & Mailing Lists

I once wrote a C program to parse the logs for an old Standard Engine version of Informix. I imagine you could still do it, although it's probably a little trickier now. -----Original Message----- From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On Behalf Of Deenadhayal.... Sent: Friday, July 01, 2005 1:38 AM To: ids@iiug.org Subject: Informix Logocal Logs [5326] Hi All Is there any tool available to read from the Informix log files ? or can we write a C program to read from the logical logs ?. Thanks Deena --------------------------------- Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football

↪ replying to Deenadhayalan Subramani

ERIEZNIKR@REPSOLYPF.COM — Fri, 01 Jul 2005 15:22:35 — source: IIUG Forums & Mailing Lists

Have you checked "onlog" utility? Regards. -----Mensaje original----- De: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] En nombre de Deenadhayal.... Enviado el: Viernes, 01 de Julio de 2005 05:38 a.m. Para: ids@iiug.org Asunto: Informix Logocal Logs [5326] Hi All Is there any tool available to read from the Informix log files ? or can we write a C program to read from the logical logs ?. Thanks Deena --------------------------------- Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football AVISO LEGAL: Esta informacion es privada y confidencial y esta dirigida unicamente a su destinatario. Si usted no es el destinatario original de este mensaje y por este medio pudo acceder a dicha informacion por favor elimine el mensaje. La distribucion o copia de este mensaje esta estrictamente prohibida. Esta comunicacion es solo para propositos de informacion y no debe ser considerada como propuesta, aceptacion ni como una declaracion de voluntad oficial de REPSOL YPF S.A. y/o subsidiarias y/o afiliadas. La transmision de e-mails no garantiza que el correo electronico sea seguro o libre de error. Por consiguiente, no manifestamos que esta informacion sea completa o precisa. Toda informacion esta sujeta a alterarse sin previo aviso. This information is private and confidential and intended for the recipient only. If you are not the intended recipient of this message you are hereby notified that any review, dissemination, distribution or copying of this message is strictly prohibited. This communication is for information purposes only and shall not be regarded neither as a proposal, acceptance nor as a statement of will or official statement from REPSOL YPF S.A. and/or subsidiaries and/or affiliates. Email transmission cannot be guaranteed to be secure or error-free. Therefore, we do not represent that this information is complete or accurate and it should not be relied upon as such. All information is subject to change without notice.

↪ replying to Deenadhayalan Subramani

Robert Roussey — Fri, 01 Jul 2005 15:46:59 — source: IIUG Forums & Mailing Lists

You might want to try 'onlog'? Bob Roussey Spirit Airlines Informix/Unix Administration Phone: 586.741.8991 e-mail: RobertRo@SpiritAir.com -----Original Message----- From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On Behalf Of Deenadhayal.... Sent: Friday, July 01, 2005 4:38 AM To: ids@iiug.org Subject: Informix Logocal Logs [5326] Hi All Is there any tool available to read from the Informix log files ? or can we write a C program to read from the logical logs ?. Thanks Deena --------------------------------- Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football

↪ replying to Danny Wright

Doug Conrey — Fri, 01 Jul 2005 16:16:27 — source: IIUG Forums & Mailing Lists

Informix ships with a utility called onlog -- it's in the documentation. DC -----Original Message----- From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On Behalf Of Danny Wright Sent: Friday, July 01, 2005 8:48 AM To: ids@iiug.org Subject: RE: Informix Logocal Logs [5331] I once wrote a C program to parse the logs for an old Standard Engine version of Informix. I imagine you could still do it, although it's probably a little trickier now. -----Original Message----- From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On Behalf Of Deenadhayal.... Sent: Friday, July 01, 2005 1:38 AM To: ids@iiug.org Subject: Informix Logocal Logs [5326] Hi All Is there any tool available to read from the Informix log files ? or can we write a C program to read from the logical logs ?. Thanks Deena --------------------------------- Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football

↪ replying to Danny Wright

Obnoxio The Clown — Fri, 01 Jul 2005 16:50:27 — source: IIUG Forums & Mailing Lists

Danny Wright said: > > I once wrote a C program to parse the logs for an old Standard Engine > version of Informix. > > I imagine you could still do it, although it's probably a little trickier > now. "a little trickier" = "practically impossible" > -----Original Message----- > From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On > Behalf > Of Deenadhayal.... > Sent: Friday, July 01, 2005 1:38 AM > To: ids@iiug.org > Subject: Informix Logocal Logs [5326] > > Hi All > > Is there any tool available to read from the Informix log files ? or can > we > write a C program to read from the logical logs ?. > > Thanks > Deena > > > --------------------------------- > Yahoo! Sports > Rekindle the Rivalries. Sign up for Fantasy Football > > -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule" - Coluche A smile is a gift that is free to the giver and precious to the recipient. But giving someone the finger is free too, and I find it more personal and sincere.

↪ replying to Danny Wright

Danny Wright — Fri, 01 Jul 2005 16:58:36 — source: IIUG Forums & Mailing Lists

I didn't realize practicality was a consideration. -----Original Message----- From: Obnoxio The Clown [mailto:obnoxio@serendipita.com] Sent: Friday, July 01, 2005 9:52 AM To: Danny Wright Cc: ids@iiug.org Subject: RE: Informix Logocal Logs [5331] Danny Wright said: > > I once wrote a C program to parse the logs for an old Standard Engine > version of Informix. > > I imagine you could still do it, although it's probably a little trickier > now. "a little trickier" = "practically impossible" > -----Original Message----- > From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On > Behalf > Of Deenadhayal.... > Sent: Friday, July 01, 2005 1:38 AM > To: ids@iiug.org > Subject: Informix Logocal Logs [5326] > > Hi All > > Is there any tool available to read from the Informix log files ? or can > we > write a C program to read from the logical logs ?. > > Thanks > Deena > > > --------------------------------- > Yahoo! Sports > Rekindle the Rivalries. Sign up for Fantasy Football > > -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule" - Coluche A smile is a gift that is free to the giver and precious to the recipient. But giving someone the finger is free too, and I find it more personal and sincere.

↪ replying to Danny Wright

Madison Pruet — Sat, 02 Jul 2005 05:22:49 — source: IIUG Forums & Mailing Lists

--0__=07BBFAA1DF8F5ED68f9e8a93df938690918c07BBFAA1DF8F5ED6 Content-type: multipart/alternative; Boundary="1__=07BBFAA1DF8F5ED68f9e8a93df938690918c07BBFAA1DF8F5ED6" --1__=07BBFAA1DF8F5ED68f9e8a93df938690918c07BBFAA1DF8F5ED6 Content-type: text/plain; charset=US-ASCII Deena, Why do you want to read the log files? -----Original Message----- From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On Behalf Of Deenadhayal.... Sent: Friday, July 01, 2005 1:38 AM To: ids@iiug.org Subject: Informix Logocal Logs [5326] Hi All Is there any tool available to read from the Informix log files ? or can we write a C program to read from the logical logs ?. Thanks Deena --------------------------------- Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football --1__=07BBFAA1DF8F5ED68f9e8a93df938690918c07BBFAA1DF8F5ED6 Content-type: text/html; charset=US-ASCII Content-Disposition: inline <html><body> <img src="cid:10__=07BBFAA1DF8F5ED68f9e8a93df938@us.ibm.com" width="16" height="16" alt="Inactive hide details for "Danny Wright" <dwright@sherwoodfoods.com>">"Danny Wright" <dwright@sherwoodfoods.com> <tt>Deena,</tt> <tt>Why do you want to read the log files?</tt> <tt> -----Original Message----- From: forum.subscriber@iiug.org [<a href="mailto:forum.subscriber@iiug.org">mailto:forum.subscriber@iiug.org</a>] On Behalf Of Deenadhayal.... Sent: Friday, July 01, 2005 1:38 AM To: ids@iiug.org Subject: Informix Logocal Logs [5326] Hi All Is there any tool available to read from the Informix log files ? or can we write a C program to read from the logical logs ?. Thanks Deena --------------------------------- Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football </tt> </body></html> --1__=07BBFAA1DF8F5ED68f9e8a93df938690918c07BBFAA1DF8F5ED6-- --0__=07BBFAA1DF8F5ED68f9e8a93df938690918c07BBFAA1DF8F5ED6 Content-type: image/gif; name="graycol.gif" Content-Disposition: inline; filename="graycol.gif" Content-ID: <10__=07BBFAA1DF8F5ED68f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYXJ0U2F2ZXIhAAA7 --0__=07BBFAA1DF8F5ED68f9e8a93df938690918c07BBFAA1DF8F5ED6--

Glossary

logical log