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

Describe major components of db2?

739


If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

800


can all users have the privilage to use the sql statement select * (dml)?

731


What does sqlcabc has?

705


What is the maximum number of columns in a db2 table?

828






How to check last update on table in db2?

706


What is bufferpool in db2?

664


What are catalog tables in db2?

685


How do I optimize a query in db2?

710


What is release/acquire in bind?

732


What is the picture clause of null indicator variable?

772


What is runstats and reorg in db2?

903


What is the advantage in De-normalizing tables in DB2?

837


What types of tables are there in the db2 database?

652


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

700