How can I list users who accese DB2/400 via ODBC or data transfer of iSeriesAccess

5 pts.
Tags:
AS/400 DB2
iSeries Access
iSeries database
We have many users who access DB2/400 database via ODBC or data transfer of iSeriesAccess. Are there any way to list those users from the accounting journal or audit journal?

Answer Wiki

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

Hi,

CL Command DSPAUDJRNE displays or prints all Audit entries. All ODBC connectivities will come under JOB ‘QZDASOINIT’. Each job desribes it’s descriptions.

Note that, You must have activated Auditing for your system to hae the audit entries.

I hope this helps.

Regards
–Narasimha

=========================================================

The QAUDJRN audit journal will tell you when a user connects to a QZDASOINIT job, but it won’t tell you if any user actually did anything unless you enable user and object audit for all users and all objects that you want to track. Further, if user/object auditing is enabled, it won’t tell you what was read or changed. (Database journals can track changes as could triggers. Triggers that log each read and/or change could quickly create log files far larger than the files they track.)

An ODBC transaction will generally be a SQL statement. The various ‘QZDA’ exit points give you a chance simply to log the SQL statements to track transactions. That can be more useful and take up far less space.

Tom

Discuss This Question:  

 
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

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