Answer / Mahesh Chandra

RCT (Related Chain Technology) in DB2 is a mechanism that allows related rows to be linked together in memory, improving performance for transactions that access or manipulate multiple rows within the same table. RCT reduces I/O operations by keeping frequently accessed rows in cache, making it faster to retrieve or update them.

How to create a table using embedded sql?

1 Answers  

---

What is the difference between oracle and db2?

1 Answers  

---

When Can you be sure that a query will return only one row?

4 Answers   IBM,

---

Define data page.

1 Answers  

---

Is it possible to precompile if db2 goes down?

4 Answers   Target,

---

what is commit & rollback? When and where is used while compiling a cobol-db2 program?

2 Answers  

---

What is host variable in db2 cobol?

1 Answers  

---

What is netezza database?

1 Answers  

---

i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?

2 Answers   EDS,

---

What is -904 sql code? How to resolve it?

3 Answers  

---

Explain in brief how does db2 determine what lock-size to use?

1 Answers  

---

Plan has the optimized access path in it. But is that optimized access path is attained or known

1 Answers   IBM,

---