Chapter 26. The Five R’s

One of the most important contributors to the on-going efficiency and health of your DB2 environment is proper management of DB2 access path changes.

The access paths formulated by the DB2 optimizer during the BIND process are critical to your application performance. It is these access paths that determine how and how efficiently DB2 data is read and delivered to your program. Whether you are preparing a new program, implementing changes into your existing DB2 applications, upgrading to a new version of DB2, or simply trying to achieve optimum performance for existing applications, an exhaustive and thorough REBIND management process ...

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.