RE: SQL2JXL Utility

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