Set up your environment prior to customization

Prior to customization, ensure that your environment meets all requirements, that you have installed all prerequisite software, and that you have considered how you want to customize optional features.

Hardware requirements

Db2® Analytics Accelerator Loader can be used on any hardware environment that supports the required software.

Software requirements

Check the Db2 Analytics Accelerator Loader software requirements.

z/OS® requirements

Ensure that you are using one of the following versions of z/OS at the latest maintenance level:
  • Version 2.5
  • Version 3.1
  • Version 3.2

Db2 requirements

Ensure that you are using one of the following supported versions of Db2 for z/OS at the latest maintenance level.
  • Db2 version 13
  • Db2 version 12

Accelerator requirements

Ensure you are using a supported version of IBM® Db2 Analytics Accelerator for z/OS.

  • Version 7.5
  • Version 8.1

In a coexistence setup, minimum Analytics Accelerator versions and Accelerator Loader maintenance are required. A coexistence setup includes at least one V7.5 and at least one V8.1 Analytics Accelerator on the same Db2 for z/OS subsystem. You can load to a V7.5, a V8.1, or to multiple accelerators at the same time to a maximum of four.

In a coexistence setup, the following minimum versions are required:
  • IBM Db2 Analytics Accelerator for z/OS® Version 7.5
  • IBM Db2 Analytics Accelerator for z/OS® Version 8.1

Memory recommendations

The Db2 Analytics Accelerator Loader started task keeps information in memory for efficiency, so use a minimum region of 100 MB of memory. You can increase that amount in 32 MB increments if you get storage failures. To enable maximum below-the-bar storage and avoid reruns, set REGION=0M for batch jobs, if its allowed by your installation policy.

HALOAD and External load clients require a minimum REGION=100 MB or the job fails with message: HLOU4084E 307 10:25:27.60 Memory constraint detected - available region limit value less than 100M. In all cases, ensure that the requested region size is not limited to a lower amount by the IEFUSI installation exit.

Other software requirements

Ensure that you are using a supported version of the following software:
  • ISPF V4 (5655-042) or later
  • IBM SMP/E for z/OS V03.06.00 (5655-G44 ) or later
  • IBM Tools Customizer for z/OS, V1.1 (5655-TC1) or later
  • IBM Db2 Common Code for z/OS (FEC) V1R3 (5655-F55) or later
    Required maintenance:
    • PK43912
    • PK76167
    • PM06651
    • UK98321
    • UK98680
    • UI21883
    • UI26834
    • UI27815
    • UI97801
    • UI97047
    • UI96046
    • UI95413
    • UI93266
  • IBM DB2 Accelerator Loader Server for z/OS (HLV) V2R1
  • Required maintenance:
    • UI97692
    • UI97601
    • UI96348
    • UI93775

Verify that your environment meets requirements for supported interfaces and data sources

Ensure that you are using supported versions of the data sources you are loading data from at the latest maintenance level:
  • Db2 for z/OS as listed in Software requirements
  • IMS™ Database Control (DBCTL) Version 12.1.0 (5635-A03) or later
  • VSAM with the z/OS PTFs listed in Software requirements
    For optimal performance, ensure that the following VSAM APARs are applied:
    • OA44111
    • OA45279
    • OA45280
    • OA44277
    • OA44064
  • To load data from distributed relational database architecture (DRDA®) sources, use one of the following products:
    • IBM Db2 Advanced Enterprise Server Edition Version 10.5.0 (5725-L47) or later.
    • IBM InfoSphere® Federation Server Version 9.7.0 (5724-N97) or later. For product documentation, see the section Federation in IBM Db2 documentation for the version you are using.
    • IBM InfoSphere BigInsights™ Enterprise Edition Version 1.0.0 (5725-C09) or later.
Before you load relational and non-relational data to an accelerator, ensure that:
  • IBM Data Studio 4.1.x for Windows™ 32-bit or 64-bit is installed on your system.
  • The Accelerator Loader studio plug-in is installed on your system.
  • Accelerator Loader studio can connect to the z/OS mainframe instance.

Verify that Db2 Analytics Accelerator Loader has been installed successfully

For installation instructions, see the Program Directory for Db2 Analytics Accelerator Loader. Installation and verification jobs have been included in the customization process. Be sure you select the step to generate the IVP jobs in Tools Customizer. Then, ensure you submit each IVP job and that each completes successfully.

Verify that Tools Customizer has been installed successfully

Tools Customizer provides a standard approach to customizing IBM Db2 for z/OS Tools. For installation instructions, see the Program Directory for IBM Tools Customizer for z/OS.

Verify that your environment meets minimum region size requirements

Db2 Analytics Accelerator Loader requires a minimum TSO region size of 50000.