Chapter 16
A1: | Uncommitted read applications acquire an IN lock on the table but no row-level locks. |
A2: | The maximum requester I/O block size is 64K. |
A3: | You can configure DB2 to create some agent processes when DB2 is started by setting the NUM_INITAGENTS parameter to a value greater than zero. |
A4: | To ensure the integrity of your database, DB2 writes the log buffers to disk when:
|
A5: | Lock escalation will occur when:
|
A6: | You can capture table and index statistics:
|
Get Understanding DB2®: Learning Visually with Examples now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.