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 could one combine a set of incremental image copies into a single copy?

1 Answers  

---

How does DB2 determine what lock-size to use?

2 Answers  

---

Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?

6 Answers  

---

can any one expalin check point with an example?

1 Answers  

---

How to check last update on table in db2?

1 Answers  

---

suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?

5 Answers   IBM,

---

What is cursor with hold option in db2?

1 Answers  

---

What's the maximum number of characters that a tablename can have?

3 Answers  

---

What is a storage group (stogroup)?

1 Answers  

---

in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?

3 Answers   Infosys,

---

What information is contained in a SYSCOPY entry?

2 Answers  

---

What are the Isolation levels possible ?

5 Answers  

---