search cancel

Why IDB2 R19 requires Plan Authorization while R15 didn't?


Article ID: 107965


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


In R15 the DB* plans have no grant authorization rights but in R19, they do. Why is that?


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.