Re: SQL2JXL Utility

["Peter Dow (ML)" <maillist@xxxxxxxxxxxxxxx>]

Hi Greg,

I didn't do it myself, but I work with the guy who did it, and it solved 
the problem.  When I ran into, it was on my test AS400, so I just 
changed the subsystem maxjobs.

To change the subsystem it's:

CHGSBSD SBSD(QPGMR) MAXJOBS(2)

and to change the jobq entry:

CHGJOBQE SBSD(QGPMR) JOBQ(QPGMR) MAXACT(1)

However, I wouldn't go changing these on a production machine without 
knowing more about what other jobs use that subsystem.  Safer to create 
a separate test subsystem.

Peter Dow
Dow Software Services, Inc.
909 793-9050


Fleming, Greg (ED) wrote:
> Thanks Peter.
>
> I'll try that Monday when our system operator will be here to help me
> out.  I started to try it myself, but wasn't sure how to go about
> associating subsystems to job queues, nor could I find the maxjobs
> parameter for the job queue itself.  
>
> Did the solution work for you ? As you can tell, I don't have much
> operations knowledge as far as subsystems and queues go, but it seems
> like the single threaded job queue would still prevent the QJVACMDSRV
> job from running (I'm assuming it always tries to submit it to the same
> job queue the RUNJVA command was running in...if not, what job queue
> would it be submitted to ? ) .  
>
> Did you do this, or just find a way to run the job in a multi-threaded
> queue?
>
> Greg
>
> |-----Original Message-----
> |From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
> |On Behalf Of Peter Dow (ML)
> |Sent: Friday, March 30, 2007 3:39 PM
> |To: RPG programming on the AS400 / iSeries
> |Subject: Re: SQL2JXL Utility
> |
> |Hi Greg,
> |
> |I've run into that too.  One colleague's solution was to change the
> |subsystem to maxjobs(2) but with only a single job queue that has
> |maxjobs(1).
> |
> |*Peter Dow* /
> |Dow Software Services, Inc.
> |909 793-9050
> |pdow@xxxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxxx> /
> |
>
>