UBE processing Speed in One World

ckindree

Member
I was wondering what people's experience has been with report processing
times in One World? We have noticed that a report that only takes about 6
minutes to run in World takes about an hour in One World. If anyone could
tell me how long their financial reports run (eg. Trial Balance and Income
Statements) in One World so that we can compare that would be great. Any
insights that you could provide on how we can improve the performance would
also be appreciated.

We are on One World B7331 sp 7.1 in coexistance with World A7.3 Cum 11X1 on
an AS/400

Thanks in advance for your comments

Celeste Kindree
ERP Programmer/Analyst
Skyjack Inc.
 
We have found ube processing speeds within OW to be poor on an as400, as
compared to any other platform, and often recommend an NT batch server
for ube processing. Have you tried running it locally on a developer
workstation as a comparison?
Regards
Kieran Fitzgerakd
 
Is there anyway, i could find the processing time for UBEs APPs and other
objects in JDE. Does process monitor help in anyway ?
 
Unfortunately we have already tried that and locally on a development
workstation is even slower that running on the server.

Thanks anyway

Celeste Kindree
ERP Programmer/Analyst
Skyjack Inc.
 
That would offhand hit me as a JDE problem and NOT an AS/400 problem.



On Thu, 31 May 2001, [iso-8859-1] Sajaroff Sebastián wrote:
 
I don't know if this is a JDE problem or IBM problem, but you can increase
the speed of your UBE's by 5 to 10 times by using an application server
other than the AS/400.

Bill Williams
B7333 SP 15.0 - Coexistent A73 cume 11
Windows 2000 Deployment Server
Windows 2000 Application Server
Windows 2000 Citrix Server
 
We're not up on production yet and haven't done testing times on UBEs but someone told me you can play with the timeslice (keep decreasing and see if it helps) that the job runs in on the AS400 to aid in performance.

AS400 V4R5 Coexist
Xe SP15 002, 006/010, 007 oneoffs

I was wondering what people's experience has been with report processing
times in One World? We have noticed that a report that only takes about 6
minutes to run in World takes about an hour in One World. If anyone could
tell me how long their financial reports run (eg. Trial Balance and Income
Statements) in One World so that we can compare that would be great. Any
insights that you could provide on how we can improve the performance would
also be appreciated.

We are on One World B7331 sp 7.1 in coexistance with World A7.3 Cum 11X1 on
an AS/400

Thanks in advance for your comments

Celeste Kindree
ERP Programmer/Analyst
Skyjack Inc.




--------------------------
 
I have found that the business view used in financial reporting uses tables
indexed on the Account ID field (AID). Most data selection is a combination
of Business Unit, Object and Subsidiary. We created an alternate index on
F0901 and F0902 tables and found the time it took to run financial reports
to be increased dramatically.

Brian Martens
Senior Analyst
Marshall Erdman & Associates
AS400 V4
B7332 SP11.3
 
I would agree completely, i never said that there was an inherent flaw
in the AS/400 platform. I am merely saying that in a OneWorld
environment the AS/400 platform seems to perform poorly compared to less
well specified NT/UNIX servers, especially in the area of UBE processing
and package builds.
Regards
Kieran Fitzgerald
 
We use a timeslice of 2000 ms for our JDE UBE's. I don't know what JDE
does in their code, but on our system a UBE takes up 100% of a processor,
even on UBE's that should be IO bound.

By setting the timeslice to 2000 I force the job to let someone else have a
shot at the processor, enforced by the system, since JDE does not seem to
be 'well behaved'.

We have also written our own batch router to allow the UBE's to run in
parrell, we allow a maximum of 22 UBE's to run at a time. Our router
inquires on the job name, system user, JDE user, Environment, and path code
to send the UBE to the proper queue, we take into account the jobs that
cannot run simultaneously, taken from the KG white paper, and send them to
a single threaded queue.

Hope this helps someone.

Tom Davidson
B7332 SP 11.3, CO on DS, SQL 7.0, ES AS400 830 V4R5, TSE
Soon to be Xe SP 15.1

someone >told me you can play with the timeslice (keep decreasing and see
if it helps) that >the job runs in on the AS400 to aid in performance.




OW 7332 SP 11.3VER, NT 4.0 SP 5, TSE 4.0 SP 4, Metrframe 1.8, CO SQL 7.0
 
Tom,

Where can I find that specific whitepaper on the Knowledge Garden?
Thanks!

Mervin W. January
Supervisor, JDEdwards Applications Support
[email protected]
Tel: (972)373-1176
Pager: (214)401-1610
 
Mervin,

Search Knowledge Garden for 'single threaded UBEs'. There is one for 7331,
7332, 7333.

Tom

B73332 SP 11.3, AS/400 V4R5, NT 4.0, CO on SQL 7.0.
Soon to be Xe




OW 7332 SP 11.3VER, NT 4.0 SP 5, TSE 4.0 SP 4, Metrframe 1.8, CO SQL 7.0
 
Back
Top