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

Question Posted / guest

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

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

More DB2 Interview Questions

Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?

What is the use of predicate?

What is the physical storage length of time data type?

How to check table size in db2 sap?

What does DML stand for and what are some examples of it?

How can you do the explain of a dynamic sql statement?

Are view updateable?

what are the SQL codes u freequently got?

what is the difference between declaring the cursor in WS section and Procedure division?

What is the difference between cursor stability and repeatable read isolation levels?

Explain the EXPLAIN statement?

List down the data types in the db2 database.

For more DB2 Interview Questions Click Here