Chapter 28. Tuning DB2 s Components

Chapter 28. Tuning DB2's Components

IN THIS CHAPTER

• Tuning the DB2 Subsystem

• Tuning the Database Design

• Tuning the Application

• The Causes of DB2 Performance Problems

After ensuring that the z/OS and teleprocessing environments are tuned properly, you can turn your attention to tuning elements integral to DB2. This chapter discusses the three main DB2 components that can be tuned: the DB2 subsystem, the database design, and the application code. Although many tips and tuning techniques for SQL code already have been presented in Chapters 1 and 2, the additional tuning guidelines in this chapter can be used to augment your application tuning approach.