Blog
i can

Dawn May

Dawn May




Bookmark and Share

October 2014

Sun Mon Tue Wed Thu Fri Sat
      1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31  

« Command Retrieve Exit Programs Can Run After Command Completion | Main | Delete That Object »

July 24, 2012

Comments

Is there any way to audit (log) those SQL statements running in interactive STRSQL session?

Good question and one that has been asked by other customers. The closest you can come to "auditing" command interfaces that execute user provided SQL statements is to use STRDBMON with a filter.

I have an article which explains how to do that:
www.ibmsystemsmag.com/ibmi/administrator/db2/SOX-Auditing-of-STRSQL-and-RUNSQLSTM-Commands

Hope that helps.

The comments to this entry are closed.