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


Please Help Members By Posting Answers For Below Questions

What is meant by dclgen?

618


Explain package in db2 and its advantages?

598


What is a db2 schema?

764


How do we specify index to include or not during bind process.

1674


What are types of indexes?

593






define clustering index.

617


What is the connection string to connect to the DB2 Database ?

614


What is the use of commit in db2?

634


What is bind package and plan in db2?

595


What is the use of runstats in db2?

577


How many databases are there?

592


What is cobol db2?

570


What is the max length of sqlca?

767


How many types of page locks can be held in db2?

593


What is role in db2?

620