Override Fast Unload product specific defaults specified in the CDBAPARM PFU member
Article ID: 54765
Updated On:
Products
Issue/Introduction
How do you override the Fast Unload for Db2 for z/OS (PFU) default PFU member parameters set by the installation from within your SYSIN DD control statements.
Resolution
The hlq.CDBAPARM is able to have a PFU member created. The PFU member is not created by default at install and must be manually created.
The parmlib member, PFU, is discussed in the Fast Unload for DB2 for z/OS User Guide. In the User Guide it's discussed in section "Customize the Product Using PFU Parmlib".
If the PFU member is created some of the parms are able to be defined there and override the normal default. Some of these include SORTSIZE, EXCP, LOAD-CONTROL, SELECT-OPTIONS, SORTDEVT, SORTNUM and others.
The following parms can only be specified in the PFU parmlib, not in the SYSIN syntax of the job:
HISTORY-ERROR-RC, HISTORY-WARNING-RC, IC-BSAM, PFU-HISTORY, RTS-OVERRIDE and SYSCOPY-DELETE
Check the keyword descriptions in the User Guide to be sure which ones are able to be used.
Warning: There are some which are not able to be used in the PFU member such as DECIMAL-POINT. If the PFU member exists then PFU will read it. You will see a message like this:
PFU0002I- PROCESSING OF CA PARMLIB MEMBER "PFU" - COMPLETED
Note that when you use the ALLMSGS parm option either in the PFU member or in your job parms then a report is displayed showing what PFU parms are in effect for the job.
The heading looks like this:
PFU0602I- REPORT OF CA FASTUNLOAD PROCESSING OPTIONS IN EFFECT:BEGINNING
Information like this can be invaluable for problem determination.
Additional Information
Feedback
