Improving system performance on DB2

[#1]

Dears

I have set up a new system and increased the number of WP. Will increasing the number of update process help to improve performance.

Is there any way I can speed up my DB2 to handle more load or more requests per unit time ?

Thanks,

[Former Member]

> I have set up a new system and increased the number of WP. Will increasing the number of update process help to improve performance.

Not Exactly.

Performance tuning is really a wide concept, try to go through the guide -

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/60fe97e1-12e3-2c10-2f8d-ccb9a5450...

Thanks

[Former Member]

Hi Jay,

assuming your DB2 is running on Linux Unix or Windows, you have to set up your system according to note

1329179 DB2 v9.7 standard parameter settings (if your release is 9.5/9.1 check the linked notes)

You should also check the DBA guide

http://service.sap.com/operationsNW70 -> Database-Specific Guides

this note might be useful as well

25528 Parameter rdisp/max_wprun_time

your system should perform fine with this setup. If not, then you will have to make further adjustments depending on your requirements.

Let me know if your DB2 is running on mainframe (z/OS ,OS390 ), because the above recommendations wouldn't apply in this case.

regards, Javier