Q
Get started Bring yourself up to speed with our introductory content.

Audit the interactive SQL session

How can I logging or audit the interactive SQL session, without the users knowing?
Interactive SQL doesn't have any specific tools, you would need to look at using object-level auditing or database monitors.

Another option is the QIBM_QDB_OPEN exit point that was added to V5R2 & V5R3. It's similar to object-level auditing, but can provide more info and greater control. More details can be found here.

==================================
MORE INFORMATION ON THIS TOPIC
==================================

Visit the ITKnowledge Exchange and get answers to your DB2 questions fast.

Check out this Search400.com Featured Topic: Expert advice on DB2

Search400.com's targeted search engine: Get relevant information on DB2/400.

The Best Web Links: Tips, tutorials and more.

This was last published in February 2005

Dig Deeper on iSeries SQL commands and statements

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close