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

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

3637


What is dpf in db2?

1170


What is an instance database?

1098


Define data page.

1133


How do you simulate the explain of an embedded sql statement in spufi/qmf?

1144


What does runstats do in db2?

1188


When do you specify the isolation level?

1073


What is db2 optimizer?

1316


Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1142


Can we insert update delete in view?

1030


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

7207


What is db2? Explain.

1113


How to run db2 command in windows?

1248


What is a dbrm in db2?

1077


What does a deadlock mean in DB2?

1221