Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see LOADPLUS for DB2 13.1.

Dynamic allocation options

Dynamic allocation options allow you to have LOADPLUS optimally allocate the size and number of work files and copy data sets that are needed for your load job.

Important

LOADPLUS does not use these options to dynamically allocate input (SYSREC) data sets. See INDSN for information about dynamically allocating input data sets.

Dynamic allocation provides the following benefits:

  • Eliminates the need to include DD statements for the specified file types in your JCL

    Important

    If you activate dynamic allocation and you specify DD statements in your JCL, use the IFALLOC installation or command option to control whether LOADPLUS dynamically allocates your data sets or uses the data sets that you allocated in your JCL.

  • Eliminates the need to calculate data set allocation sizes
  • Automatically provides an optimal allocation for the highest possible multitasking level
  • Allows you to use symbolic variables and user-defined variables to assist in creating data set names

The following sections provide the syntax that is required for enabling and using dynamic allocation. For more information, see Dynamic-data-set-allocation.

DSNUTILB load jobs

For a DSNUTILB load, you must enable dynamic allocation for all work files that the load job requires by specifying ACTIVE YES for those DDTYPEs. For copy data sets, ACTIVE YES is required for at least the primary local copy data set (DDTYPE LOCPFCPY) if you specify COPY YES. LOADPLUS ignores any copy or work file data set allocation in your JCL.

Important

All copy data sets for a DSNUTILB load are dynamically allocated, even if you specify ACTIVE YES for only the primary local copy data set.

For these jobs, LOADPLUS uses your dynamic allocation options to generate a TEMPLATE control statement for each data set. LOADPLUS then passes these TEMPLATE statements to DSNUTILB for data set allocation. For more information about TEMPLATE control statements, see the documentation for the IBM Db2 LOAD utility.

AUTOENUMROWS and ENUMROWS options

Unless you are running a load job that invokes DSNUTILB, dynamic allocation requires one of the following specifications:

  • Enable automated file size estimation by either specifying or defaulting to AUTOENUMROWS=YES in your installation options, or specifying ENUMROWS AUTO on your LOAD command.
  • Specify an appropriate numeric value for the ENUMROWS option.

For more information, see ENUMROWS.

Related topic

LOADPLUS-command-options

 

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*