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.

which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit

2 Answers   Accenture, Wipro,

---

When is the skeleton cursor table created?

1 Answers  

---

Mention and explain the contention situations caused by locks?

1 Answers  

---

What is a DB2 access path?

1 Answers  

---

How does DB2 use multiple table indexes?

1 Answers  

---

cursor with hold explain ?

1 Answers   Verizon,

---

How to create a table using embedded sql?

1 Answers  

---

What are the three DB2 date and time data types and their associated functions?

1 Answers  

---

how do you resolve -805?

3 Answers   HCL,

---

Where are plans stored?

2 Answers  

---

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

0 Answers  

---

What are the various isolation levels possible?

0 Answers  

---