Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 db2 catalog database?

1004


What is a cursor in programming?

1028


What is the cobol picture clause of the db2 data types date, time, timestamp?

1034


What is release/acquire in bind?

1081


What is page size in db2?

937


Which isolation level provides maximum concurrency?

1118


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1011


How many databases are there?

1024


DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2810


What is alias in db2?

1013


What is dpf in db2?

1074


How can you find out the # of rows updated after an update statement?

1085


What is db2 and what is the use of db2 optimizer?

1016


What is db2 optimizer?

1204


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3547