Answer / s

Data pages sizes can be 4KB,8KB,16KB or 32KB.

Answer / lakshmisudha

each data page size can be 4kb only after completion of
first page only moves the data in second page

How does DB2 determine what lock-size to use?

2 Answers  

---

When would you prefer to use VARCHAR?

3 Answers  

---

What is a correlated sub query?

2 Answers  

---

What is a base table?

2 Answers  

---

I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?

4 Answers  

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers   HeadStrong,

---

How do you concatenate the firstname and lastname from emp table to give a complete name?

0 Answers  

---

What will the DB2 optimizer do?

2 Answers  

---

What is access path in db2?

0 Answers  

---

What are the disadvantages of PAGE level lock?

3 Answers  

---

Is db2 free?

0 Answers  

---

What is rct?

0 Answers  

---