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
 

 

Why we need to have a PLAN

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

Active User


Joined: 13 Jul 2006
Posts: 205
Location: At my desk

PostPosted: Thu Jul 13, 2006 2:19 pm    Post subject: Why we need to have a PLAN
Reply with quote

Hi,

Coud anyone explain the significance of having DBRM, PLAN.
Why we need to have a PLAN ?

Thanks in advance.

Regards,

Diwakar

Nobody is perfect . i am Nobody
Back to top
View user's profile Send private message

Hanfur

Active User


Joined: 21 Jun 2006
Posts: 104

PostPosted: Fri Jul 14, 2006 10:51 am    Post subject: Hi
Reply with quote

Its like ;we have a load module for to run a program so as like we need to have PLAN to access Tables.Its the only executable form which present in sketon cursor table of DB2.This would be loaded by the DB2 at the time
when want to run a batch db2 program.

You may need to provide a progname and Plan name correposnding to it for running that program.

PLAN simply contains the access paths which you obntain once you do the BIND with the DBRM.

-Han.
Back to top
View user's profile Send private message
sivaram.ch

New User


Joined: 28 Jun 2005
Posts: 11

PostPosted: Fri Jul 14, 2006 12:00 pm    Post subject:
Reply with quote

DBRMs(Exec Sql Statements) is the input for BIND process

BIND can be done as BIND PACKAGE & BIND PLAN which outputs PACKAGE & PLAN consequently.

PACKAGE is an accesspath(path of retrieving data from table)

PLAN consists of set of accesspaths & pointers(many packages & pointers).

Mostly BIND PLAN is prefered since A COBOL DB2 pgm will have so many EXEC SQL statements.we do have many DBRMs which has to be binded & has to generate many packages for those DBRMs.


I feel ur clear about PLAN.


Thanks
SRC
Back to top
View user's profile Send private message
diwa_thilak

Active User


Joined: 13 Jul 2006
Posts: 205
Location: At my desk

PostPosted: Sun Jul 16, 2006 12:26 pm    Post subject:
Reply with quote

HI,

Thanks Hanfur and sivaram.

Can you tell me when there will timestamp validation in this process.

The timestamp is to check whether the program has been modified or not?

Am i rt ?

When will be the PLAN created ? Do v have any spl options for this.

Regards,

Diwakar

Nobody is perfect . i am Nobody
Back to top
View user's profile Send private message
humpty
Warnings : 1

New User


Joined: 01 May 2005
Posts: 23

PostPosted: Mon Jul 17, 2006 5:57 pm    Post subject: Re: Why we need to have a PLAN
Reply with quote

friend,

FYI, we have a source code (COBOL + DB2 pgm). Here comes the precompiler into light. The precompiler branches the source code into two parallel streams. On one hand all the EXEC SQL statements are extracted into DBRM and on the other hand the source is converted into object module. As this instance the timestamp is generated for both the DBRM and the object module for consistency check.

Now the object module is compiled and link- edited , where as the DBRM is also BIND into PLAN / PACKAGE simultaneously.
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 Bind plan as a member to another bind... rexx77 DB2 0 Thu Feb 16, 2017 2:02 am
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


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