How to Monitor File Changes done thru STRSQL

105 pts.
Tags:
AS/400 administration
AS/400 SOX
Command line
SOX
STRSQL
I need a solution for monitoring file changes done by programmers using the STRSQL from a command line for SOX purposes.
ASKED: June 17, 2011  6:44 PM
UPDATED: June 20, 2011  6:22 PM

Answer Wiki

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

You should be able to do this with an exit program.

Check out http://www.itjungle.com/fhg/fhg110806-story01.html on how to set one up.

Discuss This Question: 4  Replies

 
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
  • TomLiotta
    Do you want to monitor STRSQL usage or do you want to monitor accesses against or changes to records in database files? Usually it's far more important to monitor changes to your data (or accesses) than just to monitor a particular tool. That is, you might monitor STRSQL for years even though it's only used for ad hoc work with temporary files. Meanwhile, someone uses UPDDTA to update critical company files, and you missed it. Monitoring STRSQL lets you see some things being done by one of the many possible tools. Monitoring your data can let you track everything that happens without needing to care which tool is used. Tom
    125,585 pointsBadges:
    report
  • poorboy01
    Looking to monitor changes made to production data to handle SOX audits. We have monitors on other tools that the programmers have access to. Per your response it sounds like you believe we should be Journaling, I'm not interested in that.
    105 pointsBadges:
    report
  • TomLiotta
    We have monitors on other tools that the programmers have access to. How do you monitor the Qshell db2 utility? Or a REXX proc that accepts and runs SQL dynamically (like STRSQL would do)? With monitors for functions like those, adapting for STRSQL should be easy. If STRSQL is explicitly needed, then either the QIBM_QCA_RTV_COMMAND exit point for a Command Analyzer Retrieve Exit Program or QIBM_QCA_CHG_COMMAND for a Command Analyzer Change Exit Program could be useful. An exit program might run a Start Database Monitor (STRDBMON) command to have a database monitor run while STRSQL is running. Without additional work, a database monitor that is scoped to a job will continue to run until the job ends. But you can ignore anything collected that isn't in your chosen scope. The monitor will end when the job ends, if nothing else is provided to end it first. Of course, you could also run STRDBMON for a system-wide monitor. In that scenario, you might want a daily scheduled job that ends and restarts the monitor. When a new monitor repository is created, the scheduled job could process what was in the previous day's repository and save relevant items into a permanent archive before deleting the old daily copy. If you prefer vendor responses, post back. Tom
    125,585 pointsBadges:
    report
  • poorboy01
    Tom, Thanks, we had been looking at the STRDBMON but was sure if there was an easier way.
    105 pointsBadges:
    report

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