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

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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

Question Posted / p.j.karthikeyan


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 deadlock?

2 Answers  

WHAT IS MEANT BY COMMIT COMMAND?

7 Answers   Wipro,

Who uses db2?

0 Answers  

Name the different types of Table spaces.

5 Answers   IBM,

Mention the downsides of page level lock.

0 Answers  

What does db2 plan contain?

0 Answers  

What is cobol db2?

0 Answers  

How do you check for a null value in a db2 column?

2 Answers  

A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?

7 Answers   IBM,

What is schema in db2?

0 Answers  

What is reorg and runstats in db2?

0 Answers  

What will the FREE command do to a plan?

2 Answers  

For more DB2 Interview Questions Click Here
Categories