Wrong Plan used for IDB2 Dynamic Explain

Products

• SYSVIEW Performance Management Option for DB2 for z/OS
• Database Management for DB2 for z/OS - Performance Suite
• Database Management for DB2 for z/OS - SQL Performance Suite
• Insight Performance Monitor for DB2 UDB for z/OS

Issue/Introduction

Insight Dynamic Explain is using the wrong Plan (IDBSPL19) Instead of  (IDBSPL20) which is the correct one. Why?

Environment

Release : 20.0

Component : CA Insight Database Performance Monitor for DB for z/OS

Resolution

The problem was caused by pointing to the wrong plan in the
EXPLAIN-PLAN-SYSIBM=XXXXXXXX  

EXPLAIN-PLAN-USERQUAL=XXXXXXXX 

in the HGHLVL.SOURCE(SSIDSYSP).
Commenting out these parm and recycling the datacollector resolved the problem.