RE: SQLRPG program taking too long

I had runtime issues once due to QAQQINI  (Query Optimizer options file)
someone had added to one of the prod libraries.  Depending on the JOBD that
was being used, the program would sometimes use the QSYS lib version of
QAQQINI, and other times used the variant in the prod lib.  It took me weeks
to track down the difference....

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: CWilt@xxxxxxxxxxxx [mailto:CWilt@xxxxxxxxxxxx]
Sent: Friday, June 04, 2004 3:57 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: RE: SQLRPG program taking too long


Wes,

I've seen some info before, possibly here or in the news group that
discussed some reasons why SQL worked differently between interactive and
batch.

May want to google for a NG article and/or search the archives.

If nothing else, try submitting a CL that runs STRDBG before calling the
SQLRPG.

HTH,
Charles


> -----Original Message-----
> From: Wes [mailto:small_du@xxxxxxxxx]
> Sent: Friday, June 04, 2004 4:03 PM
> To: rpg400-l@xxxxxxxxxxxx
> Subject: SQLRPG program taking too long
> 
> 
> Hi,
> 
> I have a SQLRPG program that if I submit it runs under 30min 
> but when it's
> run by Job Scheduler it takes more 16hrs. The user id has the 
> same privilage
> as I do. Is there something I'm missing?
> 
> Thanks, Wes
> 
> 
> 
> 
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) 
> mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
> 
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.