Error Handling for Batch processor for Discard situation during Load

Document ID : KB000016241
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

Error Handling for Batch processor for Discard situation during Load

Question:

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
Answer:

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.