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:

  • One or more transactions commit

  • The log buffer is full

  • One second has elapsed since the last log buffer flush

A5: Lock escalation will occur when:

  • The database lock list becomes full

  • Any one application uses more than the MAXLOCKS percent of the lock list

A6: You can capture table and index statistics:

  • By running the runstats utility

  • When loading data into one of your tables ...

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.

Start your free trial