Re: Retreving Insert Statements for Logical Logs

I have had few times when it would have saved lives to replay the logs. Tech Support is 100% sure that they can create replay for the Inserts since as stated the data is in the log for inserts. I have a case number and emails from IBM so if it is a lie I know where it is from. Looking at an on log using "onlog -l" and see the rows for HINSERT there will be the data you inserted. The problem is parsing it into a usable form for an insert. Only takes time to create a process to do that, which I don't have at this time. If anyone does I would hope it gets posted to IIUG or at least the news group. On Mon, 2004-02-23 at 21:55, Madison Pruet wrote: > "Neil Truby" <neil.truby@ardenta.com> wrote in message > news:c1e7na$1hsj5n$1@ID-162943.news.uni-berlin.de... > > "Eric Rowell" <erowell@knology.net> wrote in message > > news:c1dmv3$62a$1@terabinaries.xmission.com... > > > > > > 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 *** > > > > Nor to trusted "partners". > > > > Nor to IDS architects, either. > > > sending to informix-list