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
How to find the number of rows in a db2 table?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is buffer pool in the db2 database?
What is the difference between oracle and db2?
How to find schema of a table in db2?
What is bind in db2?
What is a system catalog table in db2?
What is a page in db2?
What is runstats and reorg in db2?
How to resolve deadlock issue
What type of database is db2?
What are the two types of logging in the db2 database? Explain them.
What is meant by union and union all?
Give a brief description of db2 isolation levels?