<div>
why RPG? &nbsp;ESB is language independent..<br />
<br />
When you say faced out do you mean phased out? <br />
<br />
using a debugger with a profiler will show you the slow areas
</div>


why RPG?  ESB is language independent..

When you say faced out do you mean phased out?

using a debugger with a profiler will show you the slow areas

Application Specialist 

Theo Kouwenhoven

<div>
<div class="content wysiwyg-content fr-view">
Hi Experts,<br><br>We developed some webservices with in middleware (ESB), that get DB2 data with SQL (jdbc) and present that to the caller.<br>Now this middelware is phased out, so I have to rewrite the same services in RPG.<br><br>I have the middleware sources so copied the SQL parts, but the result it's real slow.<br><br>If I test the middelware version, it runs within 2 seconds, the RPG version will take at least 10 second.<br>I suspect the SQL routines, is there a way to monitor that?<br><br><br><br><br>
</div>
</div>



Hi Experts,
We developed some webservices with in middleware (ESB), that get DB2 data with SQL (jdbc) and present that to the caller.
Now this middelware is phased out, so I have to rewrite the same services in RPG.
I have the middleware sources so copied the SQL parts, but the result it's real slow.
If I test the middelware version, it runs within 2 seconds, the RPG version will take at least 10 second.
I suspect the SQL routines, is there a way to monitor that?

Speedup program

RPGLE

IBM i, formerly known as AS/400, is a proprietary, midrange, object-based operating and application system. It includes a relational database, a menu-driven interface, support for multiple users, block-oriented terminal support and printers, and supports security, communications, and web-based application servers including Websphere, Apache and Tomcat.