There are no qualifying static SQL statements with statistics in the EDM pool message  displayed in R/STASQLTX

Document ID : KB000117896
Last Modified Date : 07/11/2018
Show Technical Document Details
Issue:
"There are no qualifying static SQL statements with statistics in the EDM pool" message  displayed in R/STASQLTX Panel when trying
 to fetch the query information for some of the Program name in SQL Incompatiblities(376) in CA SYSVIEW Performance Monitor for DB2 for z/O. 
 
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.