Lloyd, Its a conspiracy--at any given time, when interactive jobs reached a certain cpu usage % (>8 and <10). The governor kicks in--it consumes all available resources. CFINT is explained in detail in the document "CFINTnn Tasks Using CPU- -OS/400 RISC Server Model Behavior" at http://as400service.ibm.com/8625680A007CA5C6/0/A15FC571478B82018625676900555 DC1?Open&Highlight=2,15852625. Manuel Ortiz Newport Corporation -----Original Message----- From: LDEGNON@AMPRO.COM [mailto:LDEGNON@AMPRO.COM] Sent: Thursday, February 28, 2002 2: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 _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l or email: MAPICS-Lfirstname.lastname@example.org Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.