IFI-PLAN data collector parameter
search cancel

IFI-PLAN data collector parameter


Article ID: 142880


Updated On:


Bind Analyzer for DB2 for z/OS SQL-Ease for DB2 for z/OS SYSVIEW Performance Management Option for DB2 for z/OS Plan Analyzer for DB2 for z/OS Subsystem Analyzer 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


Trying to use the new IFI-PLAN=XXXXXXX parameter to eliminate rebind  plan/pkg locks while the data collector is running.
The manual says there are no specific requirements for the plan used but what are the steps for creating a new XXXXXX plan to specify on the parameter? 

the following error message is being produced
DBG37034E DATA COLLECTOR UNABLE TO ALLOCATE THREAD USING PLAN NAME xxx AND AUTHORIZATION ID xxx                                                                                              





Release : 20.0

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


The IFI-PLAN parm allows users to specify some dummy plan that can be used
instead of the EXPLAIN plan name,
so that a rebind of the DB2 Tools plans will not fail.

Note it is no longer an issue in DB2 12 with the REBIND PHASE-IN option.