Plan is an executable form of sql statements,But what
exactly resides inside a Plan. what are the details inside
Plan.
Answer Posted / 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 |
Post New Answer View All Answers
What is db2 command?
What is dpf in db2?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is the picture clause of null indicator variable?
What is a bind in db2?
What is innodb buffer pool?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
Describe major components of db2?
How can you do the explain of a dynamic sql statement?
What is release/acquire in bind?
Explain the benefits you can get from mainframe connect?
What is the connection string to connect to the DB2 Database ?
Before you give the explain statement, what are the prerogatives?