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
Who uses db2?
How can you classify the locks in db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Explain package in db2 and its advantages?
Is ibm db2 open source?
How to create backup table in db2?
How to create db2 table in mainframe?
What is deadlock in db2?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is the role of the data page in the db2 database?
What is isolation level in db2?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
Define predicate?
Explain the contents that are a part of dclgen.
what are bind concepts in db2 cobol?