International Informix Users Group

	Informix News

29 July 09 - Wall Street Journal - IBM to Acquire SPSS, Adding to Acquisitions... Read 11 February 09 - InformationWeek - IBM Drifts Slowly Toward Mainstream Cloud Computing... Read 11 February 09 - CNNMoney.com - IBM to Deliver Software via Cloud Computing With Amazon Web Services... Read 07 January 09 - Huliq News - IBM Power Servers Helps Bank of Chengdu Build Up Core Banking System.. Read 04 December 08 - Steeleye - Multicarta achieves 99.997% uptime for its Informix-based Credit Card Authorization Centre... Read 16 October 08 - VendorRate - Informix Earns Top Customer Satisfaction Score on VendorRate in Q3... Read 14 August 08 - IIUG.org - Sellout Expected for the 2009 IIUG Informix Conference... Read 29 April 08 - IntelligentEnterprise.com - IBM Informix Upgrade Enhances Clustering, Database Management... Read 29 April 08 - itweek.com - IBM 'Cheetah 2' mauls data costs... Read 28 April 08 - eWeek.com - IBM Uncages Cheetah 2 Data Server... Read 28 April 08 - CNNMoney.com - IBM Helps Clients Reduce Data Management Costs With New Informix Dynamic Server... Read 09 April 08 - CNNMoney.com - MediaSpan Embeds IBM Informix Dynamic Server Software for Delivering News to Print, Web and Wireless Devices... Read 08 April 08 - IT-Director.com - Informix seeks developers... Read 18 February 08 - marketwire.com - Icarus Studios Partners With IBM to Upgrade Performance, Availability for Its Online Games... Read 17 January 08 - eWeek.com - IBM Adds Mac Support to IDS for Higher Education... Read 17 January 08 - informationweek.com - Lotus Notes For iPhone Signals Closer Ties Between IBM, Apple... Read 16 January 08 - marketwire.com - IBM Informix Dynamic Server to Deliver Support for Mac OS X... Read 16 January 08 - internetnews.com - IBM's IDS to Support Mac Platform... Read 28 June 07 - REG Developer - IBM and Informix tie down Cheetah... Read 27 June 07 - CBRonline.com - IBM corrects its own Informix customer figures... Read 14 June 07 - vnunet.com - IBM changes spots with Informix 'Cheetah' database... Read 14 June 07 - eChannelLine - IBM expands scope for IDS... Read 14 June 07 - Resellernews - IBM: Informix database alive and kicking... Read 13 June 07 - DB2 Magazine - Cheetah is now out of the gate... Read 12 June 07 - IBM - IDS 11 release announcement (pdf)... Read 12 June 07 - ChannelWeb Network - IBM Uncages IDS 11, Aka Cheetah, Database... Read 12 June 07 - eWeek.com - IBM's 'Cheetah' Ready to Pounce... Read 12 June 07 - InformationWeek - IBM Unleashes 'Cheetah' Database... Read 12 June 07 - WebWire - IBM Strengthens Database Portfolio With New Informix Dynamic Server... Read 12 June 07 - Intelligent Enterprise - IBM Unveils Informix Upgrade... Read 12 June 07 - ComputerWeekly.com - IBM's Cheetah IDS makes leap to better data centre clustering... Read 12 June 07 - ebiz - IBM Unveils Next Generation Informix Dynamic Server... Read 12 June 07 - computerworld.com - Will 'Cheetah' help IBM's Informix chase down market share?... Read 12 June 07 - Internetnews.com - No Data Can Outrun This 'Cheetah'... Read 12 June 07 - de.internet.com - IBM neuer Datenbank-Server mit Codenamen Cheetah ist fertig... Read 12 June 07 - verifox.de - IBM stärkt Datenbank-Portfolio mit neuem Informix Dynamic Server... Read 12 June 07 - golem.de - Informix 11 vorgestellt... Read 12 June 07 - Computerwoche.de - IBM stellt neue Informix-Version vor... Read 12 June 07 - IBM.de - IBM stärkt Datenbank-Portfolio mit neuem Informix Dynamic Server... Read 12 June 07 - Heise - IBM gibt Informix 11 frei... Read 25 May 07 - Taiwan.CNET.com - Local Taiwan Informix user group established... (Chinese language) ... Read 18 May 07 - ChannelWeb Network - IBM Musters Partners For Cheetah Release... Read 18 May 07 - eWeek.com - IBM Looks to 'Cheetah' to Speed Up Blade Servers... Read 7 May 07 - DB2 Magazine - SQL Shortcuts - Use these tricks to generate IDS SQL scripts... Read Previous news items

End of Support Dates

IDS 7.31 - 30 Sep 2009 IDS 9.40 - 30 Apr 2009 IDS 10.00 - 30 Sep 2010 Subscribe to notifications

Home Member Area About IIUG

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum

Re: Detailed Audit

Posted By: Fernando Nunes
Date: Sunday, 7 March 2010, at 6:08 p.m.

In Response To: Detailed Audit (CHANDAN PAI)

IDS does not provide any feature specifically designed for capturing SQL
statements.
You may find other tools useful, but most have limitations:
- SQLTRACE (captures to memory, and you'd have to make sure you put it file
before the capture buffer wraps around)
- SQLIDEBUG (a feature directed to support needs)
- External tools (one was already mentioned, and recently IBM acquired
Guardium, a company specialized in auditing)
It could help us providing more help if we knew what were the needs. Also
consider the amount of information you plan to generate. Are you prepared to
process it?
Regards.
On Thu, Mar 4, 2010 at 10:14 PM, CHANDAN PAI <chandanpai@yahoo.com> wrote:
> I have an application which I would like to audit at a detailed level. I
> have
> Informix 11.5 FC5 auditing turned on. The application can make more than
> 1000
> events in a 60 second period. I can sequentially see all the audit events
> that
> happened on different tables. I was wondering if I can capture the actual
> SQL
> that was issued by the application user corresponding to the audit event...
> like for ACTB.
>
> For now all I can see for such an event is
> 0:ACTB:csp_db:dmuser:env_code:160
>
> Thanks
> Chandan
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Fernando Nunes
Portugal
http://informix-technology.blogspot.com
My email works... but I don't check it frequently...
--0016e6d7eea0df598a04813e05df

Messages In This Thread

Detailed Audit
CHANDAN PAI -- Thursday, 4 March 2010, at 5:14 p.m.
- Re: Detailed Audit
  Obnoxio The Clown -- Thursday, 4 March 2010, at 5:19 p.m.
- Re: Detailed Audit
  Richard Snoke -- Thursday, 4 March 2010, at 5:40 p.m.
- Re: Detailed Audit
  Art Kagel -- Thursday, 4 March 2010, at 5:56 p.m.
- Re: Detailed Audit
  Fernando Nunes -- Sunday, 7 March 2010, at 6:08 p.m.

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum is maintained by Administrator with WebBBS 5.12.