What is an asychronous write?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is an asychronous write?

It is a write to disk that may occur before or long after a commit. The write is controlled by the buffer manager.

(Continued on next question...)

Other Job Interview Questions

• What are the four lockable units for DB2?
• Under what circumstances will DB2 allow an SQL satement ...
• What happens to the PLAN if index used by it is dropped?
• How will you delete duplicate records from a table ?
• What is subselect? Is it different from a nested select ?
• When is the skeleton cursor table created?
• Can we declare DB2 HOST variable in COBOL COPY book ?
• What is read-only cursor?
• What are the four lockable units for DB2?
• What are the different methods of accessing DB2 from TSO?
• More...