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 |
What is db2 catalog database?
Are views updatable ?
How can you find out the # of rows updated after an update statement?
What is a system catalog table in db2?
How can you classify the locks in db2?
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
Mention data types used in db2 ?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is load replace in db2?
Where besides the DB2 catalog is database object information stored by DB2?
When do you specify the isolation level? How?
What are the benefits of using the db2 database?