Answer Posted / s

You can define:

50 4KB BP0-BP49
10 8KB BP8K0-BP8K9
10 16KB BP16K0-BP16K9
10 32KB BP32K0-BP32K9

The number of buffer pools you define is specific to the
DB2 sysbsystem and depends on the DB2 workload. If you dont
have enough real memory to support your bufferpools,
performance will affected severely because of paging.

Explain dclgen.

715

---

When do you specify the isolation level?

603

---

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

598

---

What is the purpose of using commit?

609

---

What are db2 objects?

630

---

---

What is a cursor in programming?

586

---

What is cloudant database?

636

---

How to view db2 table structure?

579

---

Is the primary key a clustered index?

600

---

What is bind and rebind in db2?

641

---

What is commit in db2?

587

---

How do I delete a column in db2?

669

---

What is check constraint. Explain with example.

637

---

Where can you declare a cursor in a cobol-db2 program?

598

---

What is scrollable cursor in db2?

574

---