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 / vira raguram.i

a plan is an executable module containing the access path
logic produced by the db2 optimizer.it can have one or more
DBRMs or packages.

Is This Answer Correct ?    14 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is table space in db2?

1019


What is the max length of sqlca?

1216


What are foreign keys in db2?

1105


Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2727


What is a db2 schema?

1233


How and when does the db2 enforces the unique key?

1083


How do you eliminate duplicate values in db2?

1192


What is difference between isnull and coalesce?

1056


What are concurrency issues?

1097


Which component is responsible for processing sql statements and selecting access paths?

1127


What is db2 plan table?

1049


Is it possible using max on a char column?

1139


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?

8291


Explain in brief how does db2 determine what lock-size to use?

1045


What is temporal table in db2?

1041