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 stability?

1 Answers  

---

what is the difference between normal select query and currosor

2 Answers   Cap Gemini, TCS,

---

What is index in db2?

1 Answers  

---

What does the RUNSTATS Utility do?

4 Answers  

---

What does it mean if the null indicator has -1, 0, -2?

1 Answers  

---

What are union and union all?

0 Answers  

---

how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none

8 Answers   Amdocs, HeadStrong,

---

What is meant by concurrency?

1 Answers  

---

How does cobol compile db2 program?

0 Answers  

---

What are the two types of logging in the db2 database? Explain them.

0 Answers  

---

Are views updatable ?

4 Answers  

---

how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example

1 Answers   CTS,

---