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 ...