IBM Support

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

Product Documentation


Abstract

This document describes how to get support for installation, upgrading, and operating IBM Db2 Analytics Accelerator for z/OS V7.5.
Furthermore it lists the hardware and software requirements.

Content

  • What's new

    • General news

      • Accelerator maintenance level 7.5.14.2a for IBM Z is now available (Jul 7, 2026).
      • Please find information about new functions here.
      • You want to activate Db2 13 for z/OS function level M509? Make sure to have upgraded your Stored Procedures by applying the PTFs for APAR PH72047. (Jul 7, 2026)

      • Migrating the Accelerator from IIAS to IBM Z (November 10, 2025)

        You are migrating to IBM Z and want to clean up data in your IIAS appliances before decommissioning the hardware? Please open a support case for the Accelerator to get the corresponding activities coordinated. Note: to assist you remotely with the data clean-up, the appliances still need to be reachable via ssh root.

    • News concerning Accelerator on IBM Z

      • You are running the Accelerator on IBM Z with a maintenance level older than 7.5.9 and you want to upgrade to 7.5.14.x or later ? Contact IBM support for advice as an upgrade step in between is mandatory. (Jul 7, 2026)
      • You are running the Accelerator on IBM z16™ or IBM LinuxONE™ Emperor 4 using NVMEs or RoCE-cards? (Mar 30, 2026).
        • If you want to upgrade the Accelerator, we strongly recommend to upgrade to the new maintenance level 7.5.14.2. For details, please see APAR PH69470 which has got a fix in 7.5.14.2.
        • Upgrade your MCL level: when using HMC, get MCL Driver 51C Bundle S53 installed; when using DPM get MCL Driver 51C Bundle S54 installed.
          Note:
          MCL Driver 51C Bundle S53 (S54) will become mandatory with the maintenance level following 7.5.14.2.
      • IBM z17™ and IBM LinuxONE™ Emperor 5 are supported.
        Prerequisites are Accelerator maintenance level 7.5.14.2a or later and MCL Driver D61C Bundle S15 or later (Jul 7, 2026).
      • Technote 'How Db2 Analytics Accelerator for z/OS on IBM Z uses the configured storage'. (Feb 7, 2025)

    • News concerning Accelerator on IBM IIAS

      The upgrade to Accelerator maintenance level 7.5.14.1 (7.5.14) cannot be skipped. It is a mandatory step for upgrades to later maintenance levels of the Accelerator on IIAS. 
      Using Admin Foundation (in combination with Admin Services) to transfer upgrade packages to the accelerator requires installation of PTF UI99021 for UMS-APAR PH61009 or its successor. (May 2, 2025) 

     

  • Migrating from Accelerator Version 7.5 on IBM Z to Version 8.1

    For details concerning the migration from Accelerator Version 7.5 on IBM Z to Version 8.1, see the migration chapter here or the IBM Documentation Center for Version 8.1. We recommend starting the migration of Accelerator V7.5 using maintenance level 7.5.14.1 or later.
    For an overview, read the following sections:

    • General remarks

      An installation of Accelerator V7.5 on IBM Z can be upgraded to V8.1 using the standard upgrade procedure. 
      The following prerequisites must be met / considered before starting the upgrade installation:

      • We recommend starting the migration to Accelerator V8.1 from V7.5 maintenance level 7.5.14.2 or later.
      • A multi-node accelerator setup for V7.5 must use the Confined Head Node-architecture.
      • Any existing CDC-based replication subscription must be disabled.
      • Weak certificates for Integrated Synchronization must be replaced.

    • Stored Procedures

      The stored procedures for Accelerator V8.1 are provided via SMP/E-installable FMIDs HAQTX10 and JAQTXID.

      • See the program directory for details.
      • The installation of the PTF for APAR PH67172 is mandatory. 
      • Install them next to the V7.5 stored procedures. See the paragraphs concerning installation libraries and installation and setup in IBM Documentation for details.
      • In the existing WLM environment, concatenate the V8.1 stored procedure library (SAQTMOD) before the V7.5 stored procedures library.
      • The V8.1 stored procedures work with V7.5 and V8.1 accelerators.
      • After the migration and a test phase have been completed, the V7.5 stored procedures can be deinstalled. Note:
        If you are also using Db2 Data Gate on the same Db2 subsystem, you need to retain the V7.5 stored procedures.

    • Multi-node setup considerations

      • The support for a Cross-Drawer head node-architecture setup has been withdrawn in V8.1.
      • V8.1 will only support the Confined Head Node-architecture. Advantages are:
        • Improved load and workload performance because cross-drawer traffic is avoided
        • No PR/SM interaction involved
        • See the paragraph concerning multi-node setup in IBM Documentation for details.
      • Clients using the Cross-Drawer Head Node-architecture need to migrate to the Confined Head Node-architecture prior or during migration from V7.5 to V8.1.

    • Integrated Synchronization & weak certificates

      • Weak certificates are not supported for Integrated Synchronization in V8.1.
      • Weak certificates in general are old certificates which have a key length less than
        • 2048 bits for an RSA certificate
          RSA : Rivest-Shamir-Adleman, a public-key encryption algorithm.
        • 256 bits for an ECC certificate
          ECC : Elliptic curve cryptography, a public-key encryption algorithm.
      • Integrated Synchronization in V8.1 won’t start if a weak certificate is detected.
      • It is recommended to replace weak certificates with new ones before migrating to V8.1.
        Using Accelerator maintenance level 7.5.14 or later, a DSNX881I message with ID 4047 occurs once a day in DB2MSTR if a weak certificate is detected.

     

    • Coexistence with Db2 Analytics Accelerator V7.5

      To run IBM Db2 Analytics Accelerator for z/OS® Version 8.1 and IBM Db2 Analytics Accelerator for z/OS® Version 7.5 side-by-side in a coexistence setup (that is : pairing a V8.1 accelerator to a Db2 for z/OS subsystem that has already been paired to a V7.5 accelerator), the V8.1 stored procedures must be used to support both Accelerators.
      If IBM DB2 Analytics Accelerator Loader for z/OS V3.1 will be used in a coexistence setup to load data to both a V8.1 accelerator and a V7.5 accelerator (HALOAD), the V8.1 stored procedures must be used.

  • Support - how can we help you?

  • Maintenance level of the accelerator

    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      		ComponentRelease date
      YYYY/MM/DD

      7.5.14.1 (recommended)

      The release notes of maintenance level 7.5.14 do also apply to 7.5.14.1; therefore read the
      V7.5.14 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.13.
      Container image for IBM Integrated Analytics System:

      7.5.14.1-Information_Management-IDAA-IIAS

       

      Please contact IBM support by opening a pro-active case to get further assistance for the installation/upgrade.
       

       
      Build information:
      Accelerator server: 7.5.14.202507281310
      Appliance software: 1.0.31.3
      Db2 level: 11.5.9.0 [Build special 67235]
      		2025/11/20
      Stored procedures:
      (Same level for 7.5.14 and 7.5.14.1)
      Read the release notes for the Stored Procedures. 
      Build label: 20250411-0841
      APAR PH66192, PTFs UO03065 and UO03066
       
      		2025/05/24

      7.5.13.1

      Before installing this maintenance level, read the 
      V7.5.13(.1) 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.13.
      Container image for IBM Integrated Analytics System:

      7.5.13.1-Information_Management-IDAA-IIAS

       

      Please contact IBM support by opening a pro-active case to get further assistance for the installation/upgrade.
       

       
      Build information:
      Accelerator server: 7.5.13.202411051451
      Appliance software: 1.0.27.10
      Db2 level: 11.5.9.0 [Build special 50023]
      		2024/12/20
      Stored procedures:
      (same level for 7.5.13 and 7.5.13.1) Read the release notes for the Stored Procedures. 
      Build label: 20240711-0604
      APAR PH61845, PTFs UI97750 and UI97751
       
      		2024/08/02

      7.5.12.2

      Before installing this maintenance level, read the 
      V7.5.12(.1,.2) 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.12.2.
      Container image for IBM Integrated Analytics System:

      7.5.12.2-Information_Management-IDAA-IIAS

       

      Please contact IBM support by opening a pro-active case to get further assistance for the installation/upgrade.
       

       
      Build information:
      Accelerator server: 7.5.12.202402232258
      Appliance software: 1.0.27.9
      Db2 level: 11.5.8.0 [Build special 39310]
      		2024/04/25
      Stored procedures:
      (same level for 7.5.12, 7.5.12.1, and 7.5.12.2) 
      db2z.7.5.12 20230921-0928
      APAR PH57138, PTFs UI93729 and UI93730
       
      		2023/12/21

      7.5.11.2

      The release notes of maintenance level 7.5.11 still apply; therefore read the V7.5.11 Release Notes before installing this maintenance level.

      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.11.2.
      Container image for IBM Integrated Analytics System:

      7.5.11.2-Information_Management-IDAA-IIAS

       

      Please contact IBM support by opening a pro-active case to get further assistance for the installation/upgrade.

       

       
      Build information:
      Accelerator server: 7.5.11.202308151748
      Appliance software: 1.0.27.7
      Db2 level: 11.5.8.0 [Build special 31211]
      		2023/08/23
      Stored procedures:
      (same level for 7.5.11, 7.5.11.1, and 7.5.11.2) 
      db2z.7.5.11 20230302-1422
      APAR PH53602, PTFs UI91200 and UI91201
       
      		2023/04/03

      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. 

       

      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:
      7.5.7.202201311131
      		2022/03/10
      Stored procedures:


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

     

    • 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      		ComponentRelease date
      YYYY/MM/DD
      7.5.14.2a (recommended)

      The release notes of maintenance level 7.5.14 do also apply to 7.5.14.2a; therefore read the

      V7.5.14(.1,.2) Release Notes.
      Container image for IBM Z:

      7.5.14.2a-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.
      Build information:
      Accelerator server: 7.5.14.202507281310
      Appliance software: 7.5.14.2.20260202-1712
      Appliance container infrastructure: 1.1.8 
      Db2 level: 11.5.9.0 [Build special 67235]
      		2026/07/07
      Stored procedures:
      (Same level for 7.5.14, 7.5.14.1, and 7.5.14.2)
      Read the release notes for the Stored Procedures. 
      Build label: 20250411-0841
      APAR PH66192, PTFs UO03065 and UO03067
       
      		2025/05/24
      7.5.14.2

      The release notes of maintenance level 7.5.14 do also apply to 7.5.14.2; therefore read the

      V7.5.14(.1,.2) Release Notes.
      The container image 7.5.14.2 for IBM Z (release date 2026/02/19) has been withdrawn from Fix Central. With respect to product currency, we strongly recommend to upgrade to accelerator maintenance level 7.5.14.2a. 
      Build information:
      Accelerator server: 7.5.14.202507281310
      Appliance software: 7.5.14.2.20260202-1712
      Appliance container infrastructure: 1.1.5
      Db2 level: 11.5.9.0 [Build special 67235]
      		2026/02/19
      Stored procedures:
      (Same level for 7.5.14, 7.5.14.1, and 7.5.14.2)
      Read the release notes for the Stored Procedures. 
      Build label: 20250411-0841
      APAR PH66192, PTFs UO03065 and UO03067
       
      		2025/05/24
      7.5.13.1

      Before installing this maintenance level, read the

      V7.5.13(.1) Release Notes.
      Container image for IBM Z:

      7.5.13.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.
      Build information:
      Accelerator server: 7.5.13.202411051451
      Appliance software: 7.5.13.1.20241202-0203
      Db2 level: 11.5.9.0 [Build special 50023]
      		2024/12/20
      Stored procedures:
      (same level for 7.5.13 and 7.5.13.1) Read the release notes for the Stored Procedures. 
      Build label: 20240711-0604
      APAR PH61845, PTFs UI97750 and UI97752
       
      		2024/08/02
      7.5.12.3

      Before installing this maintenance level, read the

      V7.5.12(.1, .2, .3) Release Notes.
      Container image for IBM Z:

      7.5.12.3-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.
      Build information:
      Accelerator server: 7.5.12.202405161659
      Appliance software: 7.5.12.20240625-0035
      Db2 level: 11.5.8.0 [Build special 39310] - same as in 7.5.12.2
      		2024/07/04
      Stored procedures:
      (same level for all 7.5.12.x maintenance levels) 
      db2z.7.5.12 20230921-0928
      APAR PH57138, PTFs UI93729 and UI93731
       
      		2023/12/21
      7.5.11.2

      The release notes of maintenance level 7.5.11 still apply; therefore read the V7.5.11 Release Notes. before installing this maintenance level.
      Container image for IBM Z:

      7.5.11.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.
       
      Build information:
      Accelerator server: 7.5.11.202308151748
      Appliance software: 7.5.11.2.20230816-0548
      Db2 level: 11.5.8.0 [Build special 31211]
      		2023/08/23
      Stored procedures:
      (same level for 7.5.11, 7.5.11.1, and 7.5.11.2) 
      db2z.7.5.11 20230302-1422
      APAR PH53602, PTFs UI91200 and UI91202
       
      		2023/04/03

  • 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 
        1IBM 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
        1Workstation (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

        One of the following IBM servers is required:

        IBM Z serverIBM LinuxONE™ serverMachine Type
        Models: ME1
        (requires Accelerator maintenance level 7.5.14.1 (7.5.14) or later)
        Models: ML1
        (requires Accelerator maintenance level 7.5.14.1 (7.5.14) or later)
        		9175
        Models: A01, A02
        (requires Accelerator maintenance level 7.5.8 or later)
        Models: LA1, LA2
        (requires Accelerator maintenance level 7.5.8 or later)
        		3931, 3932
        Models: T01, T02
        Models: LT1, LT2
        		8561, 8562
        Models: M01, M02, M03, M04, M05
        Models: LM1, LM2, LM3, LM4, LM5
        		3906
        Model: ZR1
        Model: LR1
        		3907
        Models: N30, N63, N96, NC9 and NE1
        Models: L30, L63, L96, LC9 and LE1
        		2964
        Models: N10, N20
        IBM LinuxONE™ Rockhopper
        Models: L10, L20
        		2965


         

        A workstation (Intel® or compatible) is required to administer the
        • Installation and setup of the Accelerator on IBM Z. A Web browser (Firefox or Chrome) with network access to the LPAR(s) is required.
        • Accelerator (tables, queries, loads, replication). This workstation must be connected to the LPAR hosting Db2 for z/OS. For the hardware and software requirements of this workstation, see the system requirements for software used for the administration:
         
        For a single-node installation one accelerator is represented by one SSC-LPAR, for a multi-node installation by a cluster of SSC-LPARs. Each LPAR requires IFLs, RAM, and Storage.
        ComponentsMinimum 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

        FCP-attached or FICON-attached storage is required:

        • FCP-attached storage devices
          • A connection to a Fibre Channel SAN using a switched fabric is required.
          • The N Port Identifier Virtualization (NPIV) must be enabled in the Secure Service Container partition through the Support Element. For details see the Secure Service Container User's Guide, pages 6/7.
          • The use of all-flash storage is strongly recommended.

        • FICON-attached storage devices

           

          • A connection to a Fibre Channel SAN using a switched fabric is supported.
        • The amount of storage needed is depending on the workload. During setup the storage provided is distributed on various storage pools. For more information see the table 'Recommended pools and pool sizes' in chapter Installing Db2 Analytics Accelerator on Z of the Installation Guide.
        • Fully-provisioned storage volumes are supported. Thin-provisioned volumes are only tolerated, installation process will format them completely. This applies to volumes used for the boot disk, the data pool, the runtime pool, and transient pool. For more information see APAR PH39057.

      • Microcode Change Level (MCL)

        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.

        • Mandatory MCL

          • Mandatory MCL for IBM Z17™ & IBM LinuxONE™ 5 (all models) - Oct 3, 2025

            The following MCL or later is mandatory for use of the Accelerator on IBM Z17™ or on IBM LinuxONE™ 5 (all models):

            • Driver D61C Bundle S15

          • Mandatory MCL for IBM Z16™ & IBM LinuxONE™ 4 (all models)

            The following MCL or later is mandatory for use of the Accelerator on IBM Z16™ or on IBM LinuxONE™ 4 (all models):

            • Driver D51C Bundle S18 (2023-04-027)

          • Mandatory MCL for IBM Z15™ (IBM LinuxONE™ III), IBM Z14™ (IBM LinuxONE™ II)

            The following MCLs or later are mandatory with accelerator maintenance level 7.5.6(.1) or later for older hardware than IBM Z16™ or IBM LinuxONE™ 4 (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

            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.

        • Recommended MCL

          • Recommended MCL for IBM Z16™ & IBM LinuxONE™ 4 (all models)

            It is recommended to upgrade the MCL to bundle S32 or later. (July 4th, 2024)

          • Recommended MCL for IBM Z15™ & IBM LinuxONE™ III (all models)

            It is recommended to upgrade the MCL to bundle S92 or later. (Feb 7 4th, 2024)

     

  • 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 
        1OSA-ExpressxS card, x= 3,4,5,6,7IBM System z
        110GbE SFP + Switch
        Lenovo RackSwitch G8264
        Lenovo RackSwitch G8124E        		Network
        2Optical fiber cablesNetwork
        3IBM/BNT® 10Gb SFP + Optical TransceiverSwitch
        11 GbE RJ45 Switch
        Lenovo RackSwitch G7028        		Network
        2RJ45 cableNetwork

      • 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 
        2OSA-ExpressxS card, x= 3,4,5,6,7IBM System z
        6Optical fiber cablesNetwork
        210GbE SFP + Switch
        Lenovo RackSwitch G8264
        Lenovo RackSwitch G8124E        		Network
        6IBM/BNT® 10Gb SFP + Optical TransceiverSwitch
        21 GbE RJ45 Switch
        Lenovo RackSwitch G7028        		Network
        4RJ45 cableNetwork

      • 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

      Note:
      The following applies unless limited by other product documentation. 

      • General Requirements

        Management Network
        For appliance installation and management, a management network is required.
        Detailed requirements:

        • For the supported network interfaces, see the table below.
        • A Web browser (Firefox or Chrome) with network access to the LPAR(s).
        • If the OSA interface is used, one OSA Express card (1 GbE is sufficient) as network adapter for this management network.
          • Port 0 of the OSA Express card must be used and
          • The OSA adapter must be configured in QDIO mode (CHPID OSX or OSD).
        • 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.


        We recommend to separate the management network from the dedicated Data Network (aka Db2 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. 
        Data Network
        For query acceleration on IBM Z, a TCP/IP network connection is required between the affected Db2 for z/OS subsystems and the Accelerator. This connection is referred to as “Data Network” or as "Db2 Network". 
        Cluster Network (multi-node only)
        See below for the section "Requirements for inter-node communication in multi-node installations". It describes why the RoCE communication must be used for the inter-node communication between accelerator SSC-LPARs. 
         

        Supported Accelerator Network Interfaces
        The following table provides an overview of the supported interfaces for the networks required:

        IBM Z ServerManagement NetworkData NetworkCluster Network
        IBM z17™Network Express interface
        or 
        OSA Express interface        		Network Express interface
        or 
        OSA Express interface
        or 
        HiperSockets (*1)        		Network Express interface
         
        IBM LinuxONE™ Emperor VNetwork Express interface
        or 
        OSA Express interface        		Network Express interface
        or 
        OSA Express interface        		Network Express interface
         
        IBM z16™
        IBM z15™
        IBM z14™        		OSA Express interfaceRoCE Express interface
        or 
        OSA Express interface
        or 
        HiperSockets (*1)        		RoCE Express interface
        IBM LinuxONE™ Emperor IV
        IBM LinuxONE™ Emperor III
        IBM LinuxONE™ Emperor II
                 		OSA Express interfaceRoCE Express interface
        or 
        OSA Express interface        		RoCE Express interface

        Note:

        • The recommended Network types in the table above have been emphasized in bold.
        • For Network Express interfaces, RocE interfaces, and OSA interfaces, 10GB or 25GB adapters are supported.
        • For Configuration of Network Express adapters, see the following manuals:
        • For the accelerator LPARs (meaning SSC LPARs),
          • it is mandatory to configure the Network Express adapters in Hybrid mode (CPHID type = NETH).
          • Network Express adapters configured as OSH/EQDIO are not supported.
        • For a z/OS LPAR (suchas a Db2 LPAR),
          • it is mandatory to configure the Network Express adapters with CPHID type = OSH.
        • Classic OSA cards carried forward to an IBM z17™ or an IBM LinuxONE™ Emperor 5 system, must be configured with CHPID=OSD.
        • (*1) Hipersockets can be used for the Data network, if the Db2 subsystem runs in an LPAR on the same CEC as the accelerator.
        • Running the Accelerator on IBM z17™ requires maintenance level 7.5.14.1 or later and MCL Driver D61C Bundle S15 or later.


        OSA Express
        Z/OS administrators (system programmers) who are responsible for deploying / configuring OSA or the communication with Linux on IBM Z environments, should read the IBM z/OS Communications Server and OSA-Express Best Practices white paper. 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: 
        When using an OSA Express 7s or 6s card in shared mode, the installation of D41C Bundle s80a (z15) or D51C Bundle s22a (z16) could lead to connectivity problems between Db2 for z/OS LPAR and the accelerator LPAR residing on the same mainframe server.
        Shared mode means that the network traffic does not go to a switch.
        Recommendation:
        If you are running a layer 2 host to a layer 3 host and using a shared OSA adapter with the OSA doing the internal routing between the LPARs, we recommend customer to update to Bundle S84a or Bundle S27 accordingly. 
        There won't be a connectivity problem if the OSA card is shared but the internal path is not used, meaning: the network traffic is routed by an external switch.
        Firewall
        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.

       

      • Requirements for inter-node communication in multi-node installations

        Why RoCE-communication must be used in multi-node installations of IBM Db2 Analytics Accelerator 
        The RoCE-communication will be possible when using the

        • Network Express interface on IBM z17 or on IBM LinuxONE Emperor 5 (configured in Hybrid mode with CHPID type=NETH).

          (requires Accelerator maintenance level 7.5.14.1 or later and MCL Driver D61C Bundle S15 or later.) 
        • PCI adapter with a RoCE card on IBM z16, z15, z14 or IBM Linux ONE Emperor 4, III, or II.

        Very high workload in multi-node installations of Db2 Analytics Accelerator on IBM zSystems can lead to inefficient query processing, resource contention, and potential system instability. Using RoCE-communication will reduce IFL resource contention, ensure predictable query runtimes, and enhance operational stability. 
        Therefore, the RoCE-communication must be used for the inter-node communication between accelerator SSC-LPARs. 
        IBM Z servers prior to the z17 generation:
        For inter-node communication, it is recommended to bond two 25 GbE RoCE cards. The primary purpose of bonding is to deliver a performance increase to 50 Gb. A second purpose is to provide high availability. Click here for information how to configure the cluster network of an accelerator multi-node installation for the use of RoCE-communication.

       

     

  • Software requirements

    • Operating Systems

      Operating system Required z/OS base elements 
      z/OS V3R2
      z/OS V3R1

      z/OS V2R5
      z/OS V2R4 (*)
      z/OS V2R3 (*)
      z/OS V2R2 (*)      		z/OS OpenSSH 
      (z/OS V3R1 requires fix for APAR OA65611; see APAR PH57280 for detailed information)
      Data Facility System Managed Storage Base (DFSMSdfp)
      Communications Server IP

      (*) Service has ended!
      To avoid performance degradation during load operations we strongly recommend to install the PTF for APAR OA61558 when running z/OS V2R3, z/OS V2R4, or z/OS V2R5. 

    • 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.15698-DUT
      DB2 12 for z/OS5650-DB2 (MLC)
      or
      5770-AF3 (Value Unit Edition)
      DB2 Utilities Suite for z/OS version 12.15770-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.15655-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.1413.64.111
      IBM Data Server Driver for JDBC and SQLJ (db2jcc4.jar)4.13.1454.14.119
      IBM Data Server Driver for JDBC and SQLJ V10.1 Fix Pack 2IP23387-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 without 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 numberDb2 APAR numberMandatory since accelerator maintenance levelComments
          UI80810
          UI91652          		PH45854 PH537007.5.8only 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 numberDb2 APAR numberMandatory since accelerator maintenance levelComments
          UI54293PI916207.1.3 
          UI57923PI962587.1.3 
          UI60263PH009337.1.5only required when using local date format
          UI63996PH00574
          PH10672
          PH13109          		7.1.5required when using monitoring of HTAP queries
          UI63356
          UI69536
          UI71876
          UI75930
          UI77365
          UI80519
          UI91651
                     		PH06628
          PH23895
          PH28849
          PH37808
          PH40261
          PH45962
          PH53700
                     		7.5.0only 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 numberDb2 APAR numberMandatory since accelerator maintenance levelComments
          UI51280PI83286
          PI83288          		7.1.4only required when using the HTAP feature
          UI57924PI962587.1.3 
          UI60265PH009337.1.5only required when using local date format
          UI63997PH00574
          PH10672
          PH13109          		7.1.5only 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.

         

    • 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.
      Note:
      Please see the technote 'How to migrate DASD devices of Db2 Analytics Accelerator for z/OS defined for GDPS failover support'.
      The support of GDPS requires the use of the Processor Resource/Systems Manager (PR/SM) mode (rather than using the Dynamic Partition Manager (DPM) mode). 

  • 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 13 for z/OS or Db2 12 for z/OS with PTFs UI80519, 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 for Db2 12
      • Accelerator maintenance level 7.5.8 or later for Db2 13 for z/OS

    • Incremental update (using IBM InfoSphere Data Replication for z/OS)

      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. 
      Note:
      With Accelerator maintenance level 7.5.13, the incremental update function using IIDR/CDC requires customization of the the z/OS component Integrated Cryptographic Service Facility (ICSF) for an AES-256 encryption.

  • Administering the accelerator

    IBM DB2 Analytics Accelerator Studio and IBM Administration Services provide a graphical administration interface for the product.

  • 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.
     

    Note:
    The PTF for Loader-APAR PH46656 or later maintenance levels of the Loader require the installation of the PTF for Db2 for z/OS-APAR PH45948. For further details see here. 

  • 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

    7 July 2026:

    • Availability of 7.5.14.2a for IBM Z
    • News-section: DB2 13 for z/OS - activation of M509 requires PTF for PH72047
    • News-section: upgrade to 7.5.14.x from before 7.5.9 on IBM Z requires contact of support

    7 April 2026:

    • Add RoCE Express Interface as supported interface for the Data Network (IBM z16/15/15 and LinuxONE IV,III,II)

    6 April 2026:

    • Indicate that MCL Driver 51C Bundle S53 (S54) will become mandatory for z16 customers after 7.5.14.2
    • Add latest Admin Services package level 20260305-0319-IDAA-Admin-Services and corresponding Admin Foundation PTF (UMS PTF not yet available).

    31 March 2026:

    • Mention two helpful manuals for configuration of Network Express adapters

    30 March 2026:

    • Rework section for "Network requirements for acceleration on IBM Z"
    • Delete section for maintenance level 7.5.14.1 in "Maintenance level - Accelerator on IBM Z"
    • General news section: mention MCL bundle S53 (S54)

    22 February 2026:

    • Availability of Accelerator maintenance level 7.5.14.2 for IBM Z.
    • Hot news for customers running the Accelerator on IBM Z16 / LinuxONE Emperor 4 using NMVEs or RoCE-cards: upgrade to 7.5.14.2.
    • Migration to V8.1: remove the option to directly migrate from a mnt lvl earlier than 7.5.14 with manual intervention of IBM support.
    • Announcement: The 7.5.14.1 maintenance packages IBM Z will be removed shortly.
    • Remove table entries for maintenance level 7.5.14 for both IBM Z and IIAS.
    • Add latest Admin Services package level 20251201-0145-IDAA-Admin-Services and corresponding Admin Foundation & UMS PTFs.

    20 November 2025:

    • Availability of Accelerator maintenance level 7.5.14.1 for IIAS.
    • Info for customers running the Accelerator on IIAS: upgrading to 7.5.14(.1) is a mandatory for upgrades to any later maintenance level.
    • Announcement: The 7.5.14 maintenance packages for both IBM Z and IIAS will be removed shortly.
    • Remove table entries for maintenance level 7.5.13. The corresponding package had been removed from Fix Central back in May 2025.

    10 November 2025:

    • Re-activate news paragraph concerning "Migrating the Accelerator from IIAS to IBM Z".
    • Add latest Admin Services package level 20251009-0836-IDAA-Admin-Services and corresponding Admin Foundation & UMS PTFs.
    • Clarify support of think-provisioned volumes.

    7 October 2025:

    • Correction: mandatory need for MCL Bundle T15 replaced with S15 (running the Accelerator on IBM z17 or IBM Linux One Emperor 5).
    • Availability of Accelerator maintenance level 7.5.14.1 for IBM Z.
    • Emphasize need for 7.5.14.1 for running z17 / LinuxONE 5 - 7.5.14 in brackets.
    • Mention support of z/OS 3.2.
    • Section "Software Requirements" -> Subsection "Operating Systems" was missing after DURPAL editor change

    3 October 2025:

    • MCL Driver D61C Bundle T15 is mandatory to run the Accelerator on IBM z17 or IBM Linux One Emperor 5.
    • Mention upcoming availability of Accelerator maintenance level 7.5.14.1 for IBM Z.
    • Section for maintenance level 7.5.10, 7.5.11, and 7.5.11.1 on IIAS removed.
    • Section for maintenance level 7.5.10.3 on IBM Z removed.

    12 September 2025:

    • Reword the clause describing the mandatory configuration of the Network Express interface using CPHID type=NETH.

    11 September 2025:

    • Clarify mandatory use of CHPID=NETH for use of Network Express interfaces on IBM z17 and IBM Linux One Emperor 5; OSH-mode is not supported.

    10 September 2025:

    • Housekeeping of the News section.
    • Emphasize need for maintenance level 7.5.14 in the Network section when using IBM z17 or IBM LinuxONE Emperor 5 hardware.

    26 August 2025:

    • Network requirements - Acceleration on IBM Z -> General requirements: mention support of OSA cards for LinuxOne Emperor 5 hardware.
    • Add PTF number UO04520 for UMS APAR PH67589.

    25 August 2025:

    • Mention the need for Accelerator maintenance level 7.5.14 when using IBM z17 or IBM LinuxOne Emperor 5 hardware.
    • Amend the table of refresh packs for Administration Services with a column showing the corresponding Admin Foundation PTF.
    • Improve the section about Data Studio and the Accelerator plugin with information concerning APAR4 and cumulative nature of APAR packages.

    3 August 2025:

    • Availability of Accelerator maintenance level 7.5.14 on IIAS.
    • Add table of administration-related APARs to section for Admin Services.

    25 July 2025:

    • Add Hipersockets to the list of Network interfaces available for IBM Z17 HW.

    21 July 2025:

    • Rework section for Network requirements on IBM Z: point to specific needs of IBM z17 and LinuxONE 5 - sync section with V8.1 prereq web page.
    • Amend section for Admin Services package level with latest UMS PTF UO03795.
    • Remove hint to APAR PH55922 and temporary change of the installation procedure.
    • Mention there is no specific Accelerator Studio plugin package for Accelerator maintenance level 7.5.14.
    • New section "Migrating to Accelerator V8.1 on IBM Z.
    • Mention z/OS 3.2 preview in the section "Software requirements".
    • Repair broken link pointing to helpful document for install/setup of Admin Foundation.

    26 June 2025:

    • Information concerning renewed package on Fix Central for Accelerator maintenance level 7.5.14 on IBM Z
    • Add latest Admin Services package level

    4 June 2025:

    • Correct accelerator server build timestamp shown for Accelerator maintenance level 7.5.14 on IBM Z
    • Add Db2wh build level for Accelerator maintenance level 7.5.14 on IBM Z
    • Indicate which maintenance packages were withdrawn from Fix Central on May 14/15, 2025

    30 May 2025:

    • Availability of Accelerator maintenance level 7.5.14 on IBM Z
    • Network requirements for acceleration on IBM Z: mention support of RoCE cards 10Gb and 25Gb

    2 May 2025:

    • Heads-up for upcoming new maintenance level 7.5.14
    • Housekeeping in the News-section
    • Mention need for PTF UI99021 when using Admin Foundation to transfer accelerator upgrade packages to IIAS
    • Maintenance levels: remove references to packages that are no longer available on Fix Central
    • Maintenance levels: indicate upcoming removal of those packages from Fix Central that have been succeeded for at least nine months
    • Add link to new Admin Services package "20250410-0245-IDAA-Admin-Services"

    7 February 2025:

    • Mention new technote "How Db2 Analytics Accelerator for z/OS on IBM Z uses the configured storage"
    • Recommended MCL level changed for Z15: from to S85 to S92 - RoCE-card FIDs fixed when running POR on machine with DPM.
    • Remove note to APAR PH63560 from news section of Accelerator on IBM Z-customers - fixed with 7.5.13.1

    20 December 2024:

    • Availability of maintenance level 7.5.13.1
    • IIDR/CDC - do not install PTF UI95176; wait for PTF UI99115 (APAR PH64113)

    20 November 2024:

    • Incremental update using IIDR/CDC and Accelerator maintenance level 7.5.13: ICFS and AES-256

    22 October 2024:

    • New subsection concerning remote maintenance in section "Support - how can we help you".
    • EOS for Data Studio: mention support of Accelerator plugin and missing support of Db2 13.
    • Mention availability of MCL bundle S91

    4 October 2024:

    • Mention APAR PH63560 in the news section of Accelerator on IBM Z-customers

    3 October 2024:

    • Add link to Analytics Accelerator Studio plugin for maintenance level 7.5.13.
    • Accelerator on IIAS news: Admin Foundation currently does not support transfer of an upgrade package to the accelerator.

    11 September 2024:

    • Remove paragraph about "feature code (FC) 0103 Linux Hosting Foundation or 0104 Container Hosting Foundation" in the "Computer" section for Accelerator on IBM Z
    • Remove APAR PH55926 and link to technote concerning battery expiration from News section

    10 September 2024:

    • Replace erroneous APAR number PH57820 with PH57280.
    • Mention APAR PH63178 in the "General news" section.

    4 September 2024:

    • Mention Data Studio buttons to be used in the description of the transfer methods for installation on IIAS

    28 August 2024:

    • Correct build label for Stored Procedures fitting to maintenance level 7.5.13
    • Mention need to open a support case when migrating from IIAS to IBM Z

    19 August 2024:

    • Mentioning the possibility to use the customer's remote screen sharing software
    • Adding link to Administration Services package for 7.5.13
    • Adding section about products related to Administration Foundation

    8 August 2024:

    • Availability of maintenance level 7.5.13 (Aug 7, 2024)

    24 July 2024:

    • Mention APAR PH62206 in the News section for Accelerator on IBM Z.
    • Administration Foundation: link to new document "Installing and configuring IBM Db2 Administration Foundation for z/OS by example" added.

    4 July 2024:

    • Availability of maintenance level 7.5.12.3 for Accelerator on IBM Z
    • Mention switch from Cisco Webex™ to Microsoft Teams™ for remote maintenance sessions.
    • Mention APARs PH62082 and PH62138 in the News section for Accelerator on IBM Z.
    • Recommended MCL levels changed: for Z15 to S85 and for Z16 to S32.
    • FixCentral link to package for maintenance level 7.5.12.2 on IBM Z removed.

    30 April 2024:

    • Add link to new technote "How to migrate DASD devices of Db2 Analytics Accelerator for z/OS defined for GDPS failover support"

    25 April 2024:

    • Availability of maintenance level 7.5.12.2
    • Add links to EOS announcement for DSM and Data Studio
    • Add APAR PH53700 to list of Db2 for z/OS maintenance recommended for InSync

    21 April 2024:

    • Housekeeping: reduce list of available maintenance levels

    4 April 2024:

    • Change all links to web pages to get them opened in a new browser window
    • Add UMS maintenance info related to Admin Services packages

    29 March 2024:

    • Correct link for Accelerator Studio plugin applying to 7.5.12(.1)
    • Add link to Admin Services package applying to 7.5.12(.1)

    27 March 2024:

    • Replace links to Program Directory and Installation Guide
    • Add links to documentation for Zowe, UMS, and Db2 Administration Foundation

    25 March 2024:

    • Add links to technote 'Configuring and using transient storage for IBM Db2 Analytics Accelerator'.
    • Section for required hardware for Accelerator on IBM Z reworked
    • Hide section for Data Server Manager
    • Update section for IBM Administration Services

    26 February 2024:

    • Availability of accelerator plugin 7.5.12
    • Mention APAR PH59232 in the news section

    21 February 2024:

    • Availability of maintenance level 7.5.12.1

    16 February 2024:

    • Mention upcoming new mnt lvl 7.5.12.1 and point to APAR PH59820
    • Deactivate links to download packages for 7.5.12

    26 January 2024:

    • Renew link to Installation Guide (pointing to latest maintenance level 7.5.12)
    • z/OS 3.1 - mention APAR PH57820
    • MCL: introduce new sections for mandatory and recommended MCL level
    • Remove technote "How to configure cluster network .. with RoCE cards" from News-section
    • Remove support of z/OS 3.1 from News-section
    • Add link to certificate renewal information to News-section
    • Set Bundle S18 as new minimum mandatory MCL for z16

    21 December 2023:

    • Availability of maintenance level 7.5.12
    • Remove maintenance level 7.5.7.1 from overview

    15 December 2023:

    • Provide information for MCL patch solving the issue with shared OSA cards.
    • Mention need of the fix for APAR OA65611 when using z/OS V3R1.

    8 December 2023:

    • Alert message for users of OSA-Express 7s or 6s cards in shared mode.
    • Add link to 'IBM z/OS Communications Server and OSA-Express Best Practices' white paper.

    29 September 2023:

    • Support of z/OS 3.1

    27 September 2023:

    • Insert links to new technote "How to configure the cluster network of an accelerator multi-node installation for the use of RoCE Express cards".

    4 September 2023:

    • Clarify maintenance level of IBM DB2 Analytics Accelerator Studio for Accelerator maintenance levels 7.5.11, 7.5.11.1, and 7.5.11.2.

    23 August 2023:

    • Availability of maintenance level 7.5.11.2
    • Adaptations of the list of mandatory PTFs required for Integrated Synchronization; add PTF UI80519.

    28 July 2023:

    • Availability of maintenance level 7.5.11.1

    26 July 2023:

    • Accelerator on IBM Z: hint to APAR PH55922
    • Accelerator on IIAS: hint to APAR PH55926 and to battery expiration and end of life warnings

    18 June 2023:

    • Specify the need for an OSA card to establish the management network for Accelerator on Z
    • Remove maintenance level 7.5.5.x and 7.5.6.x from the overview of available packages

    15 June 2023:

    • Add helpful links to paragraph "Upgrading the maintenance level - Accelerator on IBM Z"

    14 June 2023:

    • Update of links to Installation Guide
    • Erroneous reference to release notes of 7.5.10 replaced with 7.5.11

    7 June 2023:

    • Availability of maintenance level 7.5.11

    27 April 2023:

    • Section "Installation & Update recommendations" extended and renamed to "Support"
    • Section "Upgrading the maintenance level" restructured
    • Recommendations added for upgrading maintenance level for Accelerator on Z
    • Section "Documentation, Technotes" moved to the top of the page; now a subsection of "Support"
    • Accelerator APAR section moved from section "Maintenance level" to new section "Support"
    • Recommendation for MCL bundle S18 on IBM Z16™ or LinuxONE™

    6 April 2023:

    • Create new sections "Storage" and "Mandatory Microcode Change levels"

    31 March 2023:

    • Accelerator on Z: availability of maintenance level 7.5.10.3

    29 March 2023:

    • Requirement of NPIV mode set to 'On' for FCP-attached storage

    17 March 2023:

    • Accelerator on Z: availability of maintenance level 7.5.10.2
    • Accelerator on Z: correcting build information details for maintenance level 7.5.9.2
    • Callhome: adding information concerning changing IP addresses for IBM servers
    • Add information concerning PR/SM when using GDPS on LinuxOne

    3 March 2023:

    • Adjusting information concerning benefits of RoCE-cards in multi-node installations
    • Adding link to information how to upload data to the ECuRep repository

    21 February 2023:

    • Accelerator on Z: availability of maintenance level 7.5.10.1
    • IBM Data Studio: add link to the APAR2-patch and link to the list of APARs fixed

    16 February 2023:

    • Network requirements for Acceleration on IBM Z -> requirements for inter-node communication in multi-node installations

    20 December 2022:

    • Accelerator on Z: availability of maintenance level 7.5.9.2
    • Db2 Analytics Accelerator Studio: availability of / link to maintenance level 7.5.10
    • Adaptation of links pointing to the Installation Guide

    12 December 2022:

    • Availability of 7.5.10
    • FCP or FICON attached storage: document need for a connection to a Fibre Channel SAN using a switched fabric connection

    10 November 2022:

    • Section "Installation & Upgrade recommendations": remove subsection concerning MCL requirement for maintenance level 7.5.6.1 or later
    • Accelerator on Z: mandatory MCL level raised to bundle S12
    • Accelerator on IIAS: remove entries for maintenance level 7.5.3
    • Accelerator on Z: remove entries for maintenance levels 7.5.3 and 7.5.9

    1 November 2022:

    • Accelerator on IIAS: availability of maintenance level 7.5.9.1 on IIAS

    24 October 2022:

    • Section 'Documentation, Technotes': introduce new subsection 'Links to other useful documentation', here 'Monitoring the accelerator using OMPE'

    10 October 2022:

    • Chapter 'Technotes': insert links to new technotes 'Table Statistics and IBM Db2 Analytics Accelerator for z/OS' and 'Query Performance Diagnosis and IBM Db2 Analytics Accelerator for z/OS'
    • Accelerator on Z: HW requirements -> MCL level for IBM Z16 and IBM LinuxONE 4

    29 September 2022:

    • Accelerator on Z: availability of maintenance level 7.5.9.1

    16 September 2022:

    • Accelerator on Z: add IBM LinuxONE Emperor 4 as supported HW model; correct links to HW announcement letters
    • Documentation -> Accelerator on Z -> add link to manual 'Linux on IBM Z and LinuxONE: Networking with RoCE Express'

    14 September 2022:

    • Correct APAR number for Db2 13: PI45854 -> PH45854

    13 September 2022:

    • Mention Loader APAR PH46656 and the parallel need for installing the PTF belonging to Db2 APAR PH45948

    25 August 2022:

    • Adapt link to list of Loader PTFs

    22 August 2022:

    • Adapt links to Accelerator manuals; point to 7.5.9 editions
    • Chapter 'Database Management Software': insert link to documentation center of Db2 13
    • Chapter 'Technotes': insert link to new technote 'How to store optimization profile definitions in a Db2 for z/OS table'

    9 August 2022:

    • Availability of Analytics Accelerator Studio for 7.5.9

    6 August 2022:

    • Availability of 7.5.9

    6 July 2022:

    • DB2 Analytics Accelerator Studio 7.5.8 - edition 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 deployment 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

[{"Type":"MASTER","Line of Business":{"code":"LOB70","label":"Z TPS"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS4LQ8","label":"Db2 Analytics Accelerator for z\/OS"},"ARM Category":[{"code":"a8m0z0000000775AAA","label":"Db2 related products and functions-\u003EDb2 Analytics Accelerator for z\/OS"},{"code":"a8m0z000000072oAAA","label":"Install and Migrate"},{"code":"a8m0z000000073XAAQ","label":"Troubleshooting"}],"ARM Case Number":"","Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"7.5.0"}]

Document Information

Modified date:
22 July 2026

UID

swg27050440

Page Feedback