Adjusting the Batch Processor Unload utility model to span multiple volumes when unloading data from a table.

Products

• RC Compare for DB2 for z/OS
• Database Analyzer for DB2 for z/OS
• Fast Unload for DB2 for z/OS
• Fast Check for DB2 for z/OS
• Fast Index for DB2 for z/OS
• Rapid Reorg for DB2 for z/OS

Issue/Introduction

Description:

If a table is large the data may need to span multiple units of a device when unloaded. Within the UNLOAD utility this can be accomplished by adding the UCOUNT symbolic to the model and referencing the UCOUNT in the .ALLOC statement within the model text.

Solution:

Within the tools choose:

• Option 2 for RC/Migrator
  
  
• Option 0 Profile
  
  
• Option 6 Utility Model Services
  
  
• Place a 'U' by the model being used
  
  
• Place a 'S' next to the UNLOAD utility which will show the symbolics and text for the model

In the UNLOAD model add this symbolic along with a value:

UCOUNT  	5 (Note UCOUNT is a valid model symbolic) 

Next, within the .ALLOC PTIUNLD of the model add the UCOUNT parameter:

#IF(%REORGP,LE,%LARGE)
        TRACKS +
       #IF(%ULDSP1,LE,%TRKLIMIT)
        SPACE(%ULDSP1,%ULDSP2) +
       #ELSE
        SPACE(%TRKLIMIT,%TRKLIMIT) +
       #ENDIF
        VOLSER(%VOLSER) +
        UNIT(%DISK) +
        UCOUNT(%UCOUNT) +<<<<<<<<<
 
UCOUNT(nn)

Specifies the maximum number of devices to be allocated for data sets that span multiple devices, where nn must be a value between 1 and 59.

This parameter corresponds to the UCOUNT field on the UNIT operand in JCL.

The following is generated:

ALLOC FI(PTIUNLD)                                                     +
      DA('USER1.DATAB1.TID24.DATA')                                   +
      BLKSIZE(6336) LRECL(72)                                         +
      TRACKS                                                          +
      SPACE(1,1)                                                      +
      UNIT(SYSDA)                                                     +
      UCOUNT(5)                                                       +
      NEW CATALOG

Environment

Release:
Component: RBP