Load Accelerator(s) from External File panel

Use this panel to specify or view options for an External load profile type.

An External load specifies options for loading table data into only the accelerator from an external data input file. All of the following commands are available on the editable version of the panel. On the view-only version of the panel, the COLINFO command is available.

TABLE: Type this command on the command line to add a Db2® table to a profile.
ACCELERATOR: Type this command on the command line to a select the accelerators into which you want to load data. This command opens the Db2 Analytics Accelerator Selection panel. You must have proper Db2 authority to access the list of accelerators.
COLINFO: Edit column definitions within the data set that is defined in field Column Info DSN. This command opens an ISPF edit session that enables you to create or edit the column information for the LOAD control card. This data set must contain only the table column definitions (without the parenthesis), and not the entire LOAD utility syntax.
SAVE: Type this command on the command line to save your specifications in the profile.
BUILD: Type this command on the command line to build JCL for the profile to the specified data set.

The following fields are available on this panel.

Creator/Profile creator

The profile creator.

Name/Profile Name

The name of the profile, up to 30 characters. (Using meaningful names for profiles makes them easier to locate and reuse; for example, “Objects for Employee App.”)

Share option

Controls how other users can use a profile:

U (Update): Other users can update the profile.
V (View only): Other users can view the profile.
N (No access): Other users cannot view nor update the profile.

Description

A description of the profile.

Schema

Table name

Partition

These fields display values for the currently selected Db2 table. To change the table, issue the TABLE command.

Target Options:

Accelerator(s)

The individual accelerator(s) or accelerator group on which to load data. On the editable panel, to display a list of existing accelerators or groups, use the ACCELERATOR command.

Add table to Accelerator

Indicates whether to add missing tables to the accelerator before starting the load job.

(default) N (No): Do not add tables.
A (Add): Add missing tables. This value generates the control card ACCEL_ADD_TABLES into the JCL.
R (Refresh): Add missing tables; remove and re-add existing tables. This value generates the control card ACCEL_REMOVE_AND_ADD_TABLES into the JCL.

Enable acceleration on success

Controls whether Db2 Analytics Accelerator Loader enables query acceleration for the table after a successful load. Valid values are as follows:

Y (Yes): Enable a table for acceleration after a successful load. This value generates the control card ACCEL_ON_SUCCESS_ENABLE YES into the JCL.
(default) N (No): Do not enable a table for acceleration after a successful load. The control card ACCEL_ON_SUCCESS_ENABLE NO is generated into the JCL.

Parallel load

Indicates that you want to generate load control cards that will enable parallelism. This field is available when you choose to load a partitioned table. For nonpartitioned objects, the field is read-only and the value is No. Valid values are Yes and No.

When the value is Yes:

You must enter a TEMPLATE data set name pattern in Input data set. This data set name pattern is used to generate a template definition.
The Load tasks field is enabled.

Load tasks

Specifies the number of parallel load tasks to use. Valid values are blank or 1 - 20. If no value is specified, then the value from the options module parameter ACCEL_LOAD_TASKS is used. This value is used to generate the ACCEL_LOAD_TASKS n clause of the load statement.

Db2 Sort

Indicates whether to use the Db2 Sort product for load job sort operations.

YES: The load job will use Db2 Sort for sort operations if Db2 Sort is available. If Db2 Sort is not found, the load job will use the system sort program that is installed on the LPAR (DFSORT or Syncsort). This value generates the control card DB2_SORT YES into the JCL.
NO: The load job will not use Db2 Sort and will instead use the system sort program that is installed on the LPAR (DFSORT or Syncsort). This value generates the control card DB2_SORT NO into the JCL.

Input File Options:

Data set

For the SYSREC data set that contains the data of the table in external format, specify a name or pattern as follows:

The fully qualified data set name of the SYSREC data set. For a PDS, enclose the member name in parentheses; for example, HLO.LOADCARD(FILE). If you specify an existing data set, the product generates the DD ISYSREC in the output JCL.
The DSN template for the SYSREC data set. You can specify a DSN template for both parallel and nonparallel loads (Parallel load field). For a parallel load, the DSN template pattern must include the &PART variable to ensure that a unique SYSREC data set name is generated for each partition. The partition number must be included in your partition-level SYSREC data sets.
If you specify a DSN template, the product generates the TEMPLATE(...) statement in the output JCL.
To update the DSN template and its parameters, specify Yes in the Update field. You can specify the template pattern and the parameters with which to allocate the data set.

The product does not restore a previous value for the SYSREC data set if you change the value of Parallel load. In this case, only the SYSREC field validation changes to require the &PART variable for a parallel load.

Encoding

Specifies the SYSREC encoding scheme. Valid values are as follows:

UNICODE: When UNICODE is specified, the UNICODE Db2 LOAD utility keyword is generated into the LOAD control cards.
EBCDIC: (default) When EBCDIC is specified, no additional keywords are added to the LOAD control cards. EBCDIC is the default for both Accelerator Loader and Db2 LOAD.

Format

Indicates whether the SYSREC data is in Db2 internal, delimited format, or governed by the rules for field specifications. Valid values are:

Internal: The FORMAT INTERNAL keyword is included in the LOAD utility control cards.
Delimited: The FORMAT DELIMITED keyword is included in the LOAD utility control cards. To update the delimiter parameters, specify Yes in the Update field.
blank: (default) The format is governed by the rules for field specifications.

Column info DSN

The product detects whether the table column information data set is from an UNLOAD utility. If so, it automatically includes the correct information in the JCL that it generates. Otherwise, specify the name of the fully qualified data set that contains the column information from the SYSPUNCH data set. Specify a single data set; a template cannot be used in this field.

Db2 Load Options:

Utility ID: Specifies a unique identifier for this utility within Db2. This is an input parameter of type VARCHAR(16) in EBCDIC. It is passed as a parameter to the JCL in the PARM field, such as, //DLD0001 EXEC PGM=PGM#DLD, PARM=(‘QA1A, ,utility ID’)
RESUME: Specify Yes to generate the control card LOAD RESUME YES into the JCL. The product appends data to the accelerator table rather than replacing it. When loading to both Db2 and the accelerator, Db2 will also append the data to the Db2 table. When loading to only the accelerator, no data is added to the Db2 table, but any existing data in Db2 is left intact. Specify No if you want the product to replace existing data rather than appending it.
DISCARDS: Specifies the maximum number of source records that are to be written on the discard data set. Valid values are 0 - 2147483647. The default value is 0, which specifies that you do not want to set a maximum value. The entire input data set can be discarded. If the discard maximum is reached, the LOAD job abnormally terminates, the discard data set is empty, and you cannot see which records were discarded. You can either restart the job with a larger limit or terminate the utility. To specify a DISCARDS value, you must provide a DISCARDDN name.
DISCARDDN name: Specifies the DD name for a data set to be used for discarding data rows. This value is optional. The default is ISYSDISC. If you want to use DISCARDDN, you must specify both DISCARDDN name and DISCARDDN DSN. Use the Update field to specify data set allocation parameters for the DSN specified in the DISCARDDN DSN field. See Data Set Allocation panel.
DISCARDDN DSN: Specifies the data set name to be used for discarding data rows. To update the data set allocation parameters, specify Yes in the Update field next to the DISCARDDN name field. See Data Set Allocation panel.
SYSUT1 template DD name: Specifies the first of two work data sets. This value is required when you are running the LOAD utility. The default is ISYSUT1.
To update the template and its parameters, specify Yes in the Update field. You can specify the template pattern and the parameters with which to allocate the data set. If you include the DD, then you must define the template at least once in the profile.
SORTOUT template DD name: Specifies the second of two work data sets. This value is required when you are running the LOAD utility. The default is ISORTOUT.
To update the template and its parameters, specify Yes in the Update field. You can specify the template pattern and the parameters with which to allocate the data set. If you include the DD, then you must define the template at least once in the profile.

Inline Copy Data Sets Options:

Local primary: Specifies the primary copy data set for the local site. To update the data set parameters, specify Yes in the Update field.
Local backup: Specifies the secondary (backup) copy data set for the local site. You can create a backup copy for the local site only when a primary copy for the local site is also being created. To update the data set parameters, specify Yes in the Update field.
Recovery primary: Specifies the primary copy data set for the remote recovery site. To update the data set parameters, specify Yes in the Update field.
Recovery backup: Specifies the secondary (backup) copy data set for the remote recovery site. You can create a backup copy for the remote recovery site only when a primary copy for the remote recovery site is also being created. To update the data set parameters, specify Yes in the Update field.