IBM Support

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

Product Documentation


Abstract

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

Content

  • What's new

    Please find information about new functions here.

  • Installation & upgrade recommendations
    • Initial installation

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

      Contact your IBM support representative or IBM support to receive a copy of the Solution Assurance Product Review Guide.
    • Upgrading the maintenance level

      If you plan to upgrade IBM Db2 Analytics Accelerator, please contact IBM support by opening a case.
      For acceleration on IBM Integrated Analytics System we would like you to create an Appliance trace and to upload it to the support case for an offline health check of the system.
      For acceleration on IBM Z we need to know the current maintenance level of the accelerator software and the one you want to upgrade to.

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

      For IBM Integrated Analytics System there are two options for transferring the container image from your workstation to the accelerator:

      • Transfer of the container image using IBM DB2 Analytics Accelerator Studio (recommended)
        Under the cover this transfer consists of the following two steps:
        a) transfer to a global temporary table on Db2 z in parallel with
        b) transfer from Db2 z to the accelerator
        Make sure the corresponding Db2 z system has at least 25 GB of free space available for temporary tables.
      • Transfer of the container image via zFS
        This transfer consists of the following two steps:
        a) transfer to a directory in zFS followed by
        b) transfer from zFS to the accelerator using IBM DB2 Analytics Accelerator Studio or a call of the corresponding stored procedure.
        Make sure the zFS file system has at least 25 GB of free space available.
    • 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.

    • Accelerator on IBM Z: mandatory Microcode Change Level (MCL) for maintenance level 7.5.6(.1) or later

      The following Microcode Change Levels (MCL) or higher are mandatory with accelerator maintenance level 7.5.6(.1) or later. (They were already recommended for accelerator maintenance level 7.5.5.):

      • IBM z15™ & IBM LinuxONE™ III (all models)
        • Bundle S29 (2020-09-28)
        • P46640.014 ZBootLoader
      • IBM z14™ & IBM LinuxONE™ II (all models)
        • Bundle S46 (2020-11-11)
        • P41454.005 1stBootLoader
        • P41453.004 BCBase (refcode and FFDC definitions)
        • P41414.298 SE
        • HMC Bundle H23 / MCL P41499.189
      • IBM z13™ & IBM LinuxONE™ I (all models)
        • Bundle S101 (2020-11-18)
        • P08442.037 1stBootLoader
        • P00339.409 SE
        • HMC Bundle H66 / MCL P08462.316

      Product Engineering always recommends the highest available MCL level for best performance and availability.
      Please find information concerning IBM Z and IBM LinuxONE firmware updates and fixes here.

      Note:
      • The scheduled operations 'Transmit system availability data' and 'Serviceability Config Update' have to be enabled.
      • If an MCL upgrade is necessary to achieve the levels described above, make sure to trigger it at latest 14 days prior to planned upgrade of the accelerator to maintenance level 7.5.6(.1) or later.
    • Accelerator on IBM Z and storage: only fully-provisioned volumes are currently supported

      Only use fully-provisioned storage volumes are supported for installation of maintenance level 7.5.6(.1) or later and subsequent use of the accelerator. This applies to all kind of devices (data, boot, and runtime). For more information see APAR PH39057.

  • Maintenance level of the accelerator - 7.5.9 is available
    Each maintenance level consists of two components:
    • A container image for installation on the accelerator; this is normally downloaded from FixCentral
    • SMP/E-installable PTFs
    • Maintenance level - Accelerator on IBM Integrated Analytics System
      For IBM Integrated Analytics System the following maintenance levels are available:

      IBM Db2 Analytics Accelerator
      for z/OS 7.5 maintenance level
      Component Release date
      YYYY/MM/DD
      7.5.9 (recommended)

      Before installing this maintenance
      level, read:
      V7.5.9 Release Notes
      Note:
      If you are upgrading from an accelerator maintenance level prior to 7.5.7, the upgrade to 7.5.7.1 is a mandatory step in between before performing the upgrade to 7.5.9
      Container image for IBM Integrated Analytics System:
      7.5.9.0-Information_Management-IDAA-IIAS
      Please contact IBM support by opening a pro-active case to get further assistance for the installation/upgrade.

      "Accelerator server:"-build number in Data Studio:
      7.5.9.202207200611
      2022/08/06
      Stored procedures:


      db2z.7.5.9 20220622-1151
      APAR PH48263, PTFs UI81778 and UI81779
      2022/08/06
      7.5.8

      Before installing this maintenance
      level, read:
      V7.5.8 Release Notes
      Note:
      If you are upgrading from an accelerator maintenance level prior to 7.5.7, the upgrade to 7.5.7.1 is a mandatory step in between before performing the upgrade to 7.5.8
      Container image for IBM Integrated Analytics System:
      7.5.8.0-Information_Management-IDAA-IIAS
      Please contact IBM support by opening a pro-active case to get further assistance for the installation/upgrade.

      "Accelerator server:"-build number in Data Studio:
      7.5.8.202204070831
      2022/04/26
      Stored procedures:


      db2z.7.5.8 20220315-1454
      APAR PH45639, PTFs UI80135 and UI80136
      2022/04/21
      7.5.7

      The release notes of maintenance level 7.5.7 still apply; therefore read the V7.5.7 Release Notes before installing maintenance level 7.5.7.1.
       
      Note:
      Maintenance level 7.5.7.1 (7.5.7)includes a change of the container management technology (from Docker to Podman). Therefore the upgrade to 7.5.7.1 is a mandatory step for subsequent upgrades to higher maintenance levels if your current maintenance level is less than 7.5.7.
      Container image for IBM Integrated Analytics System:
      7.5.7.1-Information_Management-IDAA-IIAS
      Please contact IBM support by opening a pro-active case to get further assistance for the installation/upgrade.

      "Accelerator server:"-build number in Data Studio:
      7.5.7.202201311131
      2022/03/10
      Stored procedures:


      db2z.7.5.7 20211118-1441
      APAR PH42174, PTFs UI78158 and UI78159
      2021/11/19
      7.5.6

      Before installing this maintenance
      level, read:
      V7.5.6 Release Notes
      Container image for IBM Integrated Analytics System:
      7.5.6-Information_Management-IDAA-IIAS
      Please contact IBM support by opening a pro-active case to get further assistance for the installation/upgrade.

      "Accelerator server:"-build number in Data Studio:
      7.5.6.202106211614
      2021/07/02
      Stored procedures:

      db2z.7.5.6 20210512-0823
      APAR PH38277, PTFs UI75991 and UI75992
      n/a
      7.5.5.1

      The release notes of maintenance level 7.5.5 still apply; therefore read the V7.5.5 Release Notes before installing maintenance level 7.5.5.1.
      Container image for IBM Integrated Analytics System:
      7.5.5.1-Information_Management-IDAA-IIAS
      Please contact IBM support by opening a pro-active case to get further assistance for the installation/upgrade.

      "Accelerator server:"-build number in Data Studio:
      7.5.5.202103231457
      2021/03/30
      Stored procedures:

      db2z.7.5.5 20210219-1722
      APAR PH35338, PTFs UI74501 and UI74502
      or optionally
      db2z.7.5.5 20210310-1545
      APAR PH35715, PTFs UI74605 and UI74606
      n/a
      7.5.4.2

      The release notes of maintenance level 7.5.4 still apply; therefore read the V7.5.4 Release Notes before installing maintenance level 7.5.4.2.
      Container image for IBM Integrated Analytics System:
      7.5.4.2-Information_Management-IDAA-IIAS
      Please contact IBM support by opening a pro-active case to get further assistance for the installation/upgrade.

      "Accelerator server:"-build number in Data Studio:
      7.5.4.202101210111
      2021/01/27
      Stored procedures:

      db2z.7.5.4 20201130-1018
      APAR PH32250, PTFs UI73019 and UI73020
      n/a
      7.5.3

      Before installing this maintenance
      level, read:
      V7.5.3 Release Notes.
      Container image for IBM Integrated Analytics System:
      7.5.3.0-Information_Management-IDAA-IIAS
      Please contact IBM support by opening a pro-active case to get further assistance for the installation/upgrade.

      "Accelerator server:"-build number in Data Studio:
      7.5.3.202010021138
      2020/10/15
      Stored procedures:

      db2z.7.5.3 20200902-0645
      APAR PH29695, PTFs UI72071 and UI72072
      n/a
       
    • Maintenance level - Accelerator on IBM Z

      For IBM Z the following maintenance levels are available:

      IBM Db2 Analytics Accelerator
      for z/OS 7.5 maintenance level
      Component Release date
      YYYY/MM/DD
      7.5.9 (recommended)

      Before installing this maintenance
      level, read:
      V7.5.9 Release Notes
      Container image for IBM Z:
      7.5.9.0-Information_Management-IDAA-Z
      Please contact IBM support by opening a pro-active case and provide the IDAA maintenance level from where you are upgrading. IDAA support may convey further information concerning the installation/upgrade.
      "Accelerator server:"-build number in Data Studio:
      7.5.9.202207200611
      2022/08/06
      Stored procedures:

      db2z.7.5.9 20220622-1151
      APAR PH48263, PTFs UI81778 and UI81780
      2022/08/06
      7.5.8.1

      The release notes of maintenance level 7.5.8 still apply; therefore read the V7.5.8 Release Notes before installing maintenance level 7.5.8.1.
      Container image for IBM Z:
      7.5.8.1-Information_Management-IDAA-Z
      Please contact IBM support by opening a pro-active case and provide the IDAA maintenance level from where you are upgrading. IDAA support may convey further information concerning the installation/upgrade.
      "Accelerator server:"-build number in Data Studio:
      7.5.8.202204291459
      2022/05/24
      Stored procedures: (same level for 7.5.8 and 7.5.8.1)

      db2z.7.5.8 20220315-1454
      APAR PH45639, PTFs UI80135 and UI80137
      2022/04/21
      7.5.7.1

      The release notes of maintenance level 7.5.7 still apply; therefore read the V7.5.7 Release Notes before installing maintenance level 7.5.7.1.
      Container image for IBM Z:
      7.5.7.1-Information_Management-IDAA-Z
      Please contact IBM support by opening a pro-active case and provide the IDAA maintenance level from where you are upgrading. IDAA support may convey further information concerning the installation/upgrade.
      "Accelerator server:"-build number in Data Studio:
      7.5.7.202201311131
      2022/03/04
      Stored procedures:

      db2z.7.5.7 20211118-1441
      APAR PH42174, PTFs UI78158 and UI78160
      2021/11/19
      7.5.6.1

      The release notes of maintenance level 7.5.6 still apply; therefore read the V7.5.6 Release Notes before installing maintenance level 7.5.6.1.
      Container image for IBM Z:
      7.5.6.1-Information_Management-IDAA-Z
      Please contact IBM support by opening a pro-active case and provide the IDAA maintenance level from where you are upgrading. IDAA support may convey further information concerning the installation/upgrade.
      "Accelerator server:"-build number in Data Studio:
      7.5.6.202106211614 (same as for 7.5.6)
      "Appliance software:"-build number in Data Studio:
      7.5.6.1.20211011-0549
      2021/10/21
      Stored procedures: (same as for 7.5.6)

      db2z.7.5.6 20210512-0823
      APAR PH38277, PTFs UI75991 and UI75993
      n/a
      7.5.5.2

      The release notes of maintenance level 7.5.5 still apply; therefore read the
      V7.5.5 Release Notes before installing maintenance level 7.5.5.2.
      Container image for IBM Z:
      7.5.5.2-Information_Management-IDAA-Z
      Please contact IBM support by opening a pro-active case and provide the IDAA maintenance level from where you are upgrading. IDAA support may convey further information concerning the installation/upgrade.
      "Accelerator server:"-build number in Data Studio:
      7.5.5.202104141234
      2021/04/23
      Stored procedures:

      db2z.7.5.5 20210219-1722
      APAR PH35338, PTFs UI74501 and UI74502
      or optionally
      db2z.7.5.5 20210310-1545
      APAR PH35715, PTFs UI74605 and UI74606
      n/a
      7.5.4.2

      The release notes of maintenance level 7.5.4 still apply; therefore read the V7.5.4 Release Notes before installing maintenance level 7.5.4.2.
      Container image for IBM Z:
      7.5.4.2-Information_Management-IDAA-Z
      Please contact IBM support by opening a pro-active case and provide the IDAA maintenance level from where you are upgrading. IDAA support may convey further information concerning the installation/upgrade.
      "Accelerator server:"-build number in Data Studio:
      7.5.4.202101210936
      2021/01/27
      Stored procedures:
      db2z.7.5.4 20201130-1018
      APAR PH32250, PTFs UI73019 and UI73021
      n/a
      7.5.3

      Before installing this maintenance
      level, read:
      V7.5.3 Release Notes.
      Container image for IBM Z:
      7.5.3.0-Information_Management-IDAA-Z
      Please contact IBM support by opening a pro-active case and provide the IDAA maintenance level from where you are upgrading. IDAA support may convey further information concerning the installation/upgrade.
      "Accelerator server:"-build number in Data Studio:
      7.5.3.202010021138
      2020/10/15
      Stored procedures:
      db2z.7.5.3 20200902-0645
      APAR PH29695, PTFs UI72071 and UI72073
      n/a
       
    • IDAA V7 - APARs
  • Coexistence with Db2 Analytics Accelerator V5
    To run IBM Db2 Analytics Accelerator for z/OS® Version 7 and IBM Db2 Analytics Accelerator for z/OS® Version 5 side-by-side in a coexistence setup (that is : pairing a V7 accelerator to a Db2 for z/OS subsystem that has already been paired to a V5 accelerator), the V5 stored procedures must be at least at maintenance level V5 PTF-4.
    If IBM DB2 Analytics Accelerator Loader for z/OS will be used in a coexistence setup to load data to both a V7 accelerator and a V5 accelerator, the V5 stored procedures must be at least at maintenance level V5 PTF-8 while for the Loader maintenance level the PTF for APAR PH37059 is mandatory.
  • Hardware requirements
    The following sections show 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 z16™ - Models: A01 (requires Accelerator maintenance level 7.5.8 or later)
        or
        3931
        IBM z15™ - Models: T01, T02
        or
        8561, 8562
        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
        or
        3907
        IBM LinuxONE III - Models LT1, LT2 8561, 8562
        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, 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
          • For FICON attached storage devices the use of HyperPAV and zHPF is mandatory.
          • For both FCP and FICON attached storage devices we strongly recommend the use of all-flash storage.
        • The required Appliance operation pool size (Installation and boot disk size) changed with maintenance level 7.1.7. Without the right pool size the first boot will fail after uploading the Accelerator image.
          For more information see the table 'Recommended pools and pool sizes' in chapter Installing Db2 Analytics Accelerator on Z of the Installation Guide.
        Note:
        Either feature code (FC) 0103 Linux Hosting Foundation or 0104 Container Hosting Foundation is required to deploy Db2 Analytics Accelerator V7 on IBM Z or LinuxONE after January 15, 2020. This affects the following machine types:

        Products Models
        IBM z15 – all models Type 8561,8562
        IBM z14 – all models Type 3906, 3907
        IBM LinuxONE Emperor II – all models Type 3906, 3907
        IBM LinuxONE Emperor III – all models Type 8561, 8562
        The entitlement of the FC is for the lifetime of the server; no annual renewal is required. Renew the entitlement with each new server generation (new build or machine upgrade). Order the appropriate FC for each server where Db2 Analytics Accelerator for z/OS V7 solution will be deployed on.
        Keep in mind that you must order the FC even if Subscription & Support has already been purchased for the solution.
      • Mandatory Microcode Change Level (MCL) for maintenance level 7.5.6(.1) or higher

        The following Microcode Change Levels (MCL) or higher are mandatory with accelerator maintenance level 7.5.6(.1) or later. (They were already recommended for accelerator maintenance level 7.5.5.):

        • IBM Z15™ & IBM LinuxONE™ III (all models)
          • Bundle S29 (2020-09-28)
          • P46640.014 ZBootLoader
        • IBM Z14™ & IBM LinuxONE™ II (all models)
          • Bundle S46 (2020-11-11)
          • P41454.005 1stBootLoader
          • P41453.004 BCBase (refcode and FFDC definitions)
          • P41414.298 SE
          • HMC Bundle H23 / MCL P41499.189
        • IBM Z13™ & IBM LinuxONE™ I (all models)
          • Bundle S101 (2020-11-18)
          • P08442.037 1stBootLoader
          • P00339.409 SE
          • HMC Bundle H66 / MCL P08462.316

        Product Engineering always recommends the highest available MCL level for best performance and availability.
        Please find information concerning IBM Z and IBM LinuxONE firmware updates and fixes here.

        Note:
        • The scheduled operations 'Transmit system availability data' and 'Serviceability Config Update' have to be enabled.
        • If an MCL upgrade is necessary to achieve the levels described above, make sure to trigger it at latest 14 days prior to planned upgrade of the accelerator to maintenance level 7.5.6(.1) or later.
      • Storage: only fully-provisioned volumes are currently supported

        Only use fully-provisioned storage volumes are supported for installation of maintenance level 7.5.6(.1) and subsequent use of the accelerator. This applies to all kind of devices (data, boot, and runtime). For more information see APAR PH39057.

  • Network requirements
    The following sections show the network requirements that must be met to successfully run IBM DB2 Analytics Accelerator for z/OS.
    • Network requirements for acceleration on IBM Integrated Analytics System
      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-ExpressxS card, x= 3,4,5,6,7 IBM System z
        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-ExpressxS card, x= 3,4,5,6,7 IBM System z 
        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
      • 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.
    • 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. This connection can either be defined using

      • OSA Express interfaces in IBM z14 or IBM z15
      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 (25 GbE) connectivity with Jumbo Frames.
      Note:
      • OSA-Express7S 25 GbE cards are supported using maintenance level 7.5.2.2 or higher
      • When using an OSA-Express7 card make sure to have the latest Microcode Change Level (MCL) in place.
       

      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 systems
      Operating system Required z/OS base elements
      z/OS V2R5
      z/OS V2R4
      z/OS V2R3
      z/OS V2R2
      z/OS OpenSSH
      Data Facility System Managed Storage Base (DFSMSdfp)
      Communications Server IP
       

      To avoid performance degradation during load operations we strongly recommend to install the PTF for APAR OA61558.

    • 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 Program number
      DB2 13 for z/OS
      (requires Accelerator maintenance level 7.5.8 or later)
      5698-DB2 (MLC)
      or
      5698-DBV (Value Unit Edition)
      DB2 Utilities Suite for z/OS version 13.1 5698-DUT
      DB2 12 for z/OS 5650-DB2 (MLC)
      or
      5770-AF3 (Value Unit Edition)
      DB2 Utilities Suite for z/OS version 12.1 5770-AF4
      DB2 11 for z/OS
      New Function Mode (NFM)
      5615-DB2 (MLC)
      or
      5697-P43 (Value Unit Edition)
      DB2 Utilities Suite for z/OS version 11.1 5655-W87
      Note:
      A number of Db2-supplied stored procedures must be configured. See the Installation Guide 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.
    • Recommended 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
      • Mandatory Db2-PTFs
        • Mandatory PTFs for using Db2 13

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

          Db2 PTF number Db2 APAR number Mandatory since accelerator maintenance level Comments
          UI80810 PI45854 7.5.8 only required when using Integrated synchronization
        • Mandatory PTFs for using Db2 12

          When running IBM Db2 Analytics Accelerator for z/OS V7 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
          UI63996 PH00574
          PH10672
          PH13109
          7.1.5 required when using monitoring of HTAP queries
          UI63356
          UI69536
          UI71876
          UI75930
          UI77365
          PH06628
          PH23895
          PH28849
          PH37808
          PH40261
          7.5.0 only required when using Integrated synchronization which also requires function level V12R1M500
        • Mandatory PTFs for using Db2 11

          When running IBM Db2 Analytics Accelerator for z/OS V7 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
          UI63997 PH00574
          PH10672
          PH13109
          7.1.5 only required when using monitoring of HTAP queries
      • Recommended Db2-PTFs
        To determine all (Db2-)PTFs recommended for use with IBM Db2 Analytics Accelerator for z/OS V7, 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
          • For V7.1: Fix Category FIXCAT (IBM.DB2.AnalyticsAccelerator.V7R1)
          • For V7.5: Fix Categories FIXCAT (IBM.DB2.AnalyticsAccelerator.V7R1, IBM.DB2.AnalyticsAccelerator.V7R5).
          The report will identify missing PTFs associated with that categories 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.

        30 March 2021: We strongly recommend to apply both the PTFs for the APARs PH21726 and PH28050 of Db2 12 for z/OS having been marked HIPER and having got the FIXCAT keywords IDAAV5R1/K and IDAAV7R5/K. Together these PTFs resolve the following issue:
        "Queries running on Db2 for z/OS are unexpectedly executed on Db2 Analytics Accelerator if QUERY ACCELERATION has been set to 'ENABLE' or 'ENABLE WITH FAILBACK'. This especially happens if queries have index access on tables with multiple indexes defined. A more costly access path will be chosen resulting in an execution of the query on the accelerator".

    • GDPS support (Accelerator on IBM Z only)
      With maintenance level 7.5.1 (or higher) the integration with IBM GDPS ® (Geographically Dispersed Parallel Sysplex) for high availability and disaster recovery is supported. This requires the following GDPS product versions: GDPS Metro Global GM 3-site and 4-site configurations are supported if the PTF for APAR PH27382 has been installed.
  • Incremental update
    The incremental update function of IBM Db2 Analytics Accelerator for z/OS® allows you to update accelerator-shadow tables continually. Changes to the data in original Db2 for z/OS tables are thus propagated to the corresponding target tables with a high frequency and just a brief delay. This way, query results from an accelerator are always extracted from recent, close-to-real-time data.
    • Integrated Synchronization (release 7.5 or higher)
      Integrated synchronization is a built-in product feature that makes it easy to set up incremental updates. It does not require IBM InfoSphere Data Replication for z/OS (CDC), and therefore requires fewer customization and activation steps. In addition, integrated synchronization has further advantages:

      • Reduced complexity.
      • Updates are processed very fast.
      • Reduced CPU consumption on the mainframe because most of the processing is done on the client side (accelerator).
      • On the mainframe, the workload can be handled by IBM z Systems® Integrated Information Processors (zIIP).
      • Speedier service request processing through better support channel integration
        Integrated synchronization requires
      • Db2 12 for z/OS with PTFs UI77365, UI75930, UI71876, UI69536, and UI63356 installed, running at function level V12R1M500
      • Distributed data facility (DDF) with a secure port, configured for network encryption through AT-TLS
      • For data sharing groups: ability to always connect to the same member, for example by using a member-specific secure port that has a local alias.
      • IBM Db2 Analytics Accelerator for z/OS Version 7.5 or later.
    • Incremental update (using IBM InfoSphere Data Replication for z/OS)
  • Administering the accelerator
    Data Server Manager and IBM DB2 Analytics Accelerator Studio provide a graphical administration interface for the product.
    • Data Server Manager
      Click here for more information on the IBM Db2 Data Management Console and Data Server manager .
      IBM Db2 Data Management Console and Data Server Manager can be downloaded here.
    • IBM Db2 Analytics Accelerator Studio
      IBM Db2 Analytics Accelerator Studio can be downloaded from:

      It consists of a set of Eclipse plug-ins that are added to IBM Data Studio V4.1.4.
      Note:
      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.

      The following maintenance levels of IBM Db2 Analytics Accelerator Studio are available:
      IBM Db2 Analytics Accelerator for z/OS V7
      maintenance level
      IBM DB2 Analytics Accelerator Studio (client) required minimum version
      Refresh-Pack name as appearing on Fix Central
      7.5.9
      7.5.8

      7.5.8-Information_Management-IDAA_Studio-Multiplatform-20220615-1213

      7.5.7

      7.5.7-Information_Management-IDAA_Studio-Multiplatform-20211013-1753

      7.5.6(.1)

      7.5.6-Information_Management-IDAA_Studio-Multiplatform-20210514-1554

      7.5.5

      7.5.5-Information_Management-IDAA_Studio-Multiplatform-20210308-0658

      7.5.4

      7.5.4-Information_Management-IDAA_Studio-Multiplatform-20201207-0212

      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.

      The following maintenance level of IBM Data Studio are supported:

      We strongly recommend to upgrade your IBM Data Studio installation to this maintenance level using the following steps:

      1. Backup the Data Studio workspace:
        • Locate workspace folder as described here.
        • Compress the workspace folder into a zip file.
        • Save the zip file in another directory (your “new workspace path” for Data Studio).
        • Extract the contents of the zip file into the directory which now serves as “new workspace path”.
      2. Un-install existing Data Studio 4.1.3 (or previous version)
      3. Install Data Studio 4.1.4, described here
      4. Import saved workspace:
        • Launch Data Studio.
        • When prompted for workspace, browse to the “new workspace path”.
        • If the workspace prompt does not pop up, click on "File -> Switch Workspace -> Other".
        • Click on Browse to navigate to your “new workspace path”.
        • Click OK.
        • Close Data Studio.
      5. Install Data Studio 4.1.4 APAR1.
      6. Get latest version of IBM Db2 Analytics Accelerator Studio plugin.
      7. Install plugin as described here (hint: click “Install”).

      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.4 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 Administration Services API
      Db2 Analytics Accelerator Admin Services consists of a set of RESTful APIs that you can use in your  applications to streamline or to automate the Accelerator administration or management.   These Db2 Analytics Accelerator Admin Services are leveraged by the product Db2 Administration Foundation which provides a Zowe-based user interface for administering the Accelerator.  For an overview, installation and configuration of the Db2 Analytics Accelerator Admin Services click here.
      Db2 Analytics Accelerator Admin Services can be downloaded here.
  • IBM Db2 Analytics Accelerator Loader
    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 here.
    For use of the Loader with IBM Db2 Analytics Accelerator for z/OS V7, the PTF for Loader-APAR PH37059 is mandatory.
    For the list of available Loader-PTFs please see here.
  • Documentation, Technotes
  • Collaboration
    • IBM Hybrid Data Management Community
      For collaboration with IBM and other users of IBM Db2 Analytics Accelerator for z/OS click here.
  • History of changes
    6 August 2022:
    • Availability of 7.5.9
    6 July 2022:
    • DB2 Analytics Accelerator Studio 7.5.8 - editon of 2022-05-02 replaced with the one of 2022-06-17
    2 June 2022:
    • Adaptations of the list of mandatory PTFs required for Integrated Synchronization
    29 May 2022:
    • Availability of 7.5.8.1 for Accelerator on System Z
    11 May 2022:
    • Adapt links to Accelerator manuals reflecting availability of 7.5.8
    27 April 2022:
    • Availability of 7.5.8
    25 April 2022:
    • Add subsection "Using" within section "Technotes / Red Papers"
    24 April 2022:
    • Add/start list of mandatory PTFs for Db2 13
    • Add further items to list of mandatory PTFs for Db2 12
    • Add paragraph for Db2 Analytics Accelerator Admin Services to section "Administering the accelerator"
    5 April 2022:
    • Add IBM z16 and Db2 13 to the list of supported HW/SW
    4 April 2022:
    • Add link to technote "WAITFORDATA queries and table types in Db2 Analytics Accelerator"
    13 March 2022:
    • Availability of 7.5.7.1
    4 March 2022:
    • Remove all references to IBM Data Studio maintenance levels less than 4.1.4 and to the Full Image no longer available
    • Add description how to upgrade IBM Data Studio to maintenance level 4.1.4 plus APAR1 patch"
    27/28 January 2022:
    • Adapt V5 maintenance levels in section 'Coexistence with Db2 Analytics Accelerator V5'
    • Specify PTF for Loader-APAR PH37059 as mandatory maintenance level rather than the PTF number
    24 January 2022:
    • Add technote "Network setup options for Db2 Analytics Accelerator for z/OS"
    8 December 2021:
    • Add "Note:" to '7.5.7 on IIAS'-section indicating upgrade to 7.5.7 is mandatory for subsequent upgrades
    5 December 2021:
    • Renew link to Installation Guide (pointing to latest maintenance level 7.5.7)
    23 November 2021:
    • Availability of 7.5.7 on Z
    19 November 2021:
    • Replace APAR/PTFs for Stored Procedures of maintenance level 7.5.7: PH42174 replaces PH41650, UI78158 replaces UI77896, UI78159 replaces UI77897, UI78160 replaces UI77898
    18 November 2021:
    • Availability of 7.5.7 on IIAS
    • z/OS APAR OA61558
    21 October 2021:
    • Availability of 7.5.6.1 for acceleration on Z
    • Add link to red book for IBM GDPS
    3 October 2021:
    • List of supported operating systems: add z/OS 2.5, remove z/OS 2.1
    30 August 2021:
    • Accelerator on IBM Z: need for fully-provisioned volumes
    • Amend list of technotes and redpapers
    8 July 2021:
    • Provide link to Data Studio plugin 7.5.6
    • Clarify MCL levels specified for 7.5.6 to be minimum levels
    • Renew link to Installation Guide (pointed to 7.5.5 rather than 7.5.6)
    2 July 2021:
    • Availability of 7.5.6
    • Correct web links pointing to 'IBM Documentation'
    • New IDAA loader PTF level: UI75879
    • mandatory Db2 PTFs: mention PTF for PH37808
    23 April 2021:
    • Availability of 7.5.5.2 for deployement on Z
    • Documentation: Replace links to Knowledge Center with those pointing to IBM Documentation
    • Documentation: New section for Technotes and Red Papers
    • Required DB2 12 PTFs: UI75930 (APAR PH37808) for Integrated Synchronization
    30/31 March 2021:
    • Availability of 7.5.5.1
    • Add Stored Procedure PTFs for 7.5.5(.1)
    • Recommended/mandatory MCL for accelerator on IBM Z
    • Recommendation for Db2 for z/OS APARs PH21726 and PH28050
    17 March 2021:
    • Availability of 7.5.5
    9 March 2021:
    • Add support of OSA-Express 7S 25 cards
    28 January 2021:
    • Availability of 7.5.4.2
    20 January 2021:
    • Availability of 7.5.4.1
    8 January 2021:
    • Mandatory maintenance level of the loader changed: UI68784 -> UI73179
    • Adapt documentation links with respect to new maintenance level 7.5.4
    • Mention support of GDPS Metro Global GM 3-site and 4-site configurations
    10 December 2020:
    • Availability of 7.5.4
    8 December 2020:
    • Add Db2z APARs PH23895 and PH28849 to the list of mandatory Db2 APARs/PTFs with comment "must have for Integrated Synchronization"
    4 November 2020:
    • Replace outdated link to developerWorks web page for download of IBM Db2 Analytics Accelerator Studio
    30 October 2020:
    • Link to Knowledge Center of IBM Db2 Analytics Accelerator Loader corrected
    23 October 2020:
    • Build label of both Stored Procedures and Accelerator server for 7.5.3 corrected
    21 October 2020:
    • Add link to latest version of IBM Db2 Analytics Accelerator Studio
    • Adapt documentation links with respect to new maintenance level 7.5.3
    • Add section for Collaboration
    15 October 2020:
    • Availability of 7.5.3
    5 October 2020:
    • IDAA on Z storage: add requirement for HyperPAV and zHPF, add strong recommendation for all-flash storage
    23 September 2020:
    • Add new hardware for IDAA on Z: IBM z15 - Model: T02, IBM LinuxONE III - Model LT2
    21 August 2020:
    • Add hot news concerning PH28723 and PH28727
    7 August 2020:
    • Availability of 7.5.2.2, replacing 7.5.2.1
    16 July 2020:
    • Availability of 7.5.2.1, replacing 7.5.2
    15 July 2020:
    • Adapt documentation links with respect to new maintenance level 7.5.2
    • Change wrong APAR number PH26542 to PH26524
    3 July 2020:
    • Availability of maintenance level 7.5.2
    23 April 2020:
    • Adapt documentation links with respect to new maintenance level 7.5.1
    22 April 2020:
    • Availability of maintenance level 7.5.1
    17 April 2020:
    • Link to technote for silent installation of IBM Installation Manager etc. repaired
    • Section for GDPS support added under Software requirements
    16 April 2020:
    • Change mandatory maintenance level for IDAA loader: UI68784 instead of UI60317
    2 April 2020:
    • Add need for latest MCL when using OSA Express7 cards
    • Add reference to Solution Assurance Guide
    30 March 2020:
    • New page layout
    • Add link to list of APARs fixed to maintenance section
    27 March 2020:
    • Add information concerning OSA-Express7S 25GbE cards (PH23677) - only for IDAA on Z
    26 March 2020:
    • Add information for new maintenance level 7.5.0.2 - only for IDAA on Z
    3 March 2020:
    • Add information for new maintenance level 7.5.0.1
    • Describe maintenance level requirements for coexistence between V5 and V7
    • Add section about integrated synchronization
    • Amend paragraph about Db2 12-related prerequisites with needs for integrated synchronization
    • Add section with links to manuals and Knowledge Center for V7

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS4LQ8","label":"Db2 Analytics Accelerator for z\/OS"},"Component":"Not Applicable","Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"7.1.0 7.5.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
09 August 2022

UID

swg27050440