Answer / shweta agarwal

access path can be viewed by specifying the EXPLAIN
Parameter in the bind JCL as YES..
synatx

EXPLAIN(YES).

Answer / krishna

I think not possible. information about
access path stored in database catalog.
access path is stored in DB DIRECTORY, it can be used by
DB2 internally. no one can access the dB2 directory



if wrong please post right answer

what is a collection?

2 Answers  

---

How to restart a DB2 program?

0 Answers   Cognizant,

---

What are the levels of isolation available with DB2V4

2 Answers   IBM,

---

What language is db2 written in?

0 Answers  

---

What is the advantage in De-normalizing tables in DB2?

0 Answers  

---

select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?

2 Answers  

---

Normalization in DB2 – first normal form, second normal form

4 Answers   Virtusa,

---

What is copy book?

1 Answers   Thomson Reuters,

---

what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??

4 Answers   Xansa,

---

Where besides the DB2 catalog is database object information stored by DB2?

1 Answers  

---

Explain the contention situations caused by locks?

0 Answers  

---

What are the various isolation levels possible?

0 Answers  

---