
Chapter 8. Performance tuning 201
issues you can run into during production. Also, the first few changes might
take the least amount of time to figure out and provide the biggest return. As
you keep tuning, the amount of time taken increases while the amount of gain
starts to decrease.
Make the right goals
Setting an arbitrary goal such as all transactions under three seconds sounds
nice in theory, but might be a costly one to achieve. Set the expectation for
users and understand what you need to do to achieve them. The unreachable
goals become visible especially at month-end or quarter-end report times.
For known issues with DB2 UDB on AIX, ...