Is there a way to check the historical DML command

Hi All, Just want to ask this. There's a data deleted from a table and it took 1 month before someone saw that there's a deleted data. I was able to restore the data into another box and retrieve the data from that table. The question is: Is there a way to see from the DB perspective previously executed DML? select, insert, update, delete?. even though it is 1 month ago? btw, IDS version = 9.4, OS = AIX 5.2 Thanks,

My answer is "NO". as the DMLs are saved trhough TEMP storage and parsed after execution. Let me know your inputs.

If you have saved your logical logs, you can go through those to see w= ho deleted the records. John F. Miller III STSM, Support Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) = From: "JACK PAPA" <informix2009@gmail.com> = = To: ids@iiug.org = = Date: 08/19/2010 09:11 AM = = Subject: Is there a way to check the historical DML command [2096= 1] = Sent by: ids-bounces@iiug.org = = Hi All, Just want to ask this. There's a data deleted from a table and it took = 1 month before someone saw that there's a deleted data. I was able to restore the data into another box and retrieve the data f= rom that table. The question is: Is there a way to see from the DB perspective previously executed DML? select, insert, update, delete?. even though it is 1 month ago? btw, IDS version =3D 9.4, OS =3D AIX 5.2 Thanks, ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

You can have onlog look at the logical logs from that time and if the database is logged you will see a delete, update, insert operation. Onlog won't show you the data, however, except in a typical od style hex/char display. You could extract the deleted rows from the archives using archecker however. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Aug 18, 2010 at 10:56 PM, JACK PAPA <informix2009@gmail.com> wrote: > Hi All, > > Just want to ask this. There's a data deleted from a table and it took 1 > month > before someone saw that there's a deleted data. > > I was able to restore the data into another box and retrieve the data from > that table. > > The question is: > > Is there a way to see from the DB perspective previously executed DML? > select, > insert, update, delete?. even though it is 1 month ago? > > btw, IDS version = 9.4, OS = AIX 5.2 > > Thanks, > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016e64650088e3f63048e3092ff