as a good starter, please check SAP Note 1851832 DB6: Db2 10.5 Standard Parameter Settings.
If you apply the recommended settings, the system should be in a good overall shape. If tuning is still required, you can use the approach described in this IBM Whitepaper:Tuning and Monitoring Database System Performance.
The basic idea of the approach is to identify the are where your bottleneck is, follwed by a drill down to the relevant area. Instead of the Db2 native tolls, you can use the DBACOCKPIT.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.