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.
Why IDB2 R19 requires Plan Authorization while R15 didn't?
Article ID: 107965
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/OS
In R15 the DB* plans have no grant authorization rights but in R19, they do. Why is that?
Release: Component: CIDB
Since R17 the Datacollector Threads now needs the plan name to be allocated. This is different than it has been in the past. The Datacollector will need to be granted EXECUTE authority on the IDB2 Explain Plans reference in the PLANSXX member of the CDBAPARM. Datacollector Tasks do not execute the plan but IBM requires the plan name allocation to collect IFCID 401 data from DB2.