Has the 'default' LRECL changed for SYSRECnn output?

book

Article ID: 6215

calendar_today

Updated On:

Products

CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS

Issue/Introduction

Recently upgraded to R19 and now are seeing a different LRECL and BLKSIZE for the unload (SYSRECnn) datasets.
Now (using R19's Fast unload)   RECFM = VB   LRECL=32756   BLKSIZE=32760

whereas before (in R17)   LRECL used to be  224

Cause

The Default LRECL has been changed in the R18 Release.

Environment

Z/os for DB2

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 your hlq.CDBAPARM(PFU) member and in your JCL specify an LRECL value in your SYSREC data set allocations.

In your PFU member(if not there already)...add this line. Create the member if not there.


LRECL-USER YES

You could also add this line in your SYSIN in the PFU JCL.


Additional Information

See this documentation reference:

R19 CA Fast Unload for DB2 for z/os: LRECL-USER Use the User-Supplied LRECL Value