Answer / s

QUIESE is used to establish a consistency point for the
named tablespaces. It issues a drain lock to disallow any
further processing and allows the currently executing UOW
to commit. Writes all the changed pages from the buffer to
DASD. The RBA is noted in the SYSCOPY.

Answer / sunil1405

Its an utility to flush all the buffers

What is cursor?

2 Answers  

---

Explain in detail about buffer manager and its functionalities?

0 Answers  

---

Explain the EXPLAIN statement?

1 Answers  

---

what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)

4 Answers   IBM,

---

Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.

1 Answers  

---

What is the difference between a package and a plan?

6 Answers   Infosys, L&T, Mphasis,

---

What is the role of the data page in the db2 database?

0 Answers  

---

Explain package in db2 and its advantages?

0 Answers  

---

What are db2 objects?

0 Answers  

---

Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.

3 Answers   IBM,

---

Is it mandatory to use DCLGEN? If not, why would you use it at all?

2 Answers  

---

Explain about rct.

0 Answers  

---