Answer Posted / s
Updated pages are not written immediately to the DASD. Upto
32 pages can be written with 1 I/O and is called a deferred
write. Asychronous means the SQL request does not wait for
the Write I/O to happen.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the use of dclgen in db2?
Is schema the same as database?
Outputs of explain are with matchcols = 0. What does this signify?
When the like statement is used?
Explain the contention situations caused by locks?
What are host variables in db2?
Which command is used to remove all rows from a table?
What is a db2 package?
Where do you specify them?
What are packages in db2?
Give a brief description of db2 isolation levels?
What is dbrm library?
What are catalog tables in db2?
How can the duplicate values be eliminated from db2 select?
What is lock escalation in db2?