Why is a COND CODE 4 encountered when dynamic work dataset allocation fails due to a duplicate dataset when executing CA Fast Load?

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

Question:

Executing CA Fast Load for DB2 for z/OS (PFL) and receiving a COND CODE 4 when dynamic allocation errors occur due to dataset(s) already existing.

In the following example the SYSDISC work dataset is being dynamically allocated:

PFL0303W - Dynamic Allocation: File not allocated because it exists in
the catalog: xxxxxxxx.xxxxxxxx.xxxxxxxx.A0003.SYSDISC

PFL0284W - Dynamic Allocation: Process failed in CSECT FLA$DYN2
Detected in module FLA$DYN

What steps can be taken to resolve the dynamic allocation error in this instance?

 

Answer:

The PFL job is ending with a COND CODE 04 as designed in this case. One of the following can be done to alleviate this concern:

  1. Add the work DD statement to the JCL as a static allocation so it is not dynamically allocated with an appropriate DSN= and DISP=.

  2. If dynamic allocation is desired for the work DD, adjust the DSN= symbolic string in the PFL member of highlvl.CDBAPARM for uniqueness. The following is an example: SYSDISC (DSN=%USER..%DBNAME..%TSNAME..T%TIME..SYSDISC

  3. If you do not wish the work DD to be dynamically allocated, modify the PFL member of highlvl.CDBAPARM specifying option DYNAMIC=NO.

  4. If retention of the work dataset is not desired specify option RETAIN-DATASET=NO for the work DD in the PFL member of highlvl.CDBAPARM and the work dataset will not be retained at the end of the utility execution.