O'Reilly logo

Understanding DB2®: Learning Visually with Examples, Second Edition by Dwaine R. Snow, Michael Dang, Xiaomei Wang, Raul F. Chong

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required