Accelerator Loader Parameters panel

Specify product options such as sort program, log read and apply preferences, and file allocation parameters.

The following fields are available:

Log Read and Log Apply Preferences:

Log reader copy preference
Sets the default value for log reader copy preference. Unless you change it, the default value is R1R2A1A2 (where R indicates archive log and A indicates active log). You can specify different values for each SSID. The current SSID log reader value is used for JCL generation. For more information, see LOG_COPY_PREFERENCE in Syntax definitions: Consistent load and Image Copy load.
File Allocation Parameters:
Number of buffers
The number of buffers that the product is to use. Valid values are 1 - 99. (Synonymous with the JCL BUFNO= parameter.)
Channel programs
The number of channel programs that the product is to use. (Synonymous with the JCL NCP= parameter.) If a value of 0 is set, the product will use a predetermined channel program setting to attempt to gain optimal performance. Otherwise, a value of 1 - 99 can be specified to determine a best fit value for the site.
Note: The number of channel programs that you specify controls how many outstanding QSAM channel programs can run at the same time before the earliest one is checked for completion.
Data Set Parameters:
Device type
The device type for data sets created by Db2 Analytics Accelerator Loader. DASD devices and tape devices are valid for work files and SYSPRINT files.
Data set type
The type of data set that will be used for data sets created by Db2 Analytics Accelerator Loader.
Track or cylinder
The allocation unit for work data sets created by Db2 Analytics Accelerator Loader. Valid values are TRK (tracks) and CYL (cylinders).
Primary quantity
The primary quantity for data sets created by Db2 Analytics Accelerator Loader (in the units specified in the Track or Cylinder field).
Note: The maximum value that can be specified in the primary or secondary quantity field is 16777215. If you need to specify more space than the maximum, convert to a different space unit (for example, convert bytes to kilobytes by dividing by 1024) and specify the new value.
Secondary quantity
The secondary quantity for data sets created by Db2 Analytics Accelerator Loader (in the units specified in the Track or Cylinder field).
Note: The maximum value that can be specified in the primary or secondary quantity field is 16777215. If you need to specify more space than the maximum, convert to a different space unit (for example, convert bytes to kilobytes by dividing by 1024) and specify the new value.
Maximum volumes
The maximum number of volumes that can be used for work data sets.
Note: The Maximum Volumes field is valid when the device type is set to a DASD or tape device.
SMS data class
The SMS data class for data sets created by Db2 Analytics Accelerator Loader.
SMS storage class
The SMS storage class for data sets created by Db2 Analytics Accelerator Loader.
SMS management class
The SMS management class for data sets created by Db2 Analytics Accelerator Loader.
Sort Work Parameters:
Unit device
Indicates the sort work file unit device to be used when generating utility JCL. Valid values are SYSALLDA, DISK, and so on. Depending on the unit device that you specify, set the number of DDs as follows:
  • For a tape device, specify a Number of DDs value from 3 through 99.
  • For a DASD device, specify a Number of DDs value from 1 through 99.
Number of DDs
The number of SORTWKnn DD statements used for product sort work data sets. Set the value as follows, depending on the unit device value that you specify:
  • For a tape device, specify a value from 3 through 99.
  • For a DASD device, specify a value from 1 through 99.
Primary space
The primary space used (cylinders) for product sort work data sets.
Secondary space
The secondary space used (cylinders) for product sort work data sets.
Utility REGION Size
Indicates the REGION size in megabytes that the product is to use when generating utility JCL. Valid values are 0 - 2047.