Re: Profiling RPGLE programs

Pretty sure it's all RLA. But, the access paths are definitely on my list of potential issues.

Patrick posted a link to an IBM page that looks promising.

Roger Harman
COMMON Certified Application Developer - ILE RPG on IBM i on Power

--

From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of Alan Campin <alan0307d@xxxxxxxxx>
Sent: Wednesday, February 19, 2020 10:36 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Profiling RPGLE programs

File I/O or SQL? If SQL, run your SQL statements through Visual Explain.

There is a program trace utility from IBM. I am trying to find out what the

name is. Maybe somebody else knows. .



On Wed, Feb 19, 2020 at 10:13 AM Justin Taylor <JUSTIN@xxxxxxxxxxxxx> wrote:

I normally eyeball the code, identify likely culprits and have it write to

the joblog.  I iterate thru that process until I narrow down the cause.

HTH

-----Original Message-----

From: Roger Harman [mailto:roger.harman@xxxxxxxxxxx]

Sent: Wednesday, February 19, 2020 11:04 AM

To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>

Subject: Profiling RPGLE programs

I have a request from a sister division to look at (and, hopefully

improve) a program that is VERY long running - like 2 days long.

My first thought was I need to know the hot spots in the program but, in

all my years on this platform, I've never needed to profile a program.

Does anyone have any tips, a simple cheat sheet, or primer on the steps

involved?

Thanks!

Roger Harman

COMMON Certified Application Developer - ILE RPG on IBM i on Power

--

This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx

To subscribe, unsubscribe, or change list options,

visit: https://lists.midrange.com/mailman/listinfo/midrange-l

or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx

Before posting, please take a moment to review the archives

at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related

questions.

Help support midrange.com by shopping at amazon.com with our affiliate

link: https://amazon.midrange.com