What is a DB2 plan?

Answer Posted / shankar

Only PLANS are executable and not PACKAGES. You have bind
your package to a PLAN while executing.

Is This Answer Correct ?    33 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is bufferpool in db2?

576


What is null value in db2?

563


What is the use of commit in db2?

628


Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

6822


What is drop table?

582






How to view db2 table structure?

587


What is sqlca’s maximum length?

670


What is the max length of sqlca?

760


Which is faster delete or truncate?

673


What is an instance in db2?

563


What is the role of the data page in the db2 database?

585


How to restart a DB2 program?

1356


What are the various data types available in db2?

630


What is the physical storage length of date data type?

724


What is meant by explain?

660