Re: SQLRPG program taking too long

[rob@xxxxxxxxx]

I wouldn't think so.  What makes you think that might be a possibility?

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





Alan <steelville@xxxxxxxxxxx> 
Sent by: rpg400-l-bounces+rob=dekko.com@xxxxxxxxxxxx
06/05/2004 06:03 AM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
cc

Fax to

Subject
Re: SQLRPG program taking too long






One more thing, besides the job queue, does it run in different 
subsystems, depending on who submits it?

- Alan


rob@xxxxxxxxx wrote:

>1)  There should be two messages in the joblog:  Submitted, and actually 
>started.  The job scheduler may have submitted it to a busy job queue?
>
>2)  When the job scheduler submits it.  Perhaps something else has a lock 

>on something.  Like your nightly backup.  While it is running check 12. 
>Work with locks, if active.  If it isn't a lock, other performance issue? 

>Perhaps your system runs a night/day job that switches around memory 
>pools?
>
>3)  Check the job description used by the job scheduler entry.  Thinks 
>like classes, etc may come into play here.
>
>
>Rob Berendt
> 
>

--
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.