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/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.