Multiple R47011 Jobs Simultaneously

[epost]

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]

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: [email protected]
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
[email protected]

 

[epost]

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]

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: [email protected]
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
[email protected]

 

[Bob_Schade]

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]

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: [email protected]
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
[email protected]