Writes are queued until a commit, checkpoint happens. Also when write thr

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

Question Posted / s

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

How can the duplicate values be eliminated from db2 select?

1155

What do you mean by between and in? Is between inclusive of specified range values?

1139

What is the difference between bind and rebind in db2?

1505

What is the information associated with sysibm.syslinks table?

1166

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1240

What is the syntax for FETCH in DB2 ?

1263

What is lock escalation in db2?

1078

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1156

What are union and union all?

1030

What is difference between rollback and commit?

1202

What is cursor in dbms?

1110

Why db2 is called db2?

1105

What parameters are used to control the free space in DB2?

1094

What is reorg and runstats in db2?

1259

What is explain plan in db2?

1048