Chapter 28. Tuning DB2’s Environment
System tuning for DB2 performance can be applied outside DB2—to the environment in which DB2 operates—or inside DB2—to the components of DB2 or under DB2’s control. This chapter concentrates on the tuning of DB2’s environment.
Tuning the z/OS Environment
Operating system tuning is a complex task best accomplished by extensively trained technicians. All DB2 users, however, should understand the basics of z/OS resource exploitation and the avenues for tuning it. Operating system tuning, as it affects DB2 performance, can be broken down into four areas:
• Memory use
• CPU use
• I/O use
• Operating system environment parameters ...
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.
