what is plan?
is plan executable or package?
Answers were Sorted based on User's Feedback
Answer / harsha
paln is nothing but collection of packages
paln is executable where package is non-executable
| Is This Answer Correct ? | 14 Yes | 3 No |
Answer / tej
A small correction for Harsha's answer
Plan can also contain DBRMs along with collections of packages.
and Yes,Plan is executable where as package is not.
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / nidhi
Plan and packages both are executable.
Package is the executable form of single DBRM while
multiple pacages or DBRM can be bind together through the
same plan.
| Is This Answer Correct ? | 2 Yes | 10 No |
Answer / hatam
A package contains control structures used to execute SQL
statements
A plan is
1- A list of package names
2- The bound form of SQL statements taken from one or more
DBRMs
package is executable and plan not
| Is This Answer Correct ? | 0 Yes | 19 No |
How can record locking be achieved in those DB2 versions which do not support it?
How many buffer pools are available in db2?
can we drop column from a table
Where is the access path logic created by the DB2 Optimizer stored?
Where are plans stored?
What is multi row fetch in db2?
i have a db2 variable how do u declare tht into working storage section ?
What is the role of schema in the db2 database?
what is different three logs in DB2?
what is Static and dynamic linking
why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2
How to execute stored procedures?