Re: SQL2JXL Utility

On 31/03/2007, at 6:26 AM, Fleming, Greg ((ED)) wrote:

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

The secondary job is NOT submitted. It is spawned. That's why it's a BCI (Batch-Immediate) job rather than a BCH (Batch) job. Spawned jobs don't go through a job queue. Thus the suggestion to set the job queue to MAXJOBS(1) but increase the MAXJOBS of the subsystem will work (at least for your immediate problem). You'll also need to ensure the activity level of the storage pool in which the jobs run is high enough to cope with the threads used by your Java application plus whatever other work is active in the storage pool at the same time.

Regards,
Simon Coulter.
--------------------------------------------------------------------
FlyByNight Software OS/400, i5/OS Technical Specialists

http://www.flybynight.com.au/
Phone: +61 3 9419 0175 Mobile: +61 0411 091 400 /"\
Fax: +61 3 9419 0175 \ /
X
ASCII Ribbon campaign against HTML E-Mail / \
--------------------------------------------------------------------