Iseries SQL Auditing

5 pts.
Tags:
iSeries SQL
iSeries SQL Auditing
I want to audit interactive SQL statements. Is this something I can do and if so how ?

Answer Wiki

Thanks. We'll let you know when a new response is added.

I can suggest several options. The most expensive is to journal all of your files and write pgms to dump SQL transactions to a report or outfile for review.

The cheapest would be to make everyone using interactive SQL go through a command line that forces all commands to write a journal entry. Just turning on user auditing *CMD will get your the strsql command, but not the rest of the sql statements. I’ve seen these command processing programs but couldn’t find an example with a quick seach, but i’m sure they’re out there.
If you do not have SQL developer tool kit on the system, and the sql statement can’t be prompted, just auditing the user will make a journal entry for the statements.

The best is NetIQ’s Secure SQL that forces audit entries for all SQL statements while still giving you helps and prompts to develope an SQL statement.

//////////////////////
Here is a recent discussion of this issue

http://itknowledgeexchange.techtarget.com/itanswers/strdfu-utility/

Phil

————————————————————–

Some have had very good success auditing interactive SQL access using a combination of the Open Database File Exit documented <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/apis/xopendbf.htm”>here</a> and the <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/apis/qusrjobi.htm”>Retrieve Job Information</a> API which returns SQL statement information with format JOBI0900.

I hope this helps,
Bruce Vining
<a href=”http://www.brucevining.com/”>Bruce Vining Services</a>

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following