jdcmwilson
Well Known Member
JDE List,
I AM EXPERIENCING SERIOUS ENTERPRISE SERVER PERFORMANCE ISSUES. When trying
to do open sales orders loads into OneWorld using R47011 it takes me 1 hour
to load 600 records. A couple of weeks ago I was able to get 4000 loaded in
an hour. In comparing Oracle reads on the Dev box to Oracle reads on the
Prod box, the R47011 UBE does between 700 to 800 reads in the same amount of
time that the Prod box does between 15000 and 16000 reads. What do I look
for here? Is this Oracle, OneWorld, ???? We are not aware of what has
changed in the last couple of weeks to degrade our systems.
One thing that has brought this performance issue to light is that our
Development Enterprise Server runs much faster than our Production
Enterprise Server. Our Dev box is an IBM RS/6000 M80 with 2GB of RAM and 2
processors. Our Prod box is an IBM RS/6000 H80 with 8GB of RAM and 8
processors. It doesn’t take a rocket scientist to see that our Dev box
should not be performing markedly faster than our Prod box.
The only thing that I can think of that is different is that the PD7333
Central Objects on our Prod box were not created using the OneWorld scripts.
We attempted to do so and had problems so we created the COs manually.
All of our Control Tables and Business Data were copied from an environment
that already existed on our Dev box. Many times we do data copies from
environments on our Dev box to our Prod box using Oracle rather than JDE’s
R98403. It just seems to work faster and more reliably (is this part of our
problem?).
Additionally, we began with Security, System Tables, Data Dictionary and
Object Librarian on our Dev box but have since moved all but Security to our
Prod box. We are planning on making our Prod box the Security server
tomorrow. Should this make any difference?
I don’t know where to go next as we have been scratching our heads for some
time on this one. Any ideas, things to try, brain-storms, “gotchas” or any
other items to investigate would be greatly appreciated. We are planning
(trying) to go live on Oct. 1 but these performance issues are impeding our
progress.
James Wilson
CNC Consultant
OW Xe B73.3.3 SP16 AIX
IBM RS/6000 AIX 4.3.3 Enterprise Server (Central Objects)
Oracle DB 8.1.6.3
NT 4.0 Deployment Server
"fat" Win95/Win98 and TSE/Citrix "thin" clients
ZenWorks - using to deploy initial OneWorld clients
All views are expressly my own and in no way reflect those of my employer.
I AM EXPERIENCING SERIOUS ENTERPRISE SERVER PERFORMANCE ISSUES. When trying
to do open sales orders loads into OneWorld using R47011 it takes me 1 hour
to load 600 records. A couple of weeks ago I was able to get 4000 loaded in
an hour. In comparing Oracle reads on the Dev box to Oracle reads on the
Prod box, the R47011 UBE does between 700 to 800 reads in the same amount of
time that the Prod box does between 15000 and 16000 reads. What do I look
for here? Is this Oracle, OneWorld, ???? We are not aware of what has
changed in the last couple of weeks to degrade our systems.
One thing that has brought this performance issue to light is that our
Development Enterprise Server runs much faster than our Production
Enterprise Server. Our Dev box is an IBM RS/6000 M80 with 2GB of RAM and 2
processors. Our Prod box is an IBM RS/6000 H80 with 8GB of RAM and 8
processors. It doesn’t take a rocket scientist to see that our Dev box
should not be performing markedly faster than our Prod box.
The only thing that I can think of that is different is that the PD7333
Central Objects on our Prod box were not created using the OneWorld scripts.
We attempted to do so and had problems so we created the COs manually.
All of our Control Tables and Business Data were copied from an environment
that already existed on our Dev box. Many times we do data copies from
environments on our Dev box to our Prod box using Oracle rather than JDE’s
R98403. It just seems to work faster and more reliably (is this part of our
problem?).
Additionally, we began with Security, System Tables, Data Dictionary and
Object Librarian on our Dev box but have since moved all but Security to our
Prod box. We are planning on making our Prod box the Security server
tomorrow. Should this make any difference?
I don’t know where to go next as we have been scratching our heads for some
time on this one. Any ideas, things to try, brain-storms, “gotchas” or any
other items to investigate would be greatly appreciated. We are planning
(trying) to go live on Oct. 1 but these performance issues are impeding our
progress.
James Wilson
CNC Consultant
OW Xe B73.3.3 SP16 AIX
IBM RS/6000 AIX 4.3.3 Enterprise Server (Central Objects)
Oracle DB 8.1.6.3
NT 4.0 Deployment Server
"fat" Win95/Win98 and TSE/Citrix "thin" clients
ZenWorks - using to deploy initial OneWorld clients
All views are expressly my own and in no way reflect those of my employer.