No qualifying static SQL statements with statistics in the EDM pool message displayed in R/STASQLTX for Sysview for Db2

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

Within Sysview Performance Management Option for Db2 for z/OS (IDB2) there are no qualifying static SQL statements
with statistics in the EDM pool message displayed in R/STASQLTX requests panel when trying to fetch the query information for
some of the program names in SQL incompatibilities (IFCID 376). 

Resolution

There are no qualifying static SQL statements with statistics in the EDM pool. This could be due to one of the following:

1. Static SQL statistics collection is not enabled. IFCID 400 must be started to have Db2 collect statistics for static SQL.
To enable IFCID 400, you can either set IQL-INCLUDE-IFCID400=YES in the data collector SYSPARMS, or include
IFCID 401 in the HIST-STATS-RECS SYSPARM parameter, which will also cause the data collector to save static SQL
statistics in the online history files.  If the change is made, datacollector started task needs to be recycled.

2. The focus (selection) criteria did not allow any static statements to be returned. Either disable focus or change the focus
criteria to display statements.

3. There are no static SQL statements with statistics in the EDM pool. These records are available for Db2 10 and higher.

4. You have selected an SQL statement to view detail information but the SQL statement is no longer in the EDM pool.