After upgrade to Fast Unload r18 or r19 suddenly received error message PFU0300E open for CTLDDN
search cancel

After upgrade to Fast Unload r18 or r19 suddenly received error message PFU0300E open for CTLDDN

book

Article ID: 6255

calendar_today

Updated On:

Products

Fast Unload for DB2 for z/OS

Issue/Introduction

After the upgrade to Fast Unload for Db2 for z/OS (PFU) r18 or r19, suddenly a Fast Unload job returned error message
PFU0300E without any change in the Fast Unload JCL or in the  FASTUNLOAD statement.
 
PFU0300E - OPEN FAILED FOR CTLDDN DCB - DDNAME: SYSCTL01
 
FASTUNLOAD statement was specified as follows.
 
FASTUNLOAD                    
LOAD-CONTROL     DB2LOAD     
OUTPUT-FORMAT   COMMA-DELIMITED
...

Resolution

With releases prior to Fast Unload r18 and r19 FASTUNLOAD ... OUTPUT-FORMAT COMMA-DELIMITED did not support the generation of
LOAD-CONTROL information. Therefore, Fast Unload Job switched to LOAD-CONTROL NONE when OUTPUT-FORMAT COMMA-DELIMITED
was specified in SYSIN and got the warning message PFU0022W.
 
PFU0022W - OUTPUT-FORMAT COMMA-DELIMITED FORCES LOAD-CONTROL NONE
 
Because of switching to LOAD-CONTROL NONE, it did not check or require SYSCTL01 DD name.
 
With Fast Unload r18 and r19 OUTPUT-FORMAT COMMA-DELIMITED can generate LOAD-CONTROL card information. Because of that Fast Unload
Job does not switch to LOAD-CONTROL NONE any more. Also it checks or requires SYSCTL01 DD name which is same as others OUTPUT-FORMAT
with LOAD-CONTROL other than NONE specification process.
 
In the Fast Unload job LOAD-CONTROL DB2LOAD and OUTPUT-FORMAT COMMA-DELIMITED syntax was specified which indicated that was
requesting to generate Db2 Load control information. Since OUTPUT-FORMAT COMMA-DELIMITED can generate load card information and it is now
acting same as other OUTPUT-FORMAT process.

Requirement to set one of the following:

1. Specify LOAD-CONTROL NONE if you do not want to generate Db2 Load control cards.

or

2. Add SYSCTL01 SYSOUT=* or SYSCTL01 written to a data set with LOAD-CONTROL other than NONE specified if Db2 Load control
information would like to be generated. (e.g. LOAD-CONTROL DB2LOAD requires SYSCTL01 DD name).