Re: Job hangs after processing 220 records.

On 7/1/2014 12:45 PM, Marie O'Rourke wrote:

If I submit the following job using the Job Description the job hangs after processing 220 records.
SBMJOB CMD(CALL PGM(HQDOBJ/UMR_UPDATE)) JOB(PCODUMRUPQ) JOBD(QGPL/CQAJOBD) INLLIBL(*JOBD)

However if I manually set the library list and submit the job then the job completes without hanging.
SBMJOB CMD(CALL PGM(HQDOBJ/UMR_UPDATE)) JOB(PCODUMRUPQ)

This looks like a problem with the Job Description , but I don't have the slightest idea what to look for. The library list on the Job description is correct, but I don't understand all the other details.

The obvious first place to look is the library list. In particular,
imagine that one of the files in the failing job has a decimal data
error or similar issue that would make SQL unhappy. But read below...

SQL0901 Diagnostic 50 30/06/14 12:32:09.839561 QSQRUN3 QSYS *STMT QSQRUN3 QSYS *STMT
From module . . . . . . . . : QSQINS
From procedure . . . . . . : CLEANUP
Statement . . . . . . . . . : 31437
To module . . . . . . . . . : QSQINS
To procedure . . . . . . . : CLEANUP
Statement . . . . . . . . . : 31437
Message . . . . : SQL system error.
Cause . . . . . : An SQL system error has occurred. The current SQL
statement cannot be completed successfully. The error will not prevent
other SQL statements from being processed. Previous messages may indicate
that there is a problem with the SQL statement and SQL did not correctly
diagnose the error. The previous message identifier was MCH3603. Internal
error type 3109 has occurred. If precompiling, processing will not continue
beyond this statement. Recovery . . . : See the previous messages to
determine if there is a problem with the SQL statement. To view the
messages, use the DSPJOBLOG command if running interactively, or the WRKJOB
command to view the output of a precompile. An application program
receiving this return code may attempt further SQL statements. Correct any
errors and try the request again.

As far as I know, every instance of SQL0901 is a reason to call IBM
support. Before you do, make sure you are current on PTFs. They may
also ask you to send them some information that their database logger
captured: select * from QRECOVERY.QSQ901S

--buck