Can we able to find all the Table names under a Particular
Plan?
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 is explain plan in db2?
What type of database is db2?
What is a db2 table?
What is the difference between cursor stability and repeatable read isolation levels?
Explain about mirror activator disk mirroring?
can we view the access paths created by dbrm ? how ? thx
Is the primary key a clustered index?
What is node in db2?
Mention the definition of cobol in varchar field.
What is the latest version of ibm db2?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
define clustering index.
What is the difference between db2 and oracle?
What is db2 look?
What is null indicator in cobol db2?