A way to capture (audit) SQL statements on the '400' platform?

Michael L.

Well Known Member
A way to capture (audit) SQL statements on the \'400\' platform?

Hello List. We have an audit requirement to capture SQL statements on J.D. Edwards tables. Is anyone aware of a DB2/400 command, parameter on a user’s ‘400’ user profile or a tool (free or for purchase) to capture SQL’s statements executed from Operations Navigator and/or 5250 ‘green screen’?

Thanks in advance for any assistance,

Michael
9.0 / 8.98.4.7 / V6R1 / OAS
 
Re: A way to capture (audit) SQL statements on the \'400\' platform?

Logging of SQL commands is ruled by a file called QAQQINI. See the attached.
 

Attachments

  • 186672-QAQQINI DEBUG.doc
    101.5 KB · Views: 132
Re: A way to capture (audit) SQL statements on the \'400\' platform?

Sheesh...I made a post yesterday but it never appeared
frown.gif


There are a couple of 3rd part vendors that will utilize exit points to track SQL execution. We use Safenet from Kisco and are happy with its performance.

It's also possible to write your own exit point handler to record SQL statments - if your so inclined.

Good Luck,
Terry
 
Back
Top