ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Wrong Plan used for IDB2 Dynamic Explain
book
Article ID: 186440
calendar_today
Updated On:
Products
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
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.