Plan is an executable form of sql statements,But what
exactly resides inside a Plan. what are the details inside
Plan.
Answers were Sorted based on User's Feedback
Answer / vaibhav
Plan contains DBRM(machine level SQL statements) and
Optimized Access Path.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / mehdee
. Plans are created by BIND command on sysibm.sysplan. To
execute a package, you must 1st include it in the package
list of a PLAN, so they are only executed when the plan in
which they are contained executes.
PACKAGEs are related to a PLAN, and PLANs are related to
a COLLECTION-ID. So when we REBIND a Package we do not need
to BIND REPLACE the Plan.
Is This Answer Correct ? | 0 Yes | 0 No |
What is Declaration Generator(DCLGEN)?
What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
Explain the contention situations caused by locks?
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)
What does runstats do in db2?
how to execute qcmdexc in rpgle?plz write code also?
i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is the syntax for FETCH in DB2 ?
Is db2 relational database?
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?