Chapter 14

A1: The db2ptree command. On Linux/UNIX platforms, you can also use the ps –ef command.
A2: The db2fmp process is the fenced-mode process for fenced UDFs and stored procedures. Fenced means it is executed outside of the address space of the DB2 engine. Should it misbehave, it is not able to overwrite DB2 internal buffers.
A3: It is the DB2 page cleaner process, db2pclnr.
A4: Subagents exist in partitioned database environment, or the database manager parameter intra-parallel = ON.
A5: If the total number of idle agents in the instance is less than NUM_POOLAGENTS, then the subagent changes its name from db2agntp to db2agnta and it is returned to the idle agent pool. However, it is still associated with the application. When needed, it is ...

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.