Is this normal for a prestart job as user faced problem while executing the
query .
Job 701969/QUSER/QSQSRVR started on 12/09/09 at 13:35:43 in subsystem
QSYSWRK in QSYS. Job entered system on 12/09/09 at 13:35:43.
Prestart job ending due to maximum use.
Job 701969/QUSER/QSQSRVR ended on 12/09/09 at 13:36:42; 1 seconds used; end
code 10 .
Main job which is running in the QCMN subsystem intiates this PJ jobs
(QSQSRVR) whenever user wants to execute the SQL queries.
Following is the important paramter associted with this PJ job in QSYSWRK
subsystem
Program . . . . . . . . . . . . . . . . . . . . :
QSQSRVR
Library . . . . . . . . . . . . . . . . . . . :
QSYS
User profile . . . . . . . . . . . . . . . . . . :
QUSER
Job . . . . . . . . . . . . . . . . . . . . . . :
QSQSRVR
Job description . . . . . . . . . . . . . . . . :
QDFTSVR
Library . . . . . . . . . . . . . . . . . . . :
QGPL
Start jobs . . . . . . . . . . . . . . . . . . . :
*NO
Initial number of jobs . . . . . . . . . . . . . :
5
Threshold . . . . . . . . . . . . . . . . . . . :
2
Additional number of jobs . . . . . . . . . . . :
2
Maximum number of jobs . . . . . . . . . . . . . :
*NOMAX
Maximum number of uses . . . . . . . . . . . . . :
1
Wait for job . . . . . . . . . . . . . . . . . . :
*YES
User wanted to update a Table but was not getting any results.Can the above
message may cause the query job to just end.As far as i understand Prestart
Job will end after one use ( MAx use =1) and new one will create. But then i
do not get why this PJ started and ended doing nothing.
Rhishabh
As an Amazon Associate we earn from qualifying purchases.