What is a DB2 plan?

Answer Posted / siri

BIND CAN HAPPEN TWO PROCESS...ONE IS PACKAGE...ANOTHER ONE IS PLAN....PLAN IS EXCUTABLE....WE BIND DBRM TO PACKAGE AND THEN INTO THE PLAN....WE BIND DIRECTLY DBRM TO PLAN...ONE DBRM IS CREATED FOR ONE PROGRAM....IN 10 DBRMS WE BIND INTO THE PLAN...IN 10 TIMES WE BIND INTO THE PLAN...IN CASE OF PACKAGE 10 DBRMS ARE BIND INTO THE PACKAGE AND THEN INTO THE PLAN ITS NO NEED TO BIND 10 TIMES..10 PACKAGES ARE INCLUDED IN ONE PACKAGE LIST..WE BIND ONE PACKAGE INTO THE PLAN AUTOMATICALLY 9 PACKAGES ARE BIND...PLAN IS EXCUTABLE...MEANS IT IS EXCUTABLE WITH LOAD MODULE...PLAN TIME STAMP TOKEN AND LOAD MODULE TIME STAMP TOKEN IF IT MATCH..THE PROGRAM IS EXCUTED...

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the physical storage length of date data type?

729


What language is db2 written in?

595


Are view updateable?

627


Mention the various locks that are available in db2.

616


Define sqlca.

648






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

614


B37 abend during spufi?

981


How do I import a csv file into db2?

560


Explain the function done by data manager?

856


What are the full forms of spufi and dclgen and why are they used?

656


can we view the access paths created by dbrm ? how ? thx

6252


What is database manager in db2?

551


What is the difference between using bind () and rebind () methods of naming class?

792


What is an instance database?

600


What is check constraint in db2?

608