Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Regading DBRM and Plan name.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
sonasheetal

New User


Joined: 08 Jun 2005
Posts: 27

PostPosted: Wed Feb 08, 2006 3:53 pm    Post subject: Regading DBRM and Plan name.
Reply with quote

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.
Back to top
View user's profile Send private message

ragshere

New User


Joined: 20 Dec 2004
Posts: 70

PostPosted: Wed Feb 08, 2006 4:14 pm    Post subject: Re: Regading DBRM and Plan name.
Reply with quote

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
Back to top
View user's profile Send private message
prabs2006

Active User


Joined: 12 Jan 2006
Posts: 103

PostPosted: Wed Feb 08, 2006 4:17 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Program and its corresponding plan vickey_dw DB2 4 Thu Apr 07, 2016 9:27 pm
No new posts Should we Rebind Plan if no SQL changes sappy_mf DB2 2 Thu Mar 03, 2016 2:13 pm
No new posts What's plan, package, bind ? jackzhang75 DB2 2 Sun Feb 28, 2016 7:29 pm
No new posts DB2 plan for DSNTEP2 / DSNTEP4 Mainak_Dalal DB2 3 Thu Jan 21, 2016 1:08 am
No new posts Multiple COBOL-DB2 pragrams calling b... deepak_shrivastava DB2 1 Wed Jan 06, 2016 3:45 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us