Re: system slow down.

["Clare Holtham" <Clare.Holtham@xxxxxxxxxxxxxx>]

Does your application use SQL? Have you had the database tuned? (i.e.
indexes created) If not, maybe the SQL Optimizer is creating an index
dynamically over a large file. You can usually spot this (IDX_XXXX) on
WRKACTJOB. The solution is to use the database monitor (STRDBMON) to work
out what indexes your system needs, and then create them permanently.

Hope this helps,

Clare

Clare Holtham
Director, Small Blue Ltd - Archiving for BPCS
Web: www.smallblue.co.uk
IBM Certified AS/400 Systems Professional
E-Mail: Clare.Holtham@xxxxxxxxxxxxxxx
Mobile: +44 (0)7960 665958

----- Original Message -----
From: "Lonnie Kendall" <Lkendall@xxxxxxxx>
To: <midrange-l@xxxxxxxxxxxx>
Sent: Wednesday, March 17, 2004 10:42 PM
Subject: system slow down.


Every once in awhile our systems interactive will slow down for no reason.
I have done the wrksysact and the cfin01 is not using any more cpu's then
normal.  Does anyone have any idea what I could check to find out what is
causing this?

Lonnie Kendall
Gary-Williams Energy Corporation
lkendall@xxxxxxxx
www.gwec.com
(303) 628-3800 ext 471

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.