IBM Unload fails with return code 4 and BPA0046W

Products

• RC/Migrator for DB2 for z/OS
• Batch Processor
• RC Compare for DB2 for z/OS
• RC/Update for DB2 for z/OS

Issue/Introduction

Executing an IBM Unload utility through the Batch Processor unexpectedly fails with return code 4.

BPA0046W: UTILITY WARNING MESSAGE(S) ISSUED. UTILITY RETURN CODE = 4.

Environment

Release : 20.0

Component : RC/Compare for DB2 for z/OS

Cause

The cause of the unload failures is the use of the P&PART variable for the DATA DSN in the IBMUNLD model for a non-partitioned object. This is resulting in warning message DSNU1252I being issued by the IBM Unload utility:

DSNU1252I -ssid 205 07:35:46.94 DSNUULIA - PARTITION PARALLELISM IS NOT   
            ACTIVATED AND THE PARTITION VARIABLE IN THE                   
                       TEMPLATE DSN WAS REPLACED BY '00000' FOR TABLESPACE
            dbname.tsname        

The Unload has completed successfully but because the Batch Processor control option, NOERRORS is specified, the job terminates due to the return code 4 issued by the IBM unload.

DSNU010I    205 07:35:47.00 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST
            RETURN CODE=4                                                 
BPA0046W: UTILITY WARNING MESSAGE(S) ISSUED. UTILITY RETURN CODE = 4.

Resolution

Option NOERRORS instructs Batch Processor to stop processing whenever a non-zero return code is returned.

To resolve these failures for the unload of these objects, you need to either:

1. Correct the IBMUNLD model, so that the P&PART variable is not used for non-partitioned objects.

2. Or use Batch Processor control option ERRORS, so that the Batch Processor only stops processing if return codes 8, 12, and 16 are generated for non-SQL errors. Then, if a warning message such as DSNU1252I is issued the Batch Processor will continue processing.

3. Or add the DSNU1252I warning message to the BATPROC CDBAPARM member, to notify Batch Processor that this message is OK and that Batch Processor can continue.

For example:

BPUTILM     (          
          (DSNU020I,O) 
          (DSNU1252I,O)   <-- tells Batch Processor that this warning message is OK
          (DSNU103I,B) 
          (DSNU104I,B) 

With this in place, Batch Processor will ignore the DSNU1252I warning message and continue processing. This will be noted by the following message after the unload has completed.

BPA0045I: UTILITY WARNING MESSAGE(S) ISSUED. BATCH PROCESSOR WILL CONTINUE.