RE: EFFECTS OF ODBC CALLS

["Shaw, Dave" <dshaw@xxxxxxxxxxxx>]

Lloyd,

When this happens, there's a low-level task running that isn't assigned to
any active job.  In order to see what it is, you really need to use the
WRKSYSACT command that's included with Performance Tools (57xxPT1), or
something equivalent.  It could be related to ODBC, or it could be something
else entirely - it's all speculation until you know what task(s) are running
when it happens.

Dave Shaw
MAPICS-L Moderator
Rauch Industries, Inc.
Gastonia, NC

-----Original Message-----
From: LDEGNON@AMPRO.COM [mailto:LDEGNON@AMPRO.COM]
Sent: Thursday, February 28, 2002 5:44 PM
To: MAPICS-L@MIDRANGE.COM
Subject: EFFECTS OF ODBC CALLS


What are the effects of ODBC Calls on an AS/400?  I am trying to research
just
why our AS/400 seems to slow down so badly (%CPU 100% in WRKSYSSTS) when, in
WRKACTJOB, there appears to be only minuscule jobs running that add up to
less
that 10%????

Due to a Rogue Programmer that no longer works here, we have, at any given
time,
upwards of ten users, accessing MAPICS table data from various applications
that
are using Windows ODBC.


Any ideas????


Lloyd H. Degnon
I. S. Manager
Ampro Computers Inc.
5215 Hellyer Ave
San Jose, CA 95138
408.360.4365
Ldegnon@ampro.com
WWW.AMPRO.COM