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
List out the data types available.
What are the different types of base tables?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
How to create backup table in db2?
What is explain plan in db2?
What is the physical storage length of the data types date, time, and timestamp?
Explain packages.
What is commit in db2?
How can deadlocks be resolved?
What is the physical storage length of timestamp data type?
What is the advantage in De-normalizing tables in DB2?
What is access path in db2?
What is a cursor in programming?
What is the max length of sqlca?
Describe major components of db2?