• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Multiple R47011 Jobs Simultaneously

epost

Active Member
Assuming no CPU/disk/database bottlenecks, what are thoughts/concerns on
running multiple R47011 jobs simultaneously, each with a different data
selection to increase total throughput of sales order lines?

Thanks,
Ethan Post
http://www.geocities.com/epost1

------------------------------------------------------------------------------
This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you.

==============================================================================
 

flyingmg

Active Member
My experience is that the overall throughput increases while individual v=
ersion throughput decreases. =20
=20
----- Original Message -----
From: epost
Sent: Tuesday, August 07, 2001 3:50 PM
To: jdelistml@jdelist.com
Subject: Multiple R47011 Jobs Simultaneously
=20
Assuming no CPU/disk/database bottlenecks, what are thoughts/concerns on
running multiple R47011 jobs simultaneously, each with a different data
selection to increase total throughput of sales order lines?

Thanks,
Ethan Post
http://www.geocities.com/epost1

-------------------------------------------------------------------------=
-----
This e-mail is intended for the use of the addressee(s) only and may cont=
ain privileged, confidential, or proprietary information that is exempt f=
rom disclosure under law. If you have received this message in error, pl=
ease inform us promptly by reply e-mail, then delete the e-mail and destr=
oy any printed copy. Thank you.

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D




--------------------------


MG
flyingMG@msn.com
 

epost

Active Member
It will be interesting to see how much of a bottleneck the JDE application
is but we are running this on a very powerful system. The commit rate is
high with all JDE jobs so Oracle writing to the logs (LGWR) is going to be
the bottleneck. If we can clear that up and increase the number of
processes that can access the key tables simultaneously for
update/insert/delete activity I think we can greatly increase the overall
speed of the job. Our primary concern is that the jobs will "behave" nicely
when run simultaneously. - E

rd=OW&Number=18233
 

flyingmg

Active Member
As far as your concern, multiple R47011 jobs can behave nicely when runn=
ing simultaneously according to my experience (I have more than 20 jobs).

Here is a precaution. Every job (version) should have its own data select=
ion. And if you are using more than one server, submit the same version t=
o ONLY one server. Or you may experience unpredictable results. For insta=
nce, duplicate records or jobs get killed because of dead locks.

Hopefully it helps. It's highly appreciated if you can share some of your=
performance statistics with me later on.
=20
----- Original Message -----
From: epost
Sent: Wednesday, August 08, 2001 6:31 PM
To: jdelistml@jdelist.com
Subject: RE: Multiple R47011 Jobs Simultaneously
=20
It will be interesting to see how much of a bottleneck the JDE applicatio=
n
is but we are running this on a very powerful system. The commit rate is
high with all JDE jobs so Oracle writing to the logs (LGWR) is going to b=
e
the bottleneck. If we can clear that up and increase the number of
processes that can access the key tables simultaneously for
update/insert/delete activity I think we can greatly increase the overall
speed of the job. Our primary concern is that the jobs will "behave" nic=
ely
when run simultaneously. - E

rd=3DOW&Number=3D18233



--------------------------


MG
flyingMG@msn.com
 
are all 20 running at the same time? have you really set up 20 queues to
handle so many concurrent jobs? if not, how many have you actually run
concurrently with success?

bob
 

flyingmg

Active Member
Yes, all are running at the same time across three application servers. E=
very app server has 10 single-threaded queues and 1 multi-threaded queue.=
=20
=20
----- Original Message -----
From: Bob_Schade
Sent: Thursday, August 09, 2001 8:55 AM
To: jdelistml@jdelist.com
Subject: RE: Multiple R47011 Jobs Simultaneously
=20
are all 20 running at the same time? have you really set up 20 queues to
handle so many concurrent jobs? if not, how many have you actually run
concurrently with success?

bob




--------------------------


MG
flyingMG@msn.com
 
Top