Re: i5 performance problems
- From: Mark S Waterbury <mark.s.waterbury@xxxxxxx>
- Date: Fri, 20 Mar 2009 16:51:56 GMT
Check QSYSOPR message queue (DSPMSG QSYSOPR) around the time the problem occurs, and see if you are getting messages like:
Interactive usage approaching installed capacity
Certain SQL queries over some files or tables that might not have all the necessary indexes could cause the system to build temporary indexes and this can be quite expensive in terms of CPU and I/O, and could help to push your system "over the limit" if someone is running SQL queries interactively (or embedded SQL in an interactive program).
You can also issue DSPLOG for a range of dates/times shortly prior to until somewhat after the last time the problem occurred, to see if any interesting messages show up there.
HTH
> tom wrote:
Hi..
My client works on 9771-MMA machine, i5OS 5.4.
From time to time they notice performance problems.
I check on WRKACTJOB scree that CPU usage is about 40%,
on WRKSYSSTS that DB util. is about 15%.
So everything looks fine.
They claims that their queries runs very slow (usually runs much faster).
What other thing shall I check. Maybe LAN utlization? How?
Regards,
Tomasz
- References:
- i5 performance problems
- From: tom
- i5 performance problems
- Prev by Date: Re: i5 performance problems
- Next by Date: Re: DB2 SQL function problem
- Previous by thread: Re: i5 performance problems
- Next by thread: EDTRBDAP *OPN problem/?
- Index(es):
Relevant Pages
|
