Answer / s

Depends on how many Buffer pools you would like to define
to the system. You can use upto 50 4KB and 10 8KB, 10 16KB
and 10 32KB bufferpools

The minimum buffer pool storage that DB2 allocates
4KB 2000 pages
8KB 1000 pages
16KB 500 pages
32KB 250 pages

What is the result of open cursor statement?

0 Answers  

---

How to handle null values in db2

4 Answers  

---

Give the COBOL definition of a VARCHAR field.

2 Answers  

---

If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?

1 Answers   RBS,

---

What is auditing?

2 Answers  

---

---

What is image copy?

1 Answers   Virtusa,

---

What are the full forms of spufi and dclgen and why are they used?

0 Answers  

---

OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.

1 Answers   Syntel,

---

What does the RUNSTATS Utility do?

4 Answers  

---

Name some fields from SQLCA.

2 Answers  

---

What is db2 look?

0 Answers  

---

How will you delete duplicate records from a table?

7 Answers   Google,

---