What is a DB2 plan?
- 8 Answers
- 43987 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jessica
A plan is an executable module containing the access path
logic produced by the DB2 optimizer. It can be composed of
one or more DBRMs and packages. Before a DB2 for z/OS
program (with static SQL) can be run, it must have a plan
associated with it.
Plans are created by the BIND command. The plan is stored in
the DB2 directory and accessed when its program is run.
Information about the plan is stored in the DB2 catalog.
| Is This Answer Correct ? | 88 Yes | 5 No |
Answer / sadiq afroze
An application plan or package is generated by the bind to
define an access path
| Is This Answer Correct ? | 64 Yes | 14 No |
Answer / guest
It establish relation between application program and DB2
tables.
| Is This Answer Correct ? | 53 Yes | 10 No |
Answer / shankar
Only PLANS are executable and not PACKAGES. You have bind
your package to a PLAN while executing.
| Is This Answer Correct ? | 33 Yes | 10 No |
Answer / vira raguram.i
a plan is an executable module containing the access path
logic produced by the db2 optimizer.it can have one or more
DBRMs or packages.
| Is This Answer Correct ? | 14 Yes | 2 No |
Answer / anil
A plan provides the channel between the aplication program
and the system which can be called up on call statements to
cobol for the sql code from db2 catalog when bind process
has done..
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / siri
BIND CAN HAPPEN TWO PROCESS...ONE IS PACKAGE...ANOTHER ONE IS PLAN....PLAN IS EXCUTABLE....WE BIND DBRM TO PACKAGE AND THEN INTO THE PLAN....WE BIND DIRECTLY DBRM TO PLAN...ONE DBRM IS CREATED FOR ONE PROGRAM....IN 10 DBRMS WE BIND INTO THE PLAN...IN 10 TIMES WE BIND INTO THE PLAN...IN CASE OF PACKAGE 10 DBRMS ARE BIND INTO THE PACKAGE AND THEN INTO THE PLAN ITS NO NEED TO BIND 10 TIMES..10 PACKAGES ARE INCLUDED IN ONE PACKAGE LIST..WE BIND ONE PACKAGE INTO THE PLAN AUTOMATICALLY 9 PACKAGES ARE BIND...PLAN IS EXCUTABLE...MEANS IT IS EXCUTABLE WITH LOAD MODULE...PLAN TIME STAMP TOKEN AND LOAD MODULE TIME STAMP TOKEN IF IT MATCH..THE PROGRAM IS EXCUTED...
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / ganesh
A db2 plan contains collections which in turn contains
packages.
A package contains the exectauble format of the sql
statements placed in the DBRM which was created during the
pre-comlie step.
| Is This Answer Correct ? | 9 Yes | 7 No |
How to solved 818 error
4 Answers Keane India Ltd, Wipro,
What do you do to keep the cursor from closing after a commit?
What is image copy in db2?
What else is there in the PLAN apart from the access path?
1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).
What is meant by repeatable read?
How to restart a DB2 program?
How do I import data from excel to db2?
when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations
If I have a view which is a join of two or more tables, can this view be updateable?
What is syscat in db2?
What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)
COBOL 
