ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Does Detector or Subsystem Analyzer record who touched a Table during a time frame?
Article ID: 129525
Updated On:
Products
Bind Analyzer for DB2 for z/OS
SQL-Ease for DB2 for z/OS
SYSVIEW Performance Management Option for DB2 for z/OS
Plan Analyzer for DB2 for z/OS
Subsystem Analyzer for DB2 for z/OS
Issue/Introduction
This document states whether or not Detector or Subsystem Analyzer records who touched a Table during a time frame.
Does Detector or Subsystem Analyzer record who touched a Table during a time frame?
Does Detector or Subsystem Analyzer record who touched a Table during a time frame?
Environment
z/OS 1.13 and up.
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 don't 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 isn't displayed
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 isn't displayed
Feedback
Yes
No
Powered by
