SAPuF0E2 EarlyWatchuF0E2 Alert DB Performance

[Former Member]

Hello,

can anyone please guide on how can we correct the SAP EarlyWatch Alert obtained for DB Performance.

Locking for Partition 0

Parameters Description Current value Recommended value

locklist Maximum Storage for Lock Lists (4KB) AUTOMATIC 20000

maxlocks Max. Percent of Lock List for one appl. before esc. AUTOMATIC 90

Recommendation from report:: Adjust the DB2 parameters to the values given above.

how to achieve this?

Please guide on how to implement/analyse the Recommendation from SAP EarlyWatch Alert ??

Thanks,

[volker_deneke]

Hi, if you're not familiar with db2 administration, try google

http://webdocs.caspur.it/ibm/udb-6.1/db2d0/db2d0229.htm

best regards,

Volker