Load Accelerator from Specified Image Copy panel

Use this panel to specify or view processing options for an Image Copy load profile type.

The load job that is generated from the input on this panel loads data for a single table into the accelerator from a user-defined Db2® image copy. All of the following commands are available on the editable version of the panel. On the view-only panel, BUILD 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.
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:

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.

Utility Processing Options:

Accelerator(s)

The individual accelerator(s) or accelerator group on which to load data. 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.

Continue on errors

Causes most setup errors on an individual object to be ignored and the object skipped while the rest of the job continues. With the value Yes, the control card CONTINUE_ON_ERROR is generated into the JCL.

If you set Continue on error to Yes or specify CONTINUE_ON_ERROR in the control card, errors with return codes 4 and higher are reported as return code 4 and job processing continues. I/O and other serious issues are not ignored and cause the job to fail.

Input image copy DSN

The data set that contains the image copy for the table spaces. The data set contains non-unique records in following format: DBNAME TSNAME PART ICDSN

The records come from the Db2 SYSCOPY table and are preordered by time stamp.

The JCL generator gets the image copy DSN from the input data set that you choose when you issue the TABLES command and uses it in the output JCL in the SPACE() scope as follows: TO_IC data_set.

Inline copy

Indicates if the origin type of the specified input image copy is inline and not retrieved from a SYSCOPY row. If the origin type is an inline image copy created by the REORG or LOAD utility or an image copy of a compressed object, the data set must be sorted.

YES: The specified input image copy is of an origin type that must be sorted. This value generates the control card TO_IC_INLINE into the JCL, by which a sort will be performed on the specified input image copy.
NO: (default) The specified input image copy does not need to be sorted automatically. This value does not generate the control card TO_IC_INLINE into the JCL.

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.

Log Read and Log Apply Options:

Check data operating mode

Indicates if and when Accelerator Loader checks the integrity of Db2 for z/OS data pages. Valid values are:

No: Do not check data page integrity.
Write: (Default) Check data page integrity before passing the page to the accelerator.
Operation: Check data page integrity before and after each Db2 log apply operation to the image copy, as well as before passing the page to the accelerator.