Why am I receiving a "DT656I: No table or index has been referenced by stmt viewed" error message when trying to view the Table/Index data for an SQL statement?

Document ID : KB000032051
Last Modified Date : 14/02/2018
Show Technical Document Details

This document explains why you may receive a "DT656I: No table or index has been referenced by stmt viewed" error message, when trying to view the Table/Index data for an SQL statement.

There are a number of reasons why this error message may occur. Ensure that the following steps are in place:

1) Both the Detector & Subsystem Analyzer collections are started

2) Both the Detector & Subsystem Analyzer Datastores have the same <High.Level> qualifier & name

3) The SQL statement has a Getpage count greater than zero

4) If the Plan Excl/Incl Indicator is enabled for your collection verify in your Collection Profile:

   A) The "Enable Detector Statistics Collection" indicator for the Plan, Correlation ID, Authorization ID or Location of the SQL statement is not set to "N" on the "View Include/Exclude Entry" screen

   B) The "Enable Standard Activity Table/Index Statistics Collection" indicator for the Plan, Correlation ID, Authorization ID or Location of the SQL statement is not set to "N" on the "View Include/Exclude Entry" screen