SYSVIEW for DB2 - How to report DML activity over each table

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

Does SYSVIEW for DB2 have any option or report to know the DML activity over Db2 tables?.

For example: How many Select, Delete, Insert or Update statements have been run over a Db2 table?.

 

Environment

Release : 20.0

Resolution

The auditor report AUDCLAS6 can be used to get information you are looking for. But first the Db2 table that you want to monitor should have defined with AUDIT option CHANGES or ALL.

Then you can start the report AUDCLAS6 which traces IFCID 145 (AUDIT-LOG).

Refer AUDCLAS6 report from the auditor reports. 

Auditor Reports 

Also if Log Analyzer is available DML statistics related reports can be created against Db2 tables.