Skip to Content

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 30, 2014 at 04:05 AM

    Hi Experts,

    I would appreciate your reply

    Thanks in advance

    Add comment
    10|10000 characters needed characters exceeded