SQL Performance Monitors on iSeries over specific JDE UBE


Active Member

We have been using JDE 8.11 SP1 on AS400 V7R1 for a while now. However, the transaction volume has essentially quadrupled recently and we are trying to analyze the long running UBEs in JDE to make them run faster. I have tried to use the SQL Performance Monitor, but it seems like I can only capture the details for everything running on the system. I could not narrow it down to capture the sql analysis information for a specific UBE. When I did choose a specific UBE that was running on the AS400, the monitor did not gather any sql details.

Has anyone used this tool to analyze specific JDE jobs? If so, can you shed some light on how to set it up?

Prathibha Hanumali