DB2 deadlock detector (db2dlock): 

This is the database deadlock detector process. It scans the lock list (the lock 

information memory structure of DB2) and looks for deadlock situations.

Application level processes

These processes are started for each application connecting to the database:

DB2 communication manager (db2ipccm): 

This is the inter process communication (IPC) process started for each 

application connecting locally. This process communicates with the 

coordinating agent to perform the database tasks.

DB2 TCP manager (db2tcpcm

): 

This is the TCP communication manager process. This process is started 

when the remote client or applications connect to the database using TCP/IP 

communication. This process communicates with the coordinating agent to 

perform database tasks.

DB2 coordinating agent (db2agent)

: 

This process handles requests from applications. It performs all database 

requests on behalf of the application. There will be one db2agent per 

application unless the connection concentrator is established. If intra partition 

parallelism is enabled, the db2agent will call DB2 subagents to perform the 

work.

DB2 subagent (db2agnta): 

The subagent, which works with the db2agent process when intra partition 

parallelism is enabled.

Active subagent (db2agntp): 

This is the active subagent that is currently performing work. This process is 

used when enabling SMP parallelism, which means having more processes 

achieving the same task. In order to enable this feature in DB2, we must set 

the intra parallelism database parameter to 

YES

.

DB2 database objects

In this section, DB2 objects and their relationship to each other are introduced. 

Figure 1 4 shows the basic DB2 database objects. 

10 

MySQL to DB2 UDB Conversion Guide