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...


Can we able to find all the Table names under a Particular
Plan?



Can we able to find all the Table names under a Particular Plan?..

Answer / vat

Absolutely! Just look at the catalog table SYSIBM.SYSPLANDEP

It's pretty straight forward! It recrods the dependencies
of plans on tables, views, synonyms, table spaces, indexes,
aliases, functions and stored procedures.

Is This Answer Correct ?    12 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is COPY PENDING status?

6 Answers  


In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)

9 Answers   IBM,


What is the picture clause of null indicator variable?

0 Answers  


What is explain in db2?

0 Answers  


What is the logical entity between plan and Package?

5 Answers  


What is deadlock?

2 Answers  


Where is the output of EXPLAIN stored?

2 Answers  


if i made sme changes in sub pgm wht r the things to be done for this ?

1 Answers   TCS,


wht is d/f between union and joins ?

2 Answers  


Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

0 Answers  


what is the differences between spufi and qmf and which is better?

4 Answers   Accenture, Cap Gemini,


In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?

2 Answers   Wipro,


Categories