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?

We use Safenet from Kisco and are happy with it:

www.kisco.com

Terry
 
Re: A way to capture (audit) SQL statements on the \'400\' platform?

Hi Michael,

You can try using the STRDBMON command on *ALL jobs. The command will write the data to a file of your choice which you can specify in the command. You can then write a RPG or CL program to read the data and send out alerts. You can also use filters on the command but it depends on what you're after.

You can also audit all the users logging onto the 'green screen' by using the CHGUSRAUD command. This however, won't track the SQL commands but it will track any command that the user executes on the command line.

Another option would be to use journaling on files. We also use AllOut Security's TRACE for i for reporting and database monitoring.

I hope it helps.

Kind regards,
Misael
 
Re: A way to capture (audit) SQL statements on the \'400\' platform?

Terry, Misael. Thank you for replying, much appreciated. We are going to take a look at both KISCO and ALLOUT's trace product. There's also a product from SAFESTONE which has been purchased by HELP systems that were going to take a look at as well.

Thanks again,

Michael
 
Back
Top