Tweet
We use the command STRDBMON. We have added this to our initial program. SQL statements are put to a file which you can then create a report from.
-
-
SQL Session
"We use the command STRDBMON. We have added this to our initial program" You have my curosity aroused. Do you mean the program that starts defined on the user profile??? If so, how does it distinguish between interactive SQL (STRSQL) and other compiled SQL statements? What I don't know about STRDBMON, you could probably write books about! -
SQL Session
Yes, we have added the command to the initial program that runs when we signon. We are currently only using it for our programmers as a tool to track changes for SOX. Here is a link to the redbook that covers that command http://www.redbooks.ibm.com/redbooks/pdfs/sg246654.pdf There is a way to differentiate between interactive & program run sql statements.Comment
-
SQL Session
I've got a flight to Chicago tomorrow ... reading material!!!Comment
-
SQL Session
Good day is there any way to monitor and log any sql session for any user on the AS400? ThanksComment
Comment