Re: Retreving Insert Statements for Logical Logs

We have a tool that does extract this information from the logs - at least we used to. We sold it commercially until a few years ago when Informix changed the log format to record only the columns that changed rather than the complete data on an update operation. However inserts and deletes still record the full data row and so can still be extracted; updates can also be extracted if ER is enabled on the table since in this case the full data is also recorded. If IBM would like to provide a flag whereby the long transaction format can be turned on/off then we can extract all updates, deletes and updates. Obviously there may be complications if the tblspace number no longer exists or refers to a different table since the product uses this information to obtain the table schema. It would take some effort to get this product up and running again on later versions but if anyone is interested then please email me directly. Regards David Linthwaite Lintel Software Consultancy Ltd Tel: 01244 316297 Fax: 01244 400171 dlinthwaite@lintel.co.uk ----- Original Message ----- From: "Eric Rowell" <erowell@knology.net> To: <informix-list@iiug.org> Sent: Monday, February 23, 2004 7:46 PM Subject: Retreving Insert Statements for Logical Logs > Retrieving Insert statements from the logical logs using onlog and a > little known of process with the Help of Informix Support. > > The other week we had one of the worse things happen. One process was > inserting data and another process was deleting that data concurrently. > As an Informix DBA this is a nightmare we all hope would only happen to > people we don't like. > > With a little help from a co-worker with no concept of the word "NO" he > found out that there is a little known of process in which Tech Support > may be able to help at least retrieve the insert statements. *** The > tool cannot be given to the customer at this time and there doesn't seem > to be a plan to provide it *** > > > Call Support and ask tell them you need to have someone run the "log > reading tool" and be ready to provide the following; > > o The table schema. > o A sample of logical log output (onlog -l) that includes some INSERT > and DELETE activity on the table. > o The partition number of the table as referenced in the log. > o The platform the customer is using. > o The IDS version number. > > > I hope that in a newer release we can get a tool to recreate SQL without > having to call support. Most other major DB's have a feature like this > and in the rare case it is needed it would be best we have the tool or > at least know one is out there. > > > Eric B. Rowell > > > > > sending to informix-list sending to informix-list