Chapter 29. Tuning DB2’s Components
In This Chapter
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.
Tuning the DB2 Subsystem
The first level of DB2 tuning to be discussed in this chapter ...
Get DB2 Developer’s Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS, Sixth 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.