Loading data to IBM Db2 Analytics Accelerator

The IBM® Db2® Analytics Accelerator Loader for z/OS® is used to load the data that is output from the Z Common Data Provider System Data Engine directly into IBM Db2 Analytics Accelerator for z/OS.

Procedure

Run the IBM Db2 Analytics Accelerator Loader for z/OS by using the Db2 LOAD utility with the following updates:

A DD statement that enables the loader to intercept the Db2 LOAD utility:
```
//HLODUMMY DD DUMMY
```
A statement that directs the loader to load data into the IBM Db2 Analytics Accelerator. This statement indicates the name of the accelerator and indicates that the target is an IDAA_ONLY table, as shown in the following example:
```
//SYSIN    DD * 
	  LOAD DATA RESUME YES LOG NO INDDN input_data_set_ddname
	    	IDAA_ONLY ON accelerator-name
	    	INTO TABLE DRLxx.KPMZ_WORKLOAD_T FORMAT INTERNAL;
```

The DRLvrm.SDRLCNTL members that are listed in Table 1 include sample JCL jobs for loading Db2 UNLOAD format data for each of the analytics component tables to IBM Db2 Analytics Accelerator.

Table 1. Sample jobs for loading data into IBM Db2 Analytics Accelerator
`DRLvrm.SDRLCNTL` member	Analytics component
DRLJAPMD	Analytics - z/OS Performance
DRLJA2DD	Analytics – Db2
DRLJAKCD	Analytics - KPM CICS®
DRLJAKDD	Analytics - KPM Db2
DRLJAKZD	Analytics - KPM Z/OS

After the load is complete from the first time that you load an IDAA_ONLY table, the table must be enabled for acceleration in IBM Db2 Analytics Accelerator for z/OS. Tables can be enabled for acceleration by using the Data Studio Eclipse application, or by using stored procedures.

The DRLvrm.SDRLCNTL members that are listed in Table 2 include sample JCL jobs for using stored procedures to enable tables for acceleration.

Table 2. Sample jobs for enabling tables for acceleration in IBM Db2 Analytics Accelerator
`DRLvrm.SDRLCNTL` member	Analytics component
DRLJAPME	Analytics - z/OS Performance
DRLJA2DE	Analytics – Db2
DRLJAKCE	Analytics - KPM CICS
DRLJAKDE	Analytics - KPM Db2
DRLJAKZE	Analytics - KPM Z/OS