Does Detector or Subsystem Analyzer record who modified a table during a time frame
search cancel

Does Detector or Subsystem Analyzer record who modified a table during a time frame

book

Article ID: 129525

calendar_today

Updated On:

Products

Detector for DB2 for z/OS Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

Does Detector for Db2 for z/OS (PDT) or Subsystem Analyzer for Db2 for z/OS (PSA) record who modified a table during a time frame.

Resolution

A keyed User ID and End User ID, SQL Text enabled Standard Activity collection contains information for tables that are Selected/Deleted from,
Inserted into, or Updated. Although these are summary statements that do not contain the exact time that the access occurred, they can tell you all DML occurrences.

If the SQL access exceeded PDT's Exception Threshold or created an SQL Error, it's access time is also captured by User ID. 

Regarding Subsystem Analyzer, you can trace Table activity backwards until you reach the SQL statements in Detector. Unfortunately, the User ID is not displayed.