IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Why we need to have a PLAN


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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
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
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
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts current batch plan DB2 3
No new posts Log an Plan name/id or Job Id using D... DB2 1
No new posts Usage/Utiliy of Plan in DB2 DB2 4
No new posts How do I define a DB2 plan for a web ... CICS 5
No new posts Finding the plan when code compiled u... DB2 2
Search our Forums:

Back to Top