Chapter 15. The DB2 Process Model

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

The DB2 Process Model: The Big Picture

Figure 15.1 shows the DB2 engine process model. This ...

Get Understanding DB2®: Learning Visually with Examples, Second Edition 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.