RE: long running SQL RPG pgm

Jeff,

To see what access paths it's using, you just need to start debugging
against it (STRDBG UPDPROD(*YES)). If it's a batch job, you'll need to
start a service job against it before you start debugging. This will
cause the SQL run time to print out the debugging messages.

Matt

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Jeff Young
Sent: Thursday, October 20, 2005 12:09 PM
To: midrange-l@xxxxxxxxxxxx; rpg400-l@xxxxxxxxxxxx
Subject: long running SQL RPG pgm

I have an SQLRPGLE program that is taking a long time to run.
The program is using SQL in a number of places to get data from
different files.
Is there a tool available that can tell me where the program is spending
most of its time, and if in SQL, what access plan it is using?
 
Thanks,


Jeff Young 
Sr. Programmer Analyst
Dynax Solutions, Inc.
A wholly owned subsidiary of enherent Corp.
IBM -e(logo) server Certified Systems Exper - iSeries Technical
Solutions V5R2 
IBM  Certified Specialist- e(logo) server i5Series Technical Solutions
Designer V5R3
IBM  Certified Specialist- e(logo)server i5Series Technical Solutions
Implementer V5R3 

  
 








                
---------------------------------
 Yahoo! Music Unlimited - Access over 1 million songs. Try it free.