DT656I Errors When Using Detector SQL Table Activity Display

Products

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

Issue/Introduction

When trying 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

CA Broadcom documentation points out that CA Subsystem Analyzer for DB2 for z/OS 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

Release : 20.0

Component : CA Detector for DB2 for z/OS

Resolution

DT656I is an indication that you don't have Subsystem Analyzer Installed and running.  If you want to read more about this check this link:CA Subsystem Analyzer for DB2 for z/OS Panel Integration