Re: Profiling RPGLE programs

[Roger Harman <roger.harman@xxxxxxxxxxx>]

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

>