The performance problem when OS of Webserver is WindowsServer2012R2

Yasuyuki Inoue

Member
Hi!

We have two JDE EnterpriseOne 9.1 instance on TOOLS9.1 and 9.2 with two AS400 Enterprise/DB LPARS on V7R1.

<Cause>
After E1 Webclient login execution of SQL via a webserver(WindowsServer2012 R2) is slow.

<Oracle SR GCS comment>
The difference in the Tools versions (9.1.5.5 > 9.2.0.6), it's being talked about as a performance on the database driver side
such as problems of a performance in a JDBC connection of DB2 in Windows Server 2012 because the difference in the operating systems
by which a web server works (Windows 2008 / Windows 2012) seems caused, and query processing of a data base is related.

<Question>
The version of the jt400.jar is being changed and inspected variously, but the situation doesn't change.
Can there be someone who was the same phenomenon?

<Inspection>
●Performance is good. → WebServerOS is Windows2008 R2.

Case 1. ToolS9.1.5.5
 ・EnterpriseServer OS(AS400 V7R1) JDE E9.1 TOOLS9.1.5.5
 ・WebServer OS(WindowsServer2008 R2) JDE E9.1 TOOLS9.1.5.5 weblogic12

Case 2. TOOLS9.2.0.5
 ・EnterpriseServer OS(AS400 V7R1) JDE E9.1 TOOLS9.2.0.5
 ・WebServer OS(WindowsServer2008 R2) JDE E9.1 TOOLS9.2.0.5 weblogic12

Case 3. TOOLS9.2.0.5
 ・EnterpriseServer OS(AS400 V7R1) JDE E9.1 TOOLS9.2.0.5
 ・WebServer OS(WindowsServer2008 R2) JDE E9.1 TOOLS9.2.0.5 WebSphere Application Server V8.5



●Performance is bad. → WebServerOS is Windows2012 R2.

Case 4. ToolS9.1.5.5
 ・EnterpriseServer OS(AS400 V7R1) JDE E9.1 TOOLS9.1.5.5
 ・WebServer OS(WindowsServer2012 R2) JDE E9.1 TOOLS9.1.5.5 weblogic12

Case 5 TOOLS9.2.0.5
 ・ EnterpriseServer OS(AS400 V7R1) JDE E9.1 TOOLS9.2.0.5
 ・WebServer OS(WindowsServer2012 R2) JDE E9.1 TOOLS9.2.0.5 weblogic12

Case 6 TOOLS9.2.0.5
 ・EnterpriseServer OS(AS400 V7R1) JDE E9.1 TOOLS9.2.0.5
 ・WebServer OS(WindowsServer2012 R2) JDE E9.1 TOOLS9.2.0.5 WebSphere Application Server V8.5


Sincerely.
Y.Inoue from Japan.
 
Back
Top