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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.