Interested to Buy Any Domain ? << Click Here >> for more details...
Can we able to find all the Table names under a Particular
Plan?
- 1 Answers
- 6548 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What does a deadlock mean in DB2?
Differentiate between cs and rr isolation levels? Where do you specify them?
What is multi row fetch in db2?
what is db2 restart?
What is declare cursor?
How does a cursor work?
What is reorg and runstats in db2?
Can there be more than one cursor open for any program?
What is db2 and what is the use of db2 optimizer?
What is the purpose of rollback and commit?
What is meant by dclgen?
What are union and union all?
What is sqlca?
How to connect to db2 database from windows command line?
How do I add a column in db2?
