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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.