You will need to repeat this process multiple times. Careful consideration should be given to this as well as the effect on operating system demands, e.g. paging rates, before implementing changes. A simple framework was outlined that enables identifying and tuning of the specific SQL statements causing the most pain in your system. Finally, realize that try as we do, problems still will occur. The best tuning efforts only can minimize the possibility of performance problems.
Variables do exist.
About the Authors John Wright is a product author in the DB2 Performance area at BMC Software. He has 15 years of data processing experience, the last eight years as a DB2 and IMS database professional.