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

  • What's new?

    Please find information about new functions here .


Installation recommendations

Initial installation

If you plan to install IBM Db2 Analytics Accelerator, please contact IBM support by opening a PMR.
For information concerning the installation of the product see the following manuals:

Upgrading the maintenance level

If you plan to upgrade IBM Db2 Analytics Accelerator, please contact IBM support by opening a PMR.

Call-home function

The Hardware Management Console (HMC) offers a call-home function for IBM Z. You must connect this function to your accelerator system so that it can be used to send notifications about accelerator-related events to selected administrators. Currently, this call-home function can only be used for deployments of IBM Db2 Analytics Accelerator for z/OS on an IBM Integrated Analytics System.
The HMC MCL bundle 32 needs to be installed on the HMC to be able to configure and use the call-home function for the accelerator.
For details concerning the setup see section "Using the call-home function" of chapter "Beyond the basics" in the Installation Guide.

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

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
YYYY/MM/DD
7.1.8 (recommended)

If you plan to install or upgrade IBM Db2 Analytics Accelerator, please read
V7.1.8 Release Notes and contact IBM support by opening a PMR.
Container image for IBM Integrated Analytics System:
For upgrade of IBM Db2 Analytics Accelerator, please contact IBM support by opening a PMR.

"Accelerator server:"-build number in Data Studio:
7.1.8.201906051938
2019/06/14
Stored procedures:

db2z.7.1.8 20190529-0922
APAR PH12810 , PTFs UI63624 and UI63625
n/a
7.1.7

Before installing this maintenance
level, read:
V7.1.7 Release Notes
Container image for IBM Integrated Analytics System:
7.1.7.0-Information_Management-IDAA-IIAS

"Accelerator server:"-build number in Data Studio:
7.1.7.201904091946
2019/04/10
Stored procedures:
db2z.7.1.7 20190402-1035
APAR PH10050 , PTFs UI62449 and UI62450
n/a
7.1.6

Before installing this maintenance
level, read:
V7.1.6 Release Notes
Container image for IBM Integrated Analytics System:
7.1.6.0-Information_Management-IDAA-IIAS

"Accelerator server:"-build number in Data Studio:
7.1.6.201901251843
2019/01/31
Stored procedures:
db2z.7.1.6 20190110-1303
APAR PH07923 , PTFs UI61039 and UI61040
n/a
7.1.5

Before installing this maintenance
level, read:
V7.1.5 Release Notes
Container image for IBM Integrated Analytics System:
7.1.5.0-Information_Management-IDAA-IIAS

"Accelerator server:"-build number in Data Studio:
7.1.5.201812122125
2018/12/20
Stored procedures:
db2z.7.1.5 20181127-1628
APAR PH05973 , PTFs UI60083 and UI60084
n/a
7.1.4

Before installing this maintenance
level, read:
V7.1.4 Release Notes
Container image for IBM Integrated Analytics System:
7.1.4.0-Information_Management-IDAA-IIAS

"Accelerator server:"-build number in Data Studio:
7.1.4.201810151902
2018/10/25
Stored procedures:
db2z.7.1.4 20181005-0938
APAR PH03159 , PTFs UI59309 and UI59310
n/a
7.1.3

Before installing this maintenance
level, read:
V7.1.3 Release Notes
Container image for IBM Integrated Analytics System:
7.1.3.0-Information_Management-IDAA-IIAS

"Accelerator server:"-build number in Data Studio:
7.1.3.201808311247
2018/09/07
Stored procedures:
db2z.7.1.3 20180801-0706
APAR PH01379 , PTFs UI57875 and UI57876
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
YYYY/MM/DD
7.1.8 (recommended)

If you plan to install or upgrade IBM Db2 Analytics Accelerator, please read
V7.1.8 Release Notes and contact IBM support by opening a PMR.
Container image for IBM Z:
For install/upgrade of IBM Db2 Analytics Accelerator, please contact IBM support by opening a PMR.

"Accelerator server:"-build number in Data Studio:
7.1.8.201906060822
2019/06/14
Stored procedures:

db2z.7.1.8 20190529-0922
APAR PH12810 , PTFs UI63624 and UI63624
n/a
7.1.7

Before installing this maintenance
level, read:
V7.1.7 Release Notes
Container image for IBM Z:
7.1.7.0-Information_Management-IDAA-Z

"Accelerator server:"-build number in Data Studio:
7.1.7.201904092110
2019/04/10
Stored procedures:
db2z.7.1.7 20190402-1035
APAR PH10050 , PTFs UI62449 and UI62451
n/a
7.1.6.1

Before installing this maintenance
level, read:
V7.1.6 Release Notes
Container image for IBM Z:
7.1.6.1-Information_Management-IDAA-Z

"Accelerator server:"-build number in Data Studio:
7.1.6.201901220752
2019/03/10
Stored procedures:
db2z.7.1.6 20190110-1303
APAR PH07923 , PTFs UI61039 and UI61041
n/a
7.1.5

Before installing this maintenance
level, read:
V7.1.5 Release Notes
Container image for IBM Z:
7.1.5.0-Information_Management-IDAA-Z

"Accelerator server:"-build number in Data Studio:
7.1.5.201812170145
2018/12/20
Stored procedures:
db2z.7.1.5 20181127-1628
APAR PH05973 , PTFs UI60083 and UI60085
n/a
7.1.4

Before installing this maintenance
level, read:
V7.1.4 Release Notes
Container image for IBM Z:
7.1.4.0-Information_Management-IDAA-Z

"Accelerator server:"-build number in Data Studio:
7.1.4.201810180959
2018/10/30
Stored procedures:
db2z.7.1.4 20181005-0938
APAR PH03159 , PTFs UI59309 and UI59311
n/a
7.1.3

Before installing this maintenance
level, read:
V7.1.3 Release Notes
Container image for IBM Z:
7.1.3.0-Information_Management-IDAA-Z

"Accelerator server:"-build number in Data Studio:
7.1.3.201809050615
2018/09/07
Stored procedures:
db2z.7.1.3 20180801-0706
APAR PH01379 , PTFs UI57875 and UI57877
n/a

Hardware requirements

The following table shows the 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

    Note:

    The Hardware Management Console (HMC) MCL bundle 32 needs to be installed on the HMC to be able to configure and use the call-home function for the accelerator.

  • Hardware requirements for acceleration on IBM Z

    Computers

    Quantity Product Type
    1

    IBM z14™ - Models: M01, M02, M03, M04, M05

    or

    3906

    IBM z14™ - Model: ZR1

    or

    3907

    IBM z13™   - Models N30, N63, N96, NC9 and NE1

    or

    2964

    IBM z13™   - Models N10 and N20

    or

    2965

    IBM LinuxOne Emperor II - Models LM1, LM2, LM3, LM4 and LM5

    or

    3906

    IBM LinuxOne Emperor -  Models L30, L63, L96, LC9 and LE1

    or

    2964

    IBM LinuxOne Rockhopper - Models L10 and L20

    or

    2965
    IBM LinuxOne Rockhopper II - Model LR1 3907

    Note:

    For z14 and for z13/z14 mixed operation: at least Hardware Management Console (HMC) bundle H07, SE bundle S23

    For z13: at least HMC bundle H36, SE bundle S68

    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 For getting-started use cases, the minimum suggested configuration is:
    • 2 IFLs, 64 GB memory and 16 GB for each CDC subscription
    The recommended ratio between IFLs and memory is : 32 up to 128 GB for each IFL
    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.

    Call-home function
    To use the Hardware Management Console (HMC) call-home function with IBM Db2 Analytics Accelerator, your network must have been prepared accordingly:

    • Two cables are required between the IBM Integrated Analytics System and the HMC network switch.
    • A sufficient number of IP addresses must have been defined for the purpose. That is, each accelerator processing node requires a static IP address in the HMC network. In addition, a floating IP address must be defined, which is used for the head node.
    • The network connection between IBM Db2 Analytics Accelerator and the HMC must be a switched connection (Layer-2 network), where the IP addresses of both devices are in the same subnet. A routed network connection (Layer-3 network) won't work.

    In many cases, the support engineer makes the necessary provisions during the initial installation of IBM Db2 Analytics Accelerator on the basis of the submitted site survey. However, if you do not yet meet the network requirements, you must open a service request.

    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.
     

    If a Firewall is in place for the network between the accelerator and the Db2 for z/OS-LPAR, at least the following ports must be accessible for the IP addresses assigned to the accelerator and z/OS LPAR:
    1400, 1401, 1500, 1600, 2222, 11301-11350, 11351-11399, 11400, 11401, 51113, plus GDPS server ports (if GDPS support is used).

    VLANs (access and trunk interfaces) are supported for networks configured for the accelerator. A trunk interface can carry traffic for two or more VLANs and requires VLAN specification in the network interface on the HMC (for the "management network") or the data network, connecting to Db2 for z/OS.

    For appliance installation and management, a Web browser (Firefox or Chrome) with network access to the LPAR is required. If a Firewall is in place for this "management network", at least HTTP/HTTPS ports (80 and 443) must be accessible for the appliance and the machine running the Web browser in this network.
    If IP addresses defined for the appliance and the machine running the Web browser are in different networks and network routing is implemented, the corresponding gateway must be specified during LPAR network definition.  

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.


Mandatory DB2-PTFs

Mandatory PTFs for using Db2 11

When running IBM Db2 Analytics Accelerator for z/OS V7.1.0 with Db2 11, the following DB2-PTFs must be installed:

Db2 PTF number Db2 APAR number Mandatory since accelerator maintenance level Comments
UI51280 PI83286
PI83288
7.1.4 only required when using the HTAP feature
UI57924 PI96258 7.1.3
UI60265 PH00933 7.1.5 only required when using local date format
UI62786 PH00574
PH10672
7.1.5 required when using monitoring of HTAP queries
PE-Resolver of UI60152: solves issue of DSNX881I msgs no longer sent

Mandatory PTFs for using Db2 12

When running IBM Db2 Analytics Accelerator for z/OS V7.1.0 with Db2 12, the following DB2-PTFs must be installed:

Db2 PTF number Db2 APAR number Mandatory since accelerator maintenance level Comments
UI54293 PI91620 7.1.3
UI57923 PI96258 7.1.3
UI60263 PH00933 7.1.5 only required when using local date format
UI62783 PH00574
PH10672
7.1.5 required when using monitoring of HTAP queries
PE-Resolver of UI60151: solves issue of DSNX881I msgs no longer sent

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
7.1.8.0

7.1.8-Information_Management-IDAA_Studio-Multiplatform-20190603-1704

7.1.7.0

7.1.7-Information_Management-IDAA_Studio-Multiplatform-20190326-1029

7.1.6.0

7.1.5-Information_Management-IDAA_Studio-Multiplatform-20181206-0857

7.1.5.0

7.1.5-Information_Management-IDAA_Studio-Multiplatform-20181206-0857

7.1.4.0

7.1.4-Information_Management-IDAA_Studio-Multiplatform-20181015-2031

7.1.4.201810152027
7.1.3.0

7.1.3-Information_Management-IDAA_Studio-Multiplatform-20180816-2109

7.1.3.201808242139

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

 

IBM DB2 Analytics Accelerator Loader for z/OS

IBM DB2 Analytics Accelerator Loader for z/OS (further on abbreviated as 'the Loader') is a Db2 Tools product that provides capabilities and options for loading data into Db2 for z/OS and IBM Db2 Analytics Accelerator. These capabilities let you select the load option that best meets your business needs when populating data in the Analytics Accelerator. For more information on the Loader see the corresponding see knowledge center.
For use of the Loader with IBM Db2 Analytics Accelerator for z/OS V7.1, PTF UI60317 (or its successor) is mandatory.
For the list of available Loader-PTFs please see here.


Document information

More support for: DB2 Analytics Accelerator for z/OS

Component: Not Applicable

Software version: 7.1.0

Operating system(s): z/OS

Reference #: 7050440

Modified date: 21 June 2019