Bind Analyzer for DB2 for z/OSSQL-Ease for DB2 for z/OSSYSVIEW Performance Management Option for DB2 for z/OSPlan Analyzer for DB2 for z/OSSubsystem Analyzer 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
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.