Chapter 2. Architecture 19
Database threads and processes
Each database within an instance has several threads and processes. The most
important ones are listed here:
db2pfchr is the buffer pool prefetch process. This handles bringing groups of
sequential pages into memory when prefetch occurs.
db2plcnr is the buffer pool page cleaner. This key process writes dirty pages
to disk asynchronously to prevent delays in bringing data pages into memory.
db2loggr manipulates log files for transaction processing and recovery from
failures.
db2loggw writes records to log files. This process maintains integrity in an
important way. If a hardware failure occurs and the system goes down, all
updates in memory would be lost; except, db2loggw keeps the logs ...