|
View previous topic :: View next topic
|
| Author |
Message |
rashmi.ranjan75
New User
Joined: 20 Feb 2006
Posts: 34
|
|
|
|
Hi,
We have a batch program running in tso env.
This batch has got some performance issue in production and after analyzing the db2 performance report i have seen that in two dbrm
SYNCHRONOUS I/O is too high for the quries. This is simple delete stament on index.
So could anybody give some suggestion about improving it's performance.
Thanks & Regards
Rashmi |
|
| Back to top |
|
 |
meetreks
New User
Joined: 28 Sep 2006
Posts: 26
Location: Edinburgh
|
|
|
|
Can we have some more information like EXCP count and I/O expense??
ALso if possible can you share the SQL statements and DDL for tables and Index? |
|
| Back to top |
|
|
|
|
