Explain what a plan is?
Answers were Sorted based on User's Feedback
Answer / bhavna
A plan is an executable module containing the access path
produced by DB2 optimizer.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / s
An application program cannot run without a plan. A Plan is
created by BIND PLAN, by binding DBRMS, packages or DBRMS
and packages together.
| Is This Answer Correct ? | 1 Yes | 3 No |
Can you tell me how can you find out the # of rows updated after an update statement?
What is rebind in db2?
What is iseries database?
why should we bind the DB2 program . What if we did not BIND a BD2 program ??
9 Answers Infosys, TCS, Xansa,
what are the bind parameters?
what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names
What is an instance database?
What do you mean by between and in? Is between inclusive of specified range values?
How do I import a csv file into db2?
What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?
Why do we need reorg in db2?
List down the data types in the db2 database.