How to retrieve/check previously executed SQL ?

Hi All, Is there a way on how to retrieve or check a previously executed SQL statements? I want to know if it can be done... I've check onlog and oncheck utilities, however, i can't get it. Is it possible? BTW, i'm using AIX 5 and IDS 9.4. thanks,

Ummmm... Upgrade to version 11.5 and turn on the SQL statement cache? I don't think it was available back under 9.4 Jarrod -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of JACK PAPA Sent: Wednesday, 22 September 2010 4:23 p.m. To: ids@iiug.org Subject: How to retrieve/check previously executed SQL ? [21415] Hi All, Is there a way on how to retrieve or check a previously executed SQL statements? I want to know if it can be done... I've check onlog and oncheck utilities, however, i can't get it. Is it possible? BTW, i'm using AIX 5 and IDS 9.4. thanks, ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. DISCLAIMER This email contains information that is confidential and which may be legally privileged. If you have received this email in error, please notify the sender immediately and delete the email. This email is intended solely for the use of the intended recipient and you may not use or disclose this email in any way.

9.40 doesn't keep any SQL history. You can use the SQLTRACE facility but it is expensive and captures lots of data. You can use AGS's Server Studio which can capture and record historical SQL by polling the sysmaster tables. The capture is not 100%, but about as good as you will get before 11.50's SQL history memory cache. Another option is Exact Solutions' iWatch which can capture 100% of your networked (ie TCP/IP etc) traffic into and out of the server and includes some analytics. 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, Sep 22, 2010 at 12:22 AM, JACK PAPA <informix2009@gmail.com> wrote: > Hi All, > > Is there a way on how to retrieve or check a previously executed SQL > statements? I want to know if it can be done... I've check onlog and > oncheck> utilities, however, i can't get it. > > Is it possible? > > BTW, i'm using AIX 5 and IDS 9.4. > > thanks, > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016363b92c0ea01e00490db5655