Job Queue Design Guidelines

andrew_tulloch

Member
Hi List,

I’m looking for information to help design multiple job queues and/or multi-threaded job queues.

I’ve contacted PeopleSoft and frankly they weren’t much help. They sent me the Configuring Multiple Job Queues for Use by OneWorld and Xe Single Threaded UBEs but these tell me how to make the technical changes but not how to design job queues to increase performance and ensure that system results are accurate and maintain data integrity.

I’ve searched this forum for “job queue”. What else should I search for?

We’ve tried putting UBEs and BSFNs on different servers to help share the load but in some cases, performance was worse. ie, some BSFNs and UBEs should run on the same server.

Is there a best practices document somewhere that outlines groups of UBEs that update the same tables that should be run in the same queue?

EnterpriseOne 8.0, Update 1 (and a bunch of ESUs), SP 23_F1 on wintel with MS SQL 2000 sp3.

Thanks for your attention
Andrew
 
There is a document on the Peoplesoft web site that specifically states what
jobs should always run single threaded. We use two queues. For single
threaded jobs we use (QBATCH) which is the default. The other (REPORTS) is
used for informational reports only. The REPORTS queue is set up
multithreaded, in our case we have set up a maximum of three jobs running
simultaneously. Also, there have been improvements in GL posting process
that will allow multi-threading as well as boosting performance. See Below!



"The G/L Post (R09801) UBE has been modified for performance and now allows
the use of Parallel (Multi-Threaded Job Queue) Processing. The enhancement
is included in ESUs for SARs 6445633 for Xe and 6513122 for ERP 8.0. The
enhancement is included in ERP 8.9"



Cheers,



Crawford



B9 SP2, Windows 2000, SQL 2000




_____

From: [email protected] [mailto:[email protected]] On
Behalf Of andrew_tulloch
Sent: Thursday, November 04, 2004 7:53 AM
To: [email protected]
Subject: Job Queue Design Guidelines



Hi List,

I'm looking for information to help design multiple job queues and/or
multi-threaded job queues.

I've contacted PeopleSoft and frankly they weren't much help. They sent me
the Configuring Multiple Job Queues for Use by OneWorld and Xe Single
Threaded UBEs but these tell me how to make the technical changes but not
how to design job queues to increase performance and ensure that system
results are accurate and maintain data integrity.

I've searched this forum for "job queue". What else should I search for?

We've tried putting UBEs and BSFNs on different servers to help share the
load but in some cases, performance was worse. ie, some BSFNs and UBEs
should run on the same server.

Is there a best practices document somewhere that outlines groups of UBEs
that update the same tables that should be run in the same queue?

EnterpriseOne 8.0, Update 1 (and a bunch of ESUs), SP 23_F1 on wintel with
MS SQL 2000 sp3.

Thanks for your attention
Andrew

_____


The entire <http://www.jdelist.com/ubb/showflat.php?Cat=&Board=> JDELIST
thread is available for viewing.


This is the JDELIST EnterpriseOne Mailing List.
The instructions on how to unsubscribe from any JDELIST mailing list are
available here <http://www.jdelist.com/unsubscr.shtml> .
JDELIST is not affiliated with JDEdwards(r).
 
Back
Top