What is buffer pool in the db2 database?

0 Answers  

---

What is blu acceleration in db2?

0 Answers  

---

select distinct(empid),distinct(dept),name from EMP will the above query work?

2 Answers   CTS,

---

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

2 Answers  

---

When is the authorization check on DB2 objects done - at BIND time or run time?

1 Answers  

---

What does DSNDB07 database do?

2 Answers  

---

If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?

8 Answers   Accenture,

---

How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)

2 Answers  

---

wht happens if we close cursor with cursor with hold option?

3 Answers   Valtech,

---

how do we solve soc 7 and soc4 ?

3 Answers   Tech Mahindra,

---

What is a db2 collection?

0 Answers  

---

Write a query to extract first 5 characters of a name in the column Stud_Name?

1 Answers   RBS,

---