Override the product specific defaults of the PFU member.

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

Description:

How do you override the default PFU member parameters set by the installation from within your SYSIN DD control statements.

Solution:

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 "Using PFU Parmlib to Override Keyword Defaults".

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.

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 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.