Batch Processor ends with RC=04 executing a RC/Migrator script and will not continue
Article ID: 11845
Updated On:
Products
Issue/Introduction
Execution of a RC/Migrator for Db2 for z/OS (RCM) script ends after unload of some tables with these messages:
UNLD002I *** ROWS UNLOADED = 27,521, LIMIT = ALL
UNLD004I *** UNLOAD EXECUTION COMPLETE, TIME: 10:29:01
RETCODE = 4
CONTROL PROCESS CARD:
BATCH PROCESSOR PLAN ===> RBPAxxxx
BATCH PROCESSOR ID ===> xxxxxx.RCM.STRAT-xxxxxx
STRATEGY NAME ===> xxxxxx.xxxxxxx
DEVICE ALLOCATION UNIT => SYSDA
BPA0144I: FINAL LOG RECORD WRITTEN FOR SUBSYSTEM ===> ssid.
BPA0144I: FINAL LOG RECORD WRITTEN FOR SUBSYSTEM ===> ssid.
***** RESTART POINT ESTABLISHED AT SYNC VALUE 15 *****
***** BATCH PROCESSOR INCOMPLETE WITH WARNINGS *****
What is wrong and how to continue?
Resolution
Note the last line in above message: BATCH PROCESSOR INCOMPLETE WITH WARNINGS
Scrolling up reveals the warning, for example: UNLD061W *** TRUNCATION/DISCARD MAY OCCUR FOR COLUMN MODIFICATION_TYPE
Look for the .OPTION in the top of the output or the JCL
.OPTION NOERRORS NOSQLERRORS RETRY(05) NOBINDERRORS
NOERRORS at the start of an input data set, causes Batch Processor to end whenever a non-zero return code is encountered from a process
that is not covered by the DISCARDS|NODISCARDS or BINDERRORS|NOBINDERRORS parameters.
Change this option to ERRORS and the job will continue despite warnings.
ERRORS at the start of an input data set, causes Batch Processor to continue processing when a return code of 4 or less is encountered
from a process that is not covered by the DISCARDS|NODISCARDS or BINDERRORS|NOBINDERRORS parameters.
Additional Information
Here is a description from the ‘Use the Batch Processor' Commands, Options:
ERRORS|NOERRORS
Determines whether processing ends when errors are encountered. ERRORS at the start of an input data set, causes Batch Processor to continue processing if a return code of 4 or less is encountered from a process that is not covered by the DISCARDS|NODISCARDS or BINDERRORS|NOBINDERRORS parameters.
NOERRORS at the start of an input data set, causes Batch Processor to end whenever a non-zero return code is encountered from a process that is not covered by the DISCARDS|NODISCARDS or BINDERRORS|NOBINDERRORS parameters. NOERRORS is the default.
Note: These parameters have no control over the processing from BIND return codes.
OPTION Command—Define Batch Processor Processing Options
Use the online panel to submit the job, this option is set with field CONTINUE IF: WARNING
CONTINUE IF:
-WARNING ===> Y
-SQL ERROR ===> N
-BIND ERROR ===> N
-LOAD DISCARDS ===> N
Feedback
