Has the default LRECL changed for SYSRECnn output executing Fast Unload for Db2 for z/OS
search cancel

Has the default LRECL changed for SYSRECnn output executing Fast Unload for Db2 for z/OS

book

Article ID: 6215

calendar_today

Updated On:

Products

Fast Unload for DB2 for z/OS

Issue/Introduction

After an upgrade to Fast Unload for Db2 for z/OS (PFU) r19 release, a different LRECL and BLKSIZE
is seen for the unload (SYSRECnn) datasets. 

Now using PFU r19: RECFM = VB   LRECL=32756   BLKSIZE=32760

PFU in prior releases such as the r17 the LRECL was 224.

Cause

The default LRECL was changed in Fast Unload r18.

Resolution

The default output record length is now 32,756 bytes for a comma delimited unload. If a different length
is required, specify LRECL-USER YES in the hlq.CDBAPARM(PFU) member. Also in the JCL specify
an LRECL value in the SYSREC data set allocations.

In the PFU member(if not there already)...add this line. Create the member if not there:
LRECL-USER YES

This line can also be added in SYSIN in the Fast Unload parms of the JCL.

Additional Information

LRECL-USER—Use the User-Supplied LRECL Value