DT656I Errors When Using Detector SQL Table Activity Display
search cancel

DT656I Errors When Using Detector SQL Table Activity Display

book

Article ID: 215652

calendar_today

Updated On:

Products

Detector for DB2 for z/OS Database Management for DB2 for z/OS - Performance Suite

Issue/Introduction

When attempting to use the SQL Table Activity Display to show tables, indexes, and statistics for the SQL calls that are selected in the Plan SQL Display. 
When the option is selected, the following information message: 

DT656I: No table or index has been referenced by statement viewed

Documentation points out that Subsystem Analyzer for Db2 for z/OS (PSA) needs to be installed to be able to use this function. What is needed in order to
view the plan SQL and SQL table activity?
Will additional tables need to be created in order to use this feature?

Environment

Component : Detector for DB2 for z/OS

Resolution

DT656I is an indication that Subsystem Analyzer in not installed and and active collection executing.