View previous topic :: View next topic
|
Author |
Message |
diwa_thilak
Active User
Joined: 13 Jul 2006 Posts: 205 Location: At my desk
|
|
|
|
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 |
|
|
Hanfur
Active User
Joined: 21 Jun 2006 Posts: 104
|
|
|
|
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 |
|
|
sivaram.ch
New User
Joined: 28 Jun 2005 Posts: 11
|
|
|
|
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 |
|
|
diwa_thilak
Active User
Joined: 13 Jul 2006 Posts: 205 Location: At my desk
|
|
|
|
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 |
|
|
humpty Warnings : 1 New User
Joined: 01 May 2005 Posts: 23
|
|
|
|
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 |
|
|
|