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

book

Article ID: 18522

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update for DB2 for z/OS 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

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