Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Performance factors for DB2

Hi ,

I understand that there are a lot of difference in the performance parameters for evaluation in oracle and DB2..example in ST04 .

dont see the below for DB2 10.5 in ST04 but available for oracle.

User/Recursive Call > 2 [Recursive call will get more over time

Read/User Call < 30 [> 30 means expensive SQL statements]

Time/User Call < 15ms

Busy time & CPU time ratio 60:40 ratio. Higher ratio means tuning required

Sort sections. It should be less than 0.1% of total sorts.

Please let me know the parameters to consider for DB2 in ST04/DB02

Thanks in advance

Not what you were looking for? View more on this topic or Ask a question