The default block size used by the Batch Processor (RBP) Unload (located in the @DEFAULT Model) is 6336, how can it be increased?
When using the 'UNLOAD' utility, the Batch Processor Unload is used. This model will use a default BLKSIZE of 6336.
However to override this block size value via the .ALLOC control statement, the model may be modified/updated to reflect a larger block size as desired.
Since BP Unload uses 72 byte records, the BLKSIZE must be a multiple of 72, this illustration uses 27936. This will require modifying 2 separate utilities within the model definition:
UNLOAD used for normal Unload processing UNLOAD_R used for Recovery Unload processing
The modified UNLOAD utility model should look like:
.ALLOC FI(PTIUNLD) + DA('%DATADSN') + BLKSIZE(27936) LRECL(72) + <<---------------------------- #IF(%REORGP,LE,%LARGE) TRACKS + SPACE(%ULDSP1,%ULDSP2) + UNIT(%UNIT) + #ELSE UNIT(%TAPE)+ #ENDIF NEW CATALOG .CALL UNLOAD .DATA FILE(PTIUNLD) %SELECT LIMIT(%LIMIT) PAGESIZE(%PAGESIZE) %COLUMNS .ENDDATA .FREE FI(PTIUNLD)
To perform this update, please follow these steps:
Select Opt 2(RCM) from the DB2 Tools Main Menu.
Select Opt 0(Profile) from the RC/Migrator Main menu.
Select Opt 6 (Utility Model Services) from the RC/M Expert Profile.Enter the "U"(update) line command next to the model to be updated.
Enter the "E"(edit) line command next to the UNLOAD utility.
The utility model edit uses standard ISPF edit line commands, next enter
"I"nsert to insert a line following the DA('%DATADSN') line.Enter the BLKSIZE line as shown above (i.e. BLKSIZE(27936) LRECL(72) + ).
Enter the "SAVE" primary command, then "END" to exit the edit session.
Perform this edit on the UNLOAD_R utility as well to modify the utility used for recovery processing (if recovery is to be used).