Error Handling for Batch processor for Discard situation during Load

Products

• Database Analyzer for DB2 for z/OS
• Fast Unload for DB2 for z/OS
• Fast Check for DB2 for z/OS
• Fast Index for DB2 for z/OS
• Rapid Reorg for DB2 for z/OS

Issue/Introduction

Error Handling for Batch processor for Discard situation during Load

Is it possible to control the discard situation in a way that other warnings 

with return code 4 are tolerated and simultaneously the processing of 

batch processor is not if we get a discard situation with return code 4? 

 

Environment

z/od DB2

Resolution

Currently the batch processor processing depends on the Return Code(RC) from the utility execution. 

It will not look for the actual reason behind the RC, this includes DISCARD processing or any other 

processing for DB2 LOAD which results in RC 4.

 

 

We need DISCARDS 1 parm to be added to IBM LOAD statement to generate RC > 4 from DB2 when 

there are any discarded rows. 

The batch processor will stop the processing if a RC > 4 is received from DB2.

 

Populating DISCARDS parm in IBM Load statements can be achieved by customizing the utility model. 

Process is given below:

1. Go to RC/Migrator -> 0 - Profile -> 6 - Utility Model Services         

2. Enter U for updating the model

3. Enter E to Edit/Customize the LOAD utility

4. Add DISCARDS 1 clause immediately after the DISCARDDDN clause of LOAD DATA INDDN ... statement and save.

 

The further analysis using the updated utility model will generate the LOAD cards with DISCARDS clause.