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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.