Regading DBRM and Plan name.

sonasheetal · New User Joined: 08 Jun 2005 Posts: 27

Hi,
I just want to know the answer for the follwing query.

In Cobol+Db2 compiler Jcl if we give the DBRM member name and its library(dataset), no need to give the path for the plan to get stored.

i.e Is the Plan getting stored in the DBRM member Place after the binding process?

If so the DBRM is overidden with the Plan .

Please Clarify the above .

Thanks,
Sona.

ragshere · New User Joined: 20 Dec 2004 Posts: 70

Hi Sona,
Plan and DBRM are diffrent objects. DBRM will not override the plan.

DBRM will be saved in the dataset you mentioned.Plan will be saved in the system catalog after bind. Plan will not have a physical structure.

Plan is just a pointer to the DBRM from DB2 's perspective.

Please let me know if you have still doubt.

Thanks
Rags

prabs2006 · Active User Joined: 12 Jan 2006 Posts: 103

Hi

Bind is something which creates an access path. The Bind result statistics will be stored in the plan table and not as member in any PDS as like DBRM.

Thanks & Regards
Prabs