why should we bind the DB2 program . What if we did not
BIND a BD2 program ??
Answer Posted / sangeetha
A bind plan contains the optimised access path to the DB2
resources for the application program.
Hence,the SQLs within the program will fail,if the
application program is not bound with a plan.
Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
What is a db2 collection?
What is isolation level in db2?
What is buffer pool in the db2 database?
What does db2 mean?
What is dbrm? When it will be created?
What is the difference between using bind () and rebind () methods of naming class?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is cursor with hold option in db2?
What is a bind in db2?
What is the difference between drop table and delete table?
What is the difference between plan and package in db2?
What are packages in db2?
What is scrollable cursor in db2?
What is copy pending and check pending in db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?