Unknown SQL activity on RI related tables

Document ID : KB000094741
Last Modified Date : 15/05/2018
Show Technical Document Details
Introduction:
If CA Detector is installed you can select a table from Subsystem Analyzer and view all executed SQL activity that referenced the table.
By viewing the SQL, you can determine whether it referenced the table using sequential access or index access. You can also view all SQL activity that has used a selected index.
 
Question:
We see SQL activity correctly related to a specific table, but also activity to other tables that are RI related with this table and not updated. Why?
Environment:
CA-Subsystem Analyzer synchronizing with CA-Detector
Answer:
DB2 is checking that RI constraints are not violated and this result in activity on tables that are not directly updated.
For example, Inserts on a child table could result in Getpages on the index of the parent table.
Additional Information:
Db2 11 - Introduction - Referential constraints - IBM