Answer / sravani

when sql statements are not changed but a new index is added or runstats is run,then it is advisable to do a rebind for the
best possible access path. rebind plan is cheaper than bind with action(replace)

How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.

7 Answers   TCS,

---

What is rct?

0 Answers  

---

Can we declare DB2 HOST variable in COBOL COPY book?

2 Answers  

---

what is difference between Plan and Package

1 Answers   Syntel,

---

if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..

4 Answers   IBM,

---

how 2 resolve the -311 sqlcode

1 Answers  

---

What are common abends

1 Answers   SPIC, Virtusa,

---

How to view db2 table structure?

0 Answers  

---

What is check constraint in db2?

0 Answers  

---

what is the sqlcode -501

5 Answers   IBM, Polaris, Zeus,

---

What is the difference between static and dynamic SQL?

1 Answers  

---

What is auditing?

2 Answers  

---