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 purescale?
Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2 how will we do this. We can create a single program and a single load for this program.
What is referential integrity?
Discuss about db2 bind?
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
what is difference between Plan and Package
How is deadlock resolved?
I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?
What is runstats and reorg in db2?
What is rct?
What are the prerogatives?
What does db2 mean?