[JDE] Create a JDE Load Balancer using Apache’s httpd

How to setup a HTTP Load Balancer for JDE using the open source Apache httpd webserver. Your Apache must have the following core modules enabled: mod_rewrite, mod_headers, mod_proxy, mod_proxy_http, mod_proxy_balancer You may need to adjust the following settings: ServerName ServerAlias DocumentRoot <Directory> (to match DocumentRoot) BalancerMember (list the URL for each of your JDE instances) …

[SQL] Identify & Disable “Expensive” JDE Indexes

About By default, JDE creates a lot of database table index definitions.  When the “Generate Table” command is used in OMW, all of the JDE-defined Indexes are generated along with it.  But why does JDE have so many indexes to begin with? The reason for all of those predefined indexes really comes down to design …

[SQL] JDE Scheduler Super Query

Purpose Display all jobs in the JDE Scheduler system in an efficient & easy-to-read format. About Like most of the applications in JDE that were built for system administrators, the JDE Scheduler Application P91300 is pretty awful to use.  Critical information is scattered throughout several different screens without one good screen to overview the entire …

[SQL] Re-Balance F4229 “Sales As-Of” File

Purpose Re-balance the JDE F4229 “Sales As-Of” file based on actual details in the F42119 Sales Detail History file.  This should be used to maintain reporting accuracy if you have directly modified Sales Detail History in F42119. About JDE maintains a Sales History Summary in the file F4229 that is used to help increase reporting …

[SQL Server] Quick Table Data Copy

[SQL Server only] Purpose Quickly copy data for 1 or more tables from one database to another.  This is useful for performing partial data refreshes between environments. About This query is optimized for speed.  For each table: disable all indexes, truncate table, copy data from source, rebuild indexes. Usage Specify table(s) to be refreshed in …