How to read informix online logic log information

Posted in 2010

Summary

The original poster asked how to read Informix OnLine logical log contents, for example to extract all inserts, updates and deletes from onlog. Mike Aubury and Neil Truby recommended Lintel's Infotrace product. Bartlomiej Lidke pointed to the IDS 11.5 documentation on onlog, saying it suffices for who-altered-this-table questions but not for everyday analysis.

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

Topics: General Discussion

spender — Fri, 09 Jul 2010 11:10:40 +0800 — source: Usenet: comp.databases.informix

for example , put all insert, updata , delete, information from onlog ? ------ any document ?

↪ replying to spender

Mike Aubury — Fri, 9 Jul 2010 07:14:37 +0100 — source: Usenet: comp.databases.informix

Lintel Software have a product called 'infotrace' that does this - see http://www.lintel.co.uk/infotrace/ On Friday 09 July 2010 04:10:40 spender wrote: > for example , put all insert, updata , delete, information from onlog ? > > ------ any document ? > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list -- Mike Aubury http://www.aubit.com/ Aubit Computing Ltd is registered in England and Wales, Number: 3112827 Registered Address : Clayton House,59 Piccadilly,Manchester,M1 2AQ

↪ replying to spender

Neil Truby — Fri, 9 Jul 2010 09:09:37 +0100 — source: Usenet: comp.databases.informix

"spender" <spender@yeah.net> wrote in message news:i163vl$ksh$1@www.shinco.com... > for example , put all insert, updata , delete, information from onlog ? > > ------ any document ? What Mike from Aubit said. Infotrace is pretty cool:http://www.lintel.co.uk/infotrace/

↪ replying to spender

Bartlomiej Lidke — Sat, 10 Jul 2010 13:32:02 +0000 (UTC) — source: Usenet: comp.databases.informix

spender <spender@yeah.net> wrote: > for example , put all insert, updata , delete, information from onlog ? > > ------ any document ? You can find some information here: http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?topic=/com.ibm.adref.doc/ids_adr_0350.htm It's enough for 'who altered this table?' questions but it's not enough for everyday work or analysis -- butthead o 'Niesmiertelnym' (c) Pleciucha: "Jest to jedyny film, w kt'rym Szkot gra Egipcjanina, kt'ry jest Hiszpanem i Francuz, kt'ry gra Szkota, kt'ry jest Nowojorczykiem..."