Have you ever wondered what happens “behind the scenes” when your application connects to the data server? What handles the request? What actually does the work and returns you the results? When you check your system, you may see many threads spawned under the main DB2 system engine process. What are these threads, and what are they used for? Understanding the different DB2 threads and how DB2 works will help you determine the nature of a problem more easily.
In this chapter you will learn about:
The DB2 process model
The threaded engine infrastructure
The various types of DB2 agents
Monitoring and tuning the usage of DB2 agents
Figure 15.1 shows the DB2 engine process model. This ...