Practical exploitation of DB2 LUW auditing

Tuesday, 16 June, 2015 - 10:15 - 11:30
LUW Track
Cristian Molaro
Often, there is a need to track the activity of an application or the actions of a user on a DB2 database. Whenever you need to profile a new application, to troubleshoot a weird behaving program, or to simply keep track of what changes administrators are doing, the DB2 audit facility can be of help.
“What is this user doing?” - “What are the most executed SQL statements?” - “Who is connecting to this DB2, and from where?” - “How many rows were modified?” - “How many rows were returned?”… You will find that the DB2 audit facility can answer these questions and many more. Easy to implement and quite powerful, the DB2 auditing facility deserves to be kept at hand. So the purpose of this session is to provide you with a quick introduction to its practical use.


SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us



Events in 2020

VIRTUAL EVENT - 25th - 27th November 2020