SYSVIEW Performance Management Option for DB2 for z/OSDatabase Management for DB2 for z/OS - Performance SuiteDatabase Management for DB2 for z/OS - SQL Performance SuiteInsight Performance Monitor for DB2 UDB for z/OS
Insight Dynamic Explain is using the wrong Plan (IDBSPL19) Instead of (IDBSPL20) which is the correct one. Why?
Release : 20.0
Component : CA Insight Database Performance Monitor for DB for z/OS
The problem was caused by pointing to the wrong plan in the EXPLAIN-PLAN-SYSIBM=XXXXXXXX
in the HGHLVL.SOURCE(SSIDSYSP). Commenting out these parm and recycling the datacollector resolved the problem.