?
Solved

Is there a way to track what was viewed or changed via ODBC?

Posted on 2011-10-07
6
Medium Priority
?
330 Views
Last Modified: 2012-05-12
If a user connected to the IBM iSeries via the IBM Client Access ODBC and linked to a file, is there a way to

1) know who viewed which files?
2) know if they changed any data and which files/fields?

Thanks!
0
Comment
Question by:PROEUG
  • 3
  • 3
6 Comments
 
LVL 18

Accepted Solution

by:
Dave Ford earned 1000 total points
ID: 36934260

The easiest way is to start journaling on the files you're looking to monitor. Then, you can monitor ANY use or change of the files in question using the DspJrn command.

HTH,
DaveSlash
0
 

Author Comment

by:PROEUG
ID: 36934304
We do journal our files.  Are you saying that even using ODBC, the iSeries OS will journalize who the user was, what file he/she accessed, and assuming the before/after images are available, that the journals would capture any changes made through ODBC?  That would be fantastic and seemingly answer any auditor's concern.
0
 
LVL 18

Expert Comment

by:Dave Ford
ID: 36934346

That's absolutely correct. Journaling logs all the changes and who made them.

-- DaveSlash
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 

Author Comment

by:PROEUG
ID: 36934368
This is all hypothetical because we don't usually have users setting up their ODBC connections where they are allowed to update data on the iSeries, just read.  However, this doesn't mean someone out there did not configure their ODBC parameters to prevent updates.  Just that we've never bothered looking in the journals for any possible ODBC originated updates.  I guess we'll start looking for any journal records with strange job names.

Thanks much and I will accept your answer.  Wish there was something quicker and easier inherent to the iSeries and ODBC to use than journals, i.e. some special log file, but your answer makes sense and falls in line with a uniform method for tracking file access.  Thanks again!
0
 
LVL 18

Expert Comment

by:Dave Ford
ID: 36934387

There are other options, but they're more complex and some of them even cost extra money. I prefer "native" and "cheap" solutions.

I usually do a DspJrn to an outfile and query the resulting table. It makes the data easier to manage than scrolling through pages and pages of stuff on the green-screen.

-- DaveSlash
0
 

Author Comment

by:PROEUG
ID: 36934404
I agree Dave.  We just got hit with an audit and the journals - once enabled - proved to be a blessing.  I had to quickly learn DSPJRN and how to query the outfiles.  Funny thing is, I used MS Access to then create an application to report and create file extracts for the users and auditors.  I should check the journals for my own ODBC access!  LOL!

I think the company did purchase some third-party software that also monitors file access, but I'm not familiar with it.  I did mention this to the person asking but she was looking for a quick answer.  You guys on Experts Exchange are about as quick as an answer I could hope for.  Just hope this person buys into the answer!  :-)

Thanks again Dave.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many of us in IT utilize a combination of roaming profiles and folder redirection to ensure user information carries over from one workstation to another; in my environment, it was to enable virtualization without needing a separate desktop for each…
OfficeMate Freezes on login or does not load after login credentials are input.
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question