Answer / sabahat khan

50 4K size Buffer Pool BP01 to BP49
10 8K size Buffer Pool 8KBP0 to 8KBP9
10 16K size Buffer Pool 16KBP0 to 16KBP9
10 32K size Buffer Pool 32KBP0 to 32KBP9

Answer / sunil1405

4 Buffer pools. BP0,BP1,BP2

How to access db2 tables in mainframe?

0 Answers  

---

How do you check for a null value in a db2 column?

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  

---

Update command

1 Answers  

---

When can an insert of a new primary key value threaten referential integrity?

2 Answers   Mind Tree,

---

i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process

2 Answers  

---

What are the functions of Bind?

2 Answers   Amdocs, IBM,

---

When is the results table for the query in a DECLARE CURSOR statement created?

5 Answers  

---

What is a cursor?

2 Answers  

---

max number of columns in a db2 table?

6 Answers  

---

Is the primary key a clustered index?

0 Answers  

---

What is a buffer pool?

2 Answers  

---