How are write I/Os from the buffer pool executed?



How are write I/Os from the buffer pool executed?..

Answer / s

Writes are queued until a commit, checkpoint happens. Also
when write thresholds are exceeded, stop database, stop db2.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

How and when does the db2 enforces the unique key?

0 Answers  


in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

0 Answers  


How does cobol compile db2 program?

0 Answers  


What is a db2 cursor?

0 Answers  


What is the purpose of rollback and commit?

0 Answers  






What is difference between rollback and commit?

0 Answers  


Bind concepts in DB2 cobol

10 Answers   IBM, TCS, TRD, Virtusa,


What is a lock?

1 Answers  


Explain correlated sub-queries.

0 Answers  


What is pagespace?

1 Answers  


What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?

1 Answers   CTS,


database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please

1 Answers  


Categories