IBM Support

Prerequisites and Maintenance for IBM Db2 Analytics Accelerator for z/OS, V7.1

Product documentation


Abstract

Hardware and software requirements for installing IBM Db2 Analytics Accelerator for z/OS, V7.1 on IBM Integrated Analytics System or on IBM Z

Content


Initial Installation

Concerning installation of the GA-level container image:

  • For IBM Integrated Analytics System the container image is pre-installed with the appliance.
  • IBM Db2 Analytics Accelerator
    for z/OS 7.1 maintenance level
    Component Release date (as on Fix Central)
    YYYY/MM/DD
    GA
    V7.1.0 Release Notes
    Container image for IBM Integrated Analytics System:
    7.1.0.0-Information_Management-IDAA-IIAS
    2017/11/23
    Stored procedures:
    db2z.7.1.0 20171103-0917
    n/a
    GA Refresh (recommended)
    V7.1.0.1 Release Notes
    Container image for IBM Integrated Analytics System:
    7.1.0.1-Information_Management-IDAA-IIAS
    2018/01/19
    Stored procedures:
    db2z.7.1.0 20171103-0917
    n/a

  • For IBM Z the container image needs to be downloaded from Fix Central before installation.
  • IBM Db2 Analytics Accelerator
    for z/OS 7.1 maintenance level
    Component Release date (as on Fix Central)
    YYYY/MM/DD
    GA
    V7.1.0 Release Notes
    Container image for IBM Z:
    7.1.0.0-Information_Management-IDAA-Z
    2017/11/23
    Stored procedures:
    db2z.7.1.0 20171103-0917
    n/a
    GA Refresh
    V7.1.0.1 Release Notes
    Container image for IBM Z:
    7.1.0.1-Information_Management-IDAA-Z
    2017/12/19
    Stored procedures:
    db2z.7.1.0 20171103-0917
    n/a
    GA Refresh (recommended)
    V7.1.0.2 Release Notes
    Container image for IBM Z:
    7.1.0.2-Information_Management-IDAA-Z
    2018/02/01
    Stored procedures:
    db2z.7.1.0 20171103-0917
    n/a

    For information concerning the installation of the product see the following manuals:

    IBM Db2 Analytics Accelerator for z/OS V7.1 - maintenance level

    For upgrading the maintenance level of the accelerator server of IBM Db2 Analytics Accelerator for z/OS V7.1 the corresponding container image needs to be downloaded from Fix Central.

    • For IBM Integrated Analytics System the following container images are available:

    • IBM Db2 Analytics Accelerator
      for z/OS 7.1 maintenance level
      Component Release date (as on Fix Central)
      YYYY/MM/DD
      V7.1.1 Release Notes Container image for IBM Integrated Analytics System:
      7.1.1.0-Information_Management-IDAA-IIAS

      "Accelerator server:"-build number in Data Studio:
      7.1.1.201803270857
      2018/03/29
      Stored procedures:
      db2z.7.1.1 20180329-0833
      APAR PI95587, PTFs UI54842 and UI54843
      n/a
      V7.1.2 Release Notes Container image for IBM Integrated Analytics System:
      7.1.2.0-Information_Management-IDAA-IIAS

      "Accelerator server:"-build number in Data Studio:
      7.1.2.201806070909
      2018/06/08
      Stored procedures:
      db2z.7.1.2 20180517-2241
      APAR PI98213, PTFs UI56371 and UI56372
      n/a

    • For IBM Z the following container images are available:

    • IBM Db2 Analytics Accelerator
      for z/OS 7.1 maintenance level
      Component Release date (as on Fix Central)
      YYYY/MM/DD
      V7.1.1 Release Notes Container image for IBM Z:
      7.1.1.0-Information_Management-IDAA-Z

      "Accelerator server:"-build number in Data Studio:
      7.1.1.201803291157
      2018/03/29
      Stored procedures:
      db2z.7.1.1 20180329-0833
      APAR PI95587, PTFs UI54842 and UI54844
      n/a
      V7.1.2 Release Notes Container image for IBM Z:
      7.1.2.0-Information_Management-IDAA-Z

      "Accelerator server:"-build number in Data Studio:
      7.1.2.201806071049
      2018/06/08
      Stored procedures:
      db2z.7.1.2 20180517-2241
      APAR PI98213, PTFs UI56371 and UI56373
      n/a

      Hardware requirements

      Minimum hardware requirements that must be met to successfully install IBM Db2 Analytics Accelerator for z/OS.

      • Hardware requirements for acceleration on IBM Integrated Analytics System
        Computers
        Quantity Product Program number
        1 IBM Integrated Analytics System
        Models:
        M4001-003, M4001-006, M4001-010
        M4002-003, M4002-003 (GoD), M4002-006, M4002-010, M4002-020, M4002-040
        5737-E33
        1 Workstation (Intel® or compatible) for IBM DB2 Analytics Accelerator Studio. This
        workstation must be connected to the zEnterprise System. For the hardware and software
        requirements of this workstation, see:
        System requirements for IBM Data Studio Version 4.1
        Depends on manufacturer
      • Hardware requirements for acceleration on IBM Z
        Computers
        Quantity Product Program number
        1 IBM z14™
        Models: M01, M02, M03, M04, M05
        HMC and SE firmware 2.13.1, at least SE bundle S47 / HMC bundle H36
        3906
        1 Workstation (Intel® or compatible) for IBM DB2 Analytics Accelerator Studio. This
        workstation must be connected to the zEnterprise System. For the hardware and software
        requirements of this workstation, see:
        System requirements for IBM Data Studio Version 4.1
        Depends on manufacturer

        One accelerator is represented by one LPAR. Each LPAR requires IFLs (up to one drawer), RAM, and Storage.
        Components Minimum suggested configuration
        IFLs Use existing IFLs and memory or use one drawer comprised of 35 IFLs and up to 8 TB memory.
        For small production test/dev or getting-started use cases the minimum suggestion configuration is:
        • 4 IFLs, 256 GB memory for test/dev
        • 8 IFLs, 512 GB memory for production
        Storage
        • Requires additional customer-provided storage (actual size depends on workload)
        • FCP or FICON attached

      Networking

      • Network requirements for acceleration on IBM Integrated Analytics System

        Networking
        For the data network between IBM z Systems and the IBM Integrated Analytics System (M4001-003, M4001-006, M4001-010), a dedicated physical network is required.

        Minimum network configuration
        The minimum network configuration is for test and development scenarios, but does not satisfy high availability requirements. Hence this configuration should not be used in a production environment. The minimum network configuration requires the following components:
        Heads up
        For longer 10GbE SR connections with distances around 300 meters, OM3 fiber optic cables are required. Other types support only shorter distances.

        Quantity Product Location
        1 OSA-Express3 10GbE
        (dual port)
        IBM zEnterprise System
        OSA-Express4S 10GbE
        (single port)
        zEnterprise 196, zEnterprise 114, or z13
        OSA-Express5S 10GbE zEnterprise EC12, zEnterprise BC12, or z13
        OSA-Express6S 10GbE z14
        1 10GbE SFP + Switch
        Lenovo RackSwitch G8264
        Lenovo RackSwitch G8124E
        Network
        2 Optical fiber cables Network
        3 IBM/BNT® 10Gb SFP + Optical Transceiver Switch
        1 1 GbE RJ45 Switch
        Lenovo RackSwitch G7028
        Network
        2 RJ45 cable Network

        Recommended network configuration
        The following components are required for a fully redundant (high availability) network between IBM z Systems and the IBM Integrated Analytics System (M4001-003, M4001-006, M4001-010).

        Quantity Product Location
        2 OSA-Express3 10GbE (dual port) IBM zEnterprise System
        OSA-Express4S 10GbE (single port) zEnterprise 196, zEnterprise 114, or z13
        OSA-Express5S 10GbE zEnterprise EC12, zEnterprise BC12, or z13
        OSA-Express6S 10GbE z14
        6 Optical fiber cables Network
        2 10GbE SFP + Switch
        Lenovo RackSwitch G8264
        Lenovo RackSwitch G8124E
        Network
        6 IBM/BNT® 10Gb SFP + Optical Transceiver Switch
        2 1 GbE RJ45 Switch
        Lenovo RackSwitch G7028
        Network
        4 RJ45 cable Network
      • Network requirements for acceleration on IBM Z

        For query acceleration on IBM Z, a TCP/IP network connection is required between the affected Db2 for z/OS subsystems and IBM Db2 Analytics Accelerator for z/OS V7.1. This connection can either be defined using

        • OSA Express interfaces in IBM z14
        • or using
        • Hipersockets (if the Db2 subsystem runs in an LPAR on the same CEC). Network bandwidth and speed impact overall solution performance. For OSA interfaces we therefore recommend a dedicated OSA Express card and 10GbE connectivity with Jumbo Frames.

      Software requirements

      Operating systems
      Operating system Required features and PTFs Program number
      z/OS V2R1 IBM Ported Tools for z/OS V1.3.0 or later
      (OpenSSH server with AllowTcpForwarding or OpenSSH client + OpenSSH server) 1
      5655-M23
      Data Facility System Managed Storage Base (DFSMSdfp) 5695-DF1
      Communication Server IP HIP61D0
      z/OS V2R2 z/OS OpenSSH
      Use the following link for information to plan your changes to the system: Accommodate the OpenSSH ported level
      integrated in z/OS V2R2
      Data Facility System Managed Storage Base (DFSMSdfp) 5695-DF1
      Communication Server IP HIP61D0
      z/OS V2R3 z/OS OpenSSH
      Use the following link for information
      to plan your changes to the system
      Accommodate the OpenSSH ported level
      integrated in z/OS V2R3
      Data Facility System Managed Storage Base (DFSMSdfp) 5695-DF1
      Communication Server IP HIP61D0

      ( 1 ) For ordering contact IBM with keywords "Withdrawn Order Process".


      Database management software

      Use one of the supported database management systems on your System z server (DB2 11 for z/OS, or later). Make sure that required program temporary fixes (PTFs) and features are installed. Optional features are marked as such.

      Database management system Required features and PTFs Program number
      DB2 11 for z/OS
      New Function Mode (NFM)
      MLC
      or
      Value Unit Edition
      5615-DB2

      5697-P43
      DB2 Utilities Suite for z/OS version 11.1 5655-W87
      A number of Db2-supplied stored procedures must be configured. See the Installation Guide, for details.
      DB2 12 for z/OS MLC
      or
      Value Unit Edition
      5650-DB2

      5770-AF3
      DB2 Utilities Suite for z/OS version 12.1 5770-AF4
      A number of Db2-supplied stored procedures must be configured. See the Installation Guide, SH12-7083, for details.

      Recommended minimum level of JDBC driver
      You can check the version of your JDBC driver by using the following command:
      java com.ibm.db2.jcc.DB2Jcc -version

      IBM DB2 Analytics Accelerator Minimum Level for Type 2 Connectivity Minimum Level for Type 4 Connectivity
      IBM DB2 JDBC Universal Driver (db2jcc.jar) 3.63.141 3.64.111
      IBM Data Server Driver for JDBC and SQLJ (db2jcc4.jar) 4.13.145 4.14.119
      IBM Data Server Driver for JDBC and SQLJ V10.1 Fix Pack 2 IP23387-IP23396
      Depending on the platform. This is sometimes required if you need to specify Db2 for z/OS special registers as part of the connection URL.

      Required ODBC driver level
      Depending on your Linux, UNIX, or Windows operating system, the minimum level for DB2 Connect Version 10.5 is fix pack 4 and the minimum level for DB2 Connect Version 10.1 is fix pack 4. To enable the special registers for query acceleration, see Enabling query acceleration with IBM Db2 Analytics Accelerator for ODBC and JDBC applications witout modifying the applications. Older versions of the driver might allow connections to Db2 for z/OS, but might fail to return results if timestamp columns are defined in a certain way.


      Required Db2 maintenance level

      IBM Db2 Analytics Accelerator for z/OS, V7.1 on IBM Z requires PUT-level 1710 installed for your Db2 environment.


      Recommended Db2-PTFs

      To determine all (Db2-)PTFs recommended for use with IBM Db2 Analytics Accelerator for z/OS V7.1.0, use the SMP/E REPORT MISSINGFIX command in conjunction with FIXCAT HOLDDATA as follows:
      1. Acquire and RECEIVE the latest HOLDDATA file onto your z/OS system. Use your normal service acquisition portal or download
        the two (2) year HOLDDATA files here: Enhanced HOLDDATA for z/OS.
        Ensure you select 'FULL' from the Download NOW column (last 730 days) to receive the FIXCAT HOLDDATA, as the other files do not contain FIXCAT HOLDDATA.
      2. Run the SMP/E REPORT MISSINGFIX command on your z/OS systems and specify Fix Category FIXCAT (IBM.DB2.AnalyticsAccelerator.V7R1) . The report will identify missing PTFs associated with that category on that system. For more information about the SMP/E REPORT MISSINGFIX command, see here.
      3. Periodically acquire the latest HOLDDATA file and rerun the REPORT MISSINGFIX command to determine if there are new recommended (Db2-)PTFs for IBM Db2 Analytics Accelerator for z/OS V7.1.0

Incremental update function

IBM InfoSphere Change Data Capture for z/OS (CDC) is included in the IBM Db2 Analytics Accelerator product package. Please find information about the recommended CDC PTFs here.

IBM DB2 Analytics Accelerator Studio

IBM DB2 Analytics Accelerator Studio is the graphical administration interface for the product and can be downloaded from:
IBM developerworks:
developerWorks/downloads/im/data
IBM Fix Central:
Information Management/DB2 Analytics Accelerator Studio
The Full Image for initial installation, including DataStudio, is available here:
DB2 Analytics Accelerator Studio Full Image

It consists of a set of Eclipse plug-ins that are added to IBM Data Studio V4.1, V4.1.0.1, V4.1.1, V4.1.2, or V4.1.3.
IBM DB2 Analytics Accelerator Studio (client) must be at the same or a higher interface level than the IBM Db2 Analytics Accelerator software (server). Upgrade the client first.

IBM Db2 Analytics Accelerator
for z/OS V7.1.0 maintenance level
IBM DB2 Analytics Accelerator Studio (client) required minimum version
Refresh-Pack name as appearing
on Fix Central
Version string in About section
of IBM Data Studio
GA
7.1.0.0-Information_Management-IDAA_Studio-Multiplatform-20171120-0952
7.1.0.201711200946
7.1.1.0

7.1.1.0-Information_Management-IDAA_Studio-Multiplatform-20180320-1512

7.1.1.201803201507
7.1.2.0

7.1.2.0-Information_Management-IDAA_Studio-Multiplatform-20180517-2107

7.1.2.201805172103

The latest version of IBM DB2 Analytics Accelerator Studio is recommended to be used with all versions of the accelerator server software. To download the corresponding IBM Installation Manager repository for upgrades use the following link: Fix Central
You can also add the plug-ins to an existing installation of IBM Data Studio or to products that are based on IBM Data Studio.
Recommendation: If you use IBM DB2 Analytics Accelerator Studio with an older version of IBM Data Studio, consider moving to IBM Data Studio 4.1.3.

The following versions are supported:

  1. IBM Data Studio 4.1
  2. IBM Data Studio 4.1.0.1
  3. IBM Data Studio 4.1.1
  4. IBM Data Studio 4.1.2
  5. IBM Data Studio 4.1.3 (only supported using DB2 Analytics Accelerator Studio 7.1.0.1 or higher)

The plug-ins and fixes for IBM DB2 Analytics Accelerator Studio are available from the following download sites:

  1. Installation Manager repository for IBM Data Studio: 4.1, 4.1.0.1, 4.1.1, 4.1.2, and 4.1.3
  2. Eclipse update site for IBM Data Studio: 4.1, 4.1.0.1, 4.1.1, 4.1.2, 4.1.3

For silent installations, see Silent installation of IBM Installation Manager, IBM Data Studio and IBM DB2 Analytics Accelerator Studio on Windows.

Running IBM DB2 Analytics Accelerator Studio on Linux

IBM DB2 Analytics Accelerator Studio uses the Eclipse SWT Browser Control for a number of software update dialogs. To run IBM DB2 Analytics Accelerator Studio on Linux, you must therefore install a compatible version of Mozilla/XulRunner.

IBM Data Studio 4.1, IBM Data Studio 4.1.0.1, and IBM Data Studio 4.1.1 support:

Mozilla 1.4 GTK2 - 1.7.x GTK2, XULRunner 1.8.x - 1.9.x and 3.6.x (but not 2.x), WebKitGTK+ 1.2.x

Read the Eclipse FAQ entry for Eclipse 4.2.2

IBM Data Studio 4.1.2 supports:

Mozilla 1.4 GTK2 - 1.7.x GTK2, XULRunner 1.8.x - 1.9.x, 3.6.x, 10.x and 24.x (but not 2.x nor other unlisted versions), WebKitGTK+ 1.2.x and newer (Note: Eclipse 4.4 and newer uses GTK 3 by default and XULRunner cannot be used in this case as it is not ported to GTK 3 yet)

Read the Eclipse FAQ entry for Eclipse 4.4

Document information

More support for: DB2 Analytics Accelerator for z/OS

Software version: 7.1.0

Operating system(s): z/OS

Reference #: 7050440

Modified date: 20 June 2018


Translate this page: