IFI-PLAN data collector parameter

Products

• 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

Issue/Introduction

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                                                                                              

 

 

 

Environment

Release : 20.0

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

Resolution

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.