Receiving DT656 No table or index has been referenced by stmt viewed message when trying to view the Table/Index data for an SQL statement

Products

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

Issue/Introduction

DT656I No table or index has been referenced by stmt viewed message is returned when attempting
to view the Table/Index data for an SQL statement within Detector for Db2 for z/OS (PDT) or
Subsystem Analyzer for Db2 for z/OS (PSA).

 

Resolution

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

1) Both the Detector and Subsystem Analyzer collections are started

2) Both the Detector and 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