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 |
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?
How to create backup table in db2?
On which levels locks can be applied?
How to resolve -502 sql code in DB2?
What is drop table?
What is the latest version of ibm db2?
What is cascading rollback?
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
What is host variable in db2 cobol?
What is reorg and runstats in db2?
What are the 4 environments which can access DB2 ?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.