8 OnDemand SQL Performance Analysis Simplified on DB2 for i5/OS in V5R4
The application of new program temporary fixes (PTFs)
An upgrade to a newer i5/OS release
Changes to system values
In this book, you learn how to use some tools to gather performance information prior to any
major change on the system. You learn how to determine SQL performance problems in
cases where previously there was a good working situation or where you are unsure whether
you previously had a good working situation. In a scenario where you know that you had
satisfactory performance, it is vital to document the timeline of what happened since the
system or application last ran well. Make sure that you document any changes, such as those
that we previously listed. ...