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.
- 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
//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;
DRLvrm.SDRLCNTLmembers 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.
|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.
DRLvrm.SDRLCNTLmembers that are listed in Table 2 include sample JCL jobs for using stored procedures to enable tables for acceleration.
|DRLJAPME||Analytics - z/OS Performance|
|DRLJA2DE||Analytics – Db2|
|DRLJAKCE||Analytics - KPM CICS|
|DRLJAKDE||Analytics - KPM Db2|
|DRLJAKZE||Analytics - KPM Z/OS|