5 pts.
 How can I list users who accese DB2/400 via ODBC or data transfer of iSeriesAccess
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?

Software/Hardware used:
ASKED: April 3, 2008  1:23 AM
UPDATED: April 19, 2010  5:23 AM

Answer Wiki:
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
Last Wiki Answer Submitted:  April 19, 2010  5:23 am  by  NarasimhaReddy   225 pts.
All Answer Wiki Contributors:  NarasimhaReddy   225 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _