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.1 (5650-ZOS)
    Required maintenance:
    • UA75046
    • UA75273
  • Version 2.2 (5650-ZOS)
  • Version 2.3 (5650-ZOS)

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 13 for z/OS (5698-DB2)
    • Db2 Value Unit Edition 13.1 is (5698-DBV)
    • Db2 Utilities Suite for z/OS, V13 (5698-DUT)
    Required maintenance. Use of Db2 Analytics Accelerator Loader with Db2 version 13 requires you to apply two APARs:
    • Db2 Analytics Accelerator Loader: PH45821
    • Tools Customizer for z/OS: PH42701
Note: There are no changes to the BIND JCL. When using Db2 Analytics Accelerator Loader with Db2 version 13, you can use the same JCL and BIND for Db2 version 13 as you did for Db2 version 12.
  • Db2 version 12:
    • Db2 12 for z/OS (5650-DB2)
    • Db2 12 for z/OS Value Unit Edition (5770-AF3)
    • Db2 Utilities Suite for z/OS, V12 (5770-AF4)
    Required maintenance:
    • PI67007 (UI42441)
    • PI69894 (UI42440)
  • Db2 V11:
    • Db2 V11 (5615-DB2)
    • Db2 Value Unit Edition V11.1 (5697-P43)
    • Db2 Utilities Suite for z/OS, V11 (5655-W87),
    Required maintenance:
    • AI26321
    • PI10162
    • PI35818 (UI29037)
    • PI59910
    • UI24306
    • UI24308

Accelerator requirements

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

  • Version 5.1.0, PTF-4 (Accelerator Loader APAR PI78727, PTF UI46561) (5697-DA5)
  • Version 7.5 (Accelerator Loader APAR PH37059, PTF UI75879) (5697-DA7)

In a coexistence setup, minimum Analytics Accelerator versions and Accelerator Loader maintenance are required. A coexistence setup includes at least one V7 and at least one V5 Analytics Accelerator on the same Db2 for z/OS subsystem. You can load to a V7, a V5, 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 (Accelerator Loader APAR PH37059, PTF UI75879)
  • IBM Db2 Analytics Accelerator for z/OS® Version 5.1.8 (Analytics Accelerator PTF-8), (Accelerator Loader APAR PH37059, PTF UI75879)

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

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.