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
      • The new Accelerator maintenance level 7.5.13.1 has been made available (Dec 20, 2024).
      • Please find information about new functions here.
      • Incremental update using IIDR/CDC - do not install PTF UI95176; wait for the availability of PTF UI99115 (APAR PH64113). (Dec 20, 2024)
      • Incremental update using IIDR/CDC and Accelerator maintenance level 7.5.13 or later (Nov 20, 2024)
        The IIDR/CDC-based replication component of Db2 Analytics Accelerator for z/OS uses a jdbc driver-based connection to Db2 for z/OS to write processing information into CDC-owned tables in Db2 for z/OS. With Accelerator maintenance level 7.5.13, a new jdbc-driver (4.33.32) is used. This new driver requires an AES-256 encryption for the communication mentioned before. To utilize an AES-256 encryption, the z/OS component Integrated Cryptographic Service Facility (ICSF) needs to be set up accordingly. Without the customization of ICSF for AES-256, the communication with Db2 for z/OS and the writing of data to CDC will not work and cause the replication to fail.
        In case this customization of ICSF for use of AES-256 encryption would absolutely not be an option, please contact IBM support for an alternate solution path.
      • End of Service (EOS) for IBM Data Server Manager for Db2 for z/OS and IBM Data Studio for Db2 for z/OS. (Oct 22, 2024)
        The EOS for Data Server Manager and Data Studio have been announced back in spring 2024.
        What you need to know:
        • The Db2 Analytics Accelerator plugin for Data Studio is maintained along with Accelerator V7.5
        • IBM Data Studio and IBM Data Server Manager are not supported for use with Db2 13 for z/OS.
        • For the future administration of your Accelerator(s), make sure to plan for a timely transition towards use of Db2 Administration Foundation in combination with Db2 Administration Services.
      • Customers using maintenance level 7.5.12.1 or later: please read APAR PH63178. (Sep 10, 2024)
      • Migrating the Accelerator from IIAS to IBM Z (August 28, 2024)

        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
      • Customers of IBM z15 systems with ESE boot volumes affected by APAR PH63191: MCL Driver 41 Bundle S91 has been released. (Oct 22, 2024)
      • Customers using ESE volumes on DS8K storage units: please read APAR PH63560. (Oct 4, 2024)
        Customers running 7.5.12.x: please read APAR PH62206. (July 24, 2024)
        Customers using NVMEs: please read APAR PH62082. (July 4, 2024)
        Customers not using NVMEs: please read APAR PH62138. (July 4, 2024)
      • The technote 'How to migrate DASD devices of Db2 Analytics Accelerator for z/OS defined for GDPS failover support' has been enhanced significantly to reflect the improvements delivered with maintenance level 7.5.13. (Aug 19, 2024)
      • Temporary change of the installation procedure! - please see APAR PH55922 before upgrading. (July 26, 2023)
    • News concerning Accelerator on IBM IIAS
      Admin Foundation (in combination with Admin Services) currently does not support the transfer of upgrade packages to the accelerator. The root cause for this issue is located in the UMS software component. A fix has been coded. If you need a ++APAR, please open a corresponding support case. The availability of the corresponding PTF is planned for Nov 30, 2024. For the time being, use the Analytics Accelerator Studio for the transfer of the upgrade package to the accelerator.
  • 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       		Component Release date
      YYYY/MM/DD
      7.5.13.1 (recommended)

      Before installing this maintenance level, read:
      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 in Data Studio:
      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.13

      Before installing this maintenance level, read:
      V7.5.13 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.0-Information_Management-IDAA-IIAS

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

      Build information in Data Studio:
      Accelerator server: 7.5.13.202407100546
      Appliance software: 1.0.27.10
      Db2 level: 11.5.9.0 [Build special 42753]
      		 2024/08/07
      Stored procedures:
      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:
      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 in Data Studio:
      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.12.1
      The container image 7.5.12.1 for IBM Integrated Analytics System has been withdrawn from Fix Central on April 25, 2024. The successor image is 7.5.12.2.
      Build information in Data Studio:
      Accelerator server: 7.5.12.202402141440
      Appliance software: 1.0.27.9
      Db2 level: 11.5.8.0 [Build special 32821]
      		 2024/02/21
      Stored procedures:
      (same level for 7.5.12 and 7.5.12.1)
      db2z.7.5.12 20230921-0928
      APAR PH57138, PTFs UI93729 and UI93730
      		 2023/12/21
      7.5.12

      If you have installed this maintenance level, we strongly recommend to upgrade to 7.5.12.1 as soon as possible. See APAR PH59820 for more information.
      The container image 7.5.12 for IBM Integrated Analytics System has been withdrawn from Fix Central on Feb 14, 2024. The successor image is 7.5.12.2.
      Build information in Data Studio:
      Accelerator server: 7.5.12.202311241025
      Appliance software: 1.0.27.9
      Db2 level: 11.5.8.0 [Build special 32821]
      		 2023/12/21
      Stored procedures:

      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 in Data Studio:
      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.11.1

      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.1.
      Container image for IBM Integrated Analytics System:
      7.5.11.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 in Data Studio:
      Accelerator server: 7.5.11.202306271505
      Appliance software: 1.0.27.7
      Db2 level: 11.5.8.0 [Build special 31211]
      		 2023/07/28
      Stored procedures:
      (same level for 7.5.11 and 7.5.11.1)
      db2z.7.5.11 20230302-1422
      APAR PH53602, PTFs UI91200 and UI91201
      		 2023/04/03
      7.5.11

      Before installing this maintenance level, read:
      V7.5.11 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.11.
      Container image for IBM Integrated Analytics System:
      7.5.11.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.11.202304132257
      		 2023/06/07
      Stored procedures:


      db2z.7.5.11 20230302-1422
      APAR PH53602, PTFs UI91200 and UI91201
      		 2023/04/03
      7.5.10

      Before installing this maintenance level, read:
      V7.5.10 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.10.
      Container image for IBM Integrated Analytics System:
      7.5.10.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.10.202211101832
      		 2022/12/12
      Stored procedures:


      db2z.7.5.10 20220929-1324
      APAR PH51109, PTFs UI83471 and UI83472
      		 2022/12/02
      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 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
       
    • 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.13.1 (recommended)

      Before installing this maintenance level, read:

      V7.5.13(.1) Release Notes and APAR PH55922.
      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 in Data Studio:
      Accelerator server: 7.5.13.2024011051451
      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.13

      Before installing this maintenance level, read:

      V7.5.13 Release Notes and APAR PH55922.
      Container image for IBM Z:
      7.5.13.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.
      Build information in Data Studio:
      Accelerator server: 7.5.13.202407100546
      Appliance software: 7.5.13.0.20240805-0119
      Db2 level: 11.5.9.0 [Build special 42753]
      		 2024/08/07
      Stored procedures:
      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:

      V7.5.12(.1, .2, .3) Release Notes and APAR PH55922.
      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 in Data Studio:
      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.12.2
      Container image for IBM Z:
      The container image 7.5.12.2 for IBM Z has been withdrawn from Fix Central on July 3, 2024. The successor image is 7.5.12.3.
      Build information in Data Studio:
      Accelerator server: 7.5.12.202402232258
      Appliance software: 7.5.12.20240321-0327
      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 UI93731
      		 2023/12/21
      7.5.12.1
      The container image 7.5.12.1 for IBM Z has been withdrawn from Fix Central on April 25, 2024. The successor image is 7.5.12.3.
      Build information in Data Studio:
      Accelerator server: 7.5.12.202402141440
      Appliance software: 7.5.12.20231206-1448
      Db2 level: 11.5.8.0 [Build special 32821]
      		 2024/02/21
      Stored procedures:
      (same level for 7.5.12 and 7.5.12.1)
      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 and APAR PH55922 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 in Data Studio:
      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
      7.5.10.3

      The release notes of maintenance level 7.5.10 still apply; therefore read the
      V7.5.10 Release Notes and APAR PH55922 before installing this maintenance level.
      Container image for IBM Z:
      7.5.10.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 in Data Studio:
      Accelerator server: 7.5.10.202302181744
      Appliance software: 7.5.10.2.20230322-0702
      Db2 level: 11.5.7.0 [Build special 26818]
      		 2023/03/31
      Stored procedures: (same level for 7.5.10, 7.5.10.1, 7.5.10.2, and 7.5.10.3)

      db2z.7.5.10 20220929-1324
      APAR PH51109, PTFs UI83471 and UI83473
      		 2022/12/02
       
  • 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
        One of the following IBM servers is required:
        IBM Z server IBM LinuxONE™ server Machine Type
        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 admnistration:

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

        FCP-attached or FICON-attached storage is required:

        • FCP-attached storage devices
        • FICON-attached storage devices
          • The use of HyperPAV and zHPF is mandatory.
          • The use of all-flash storage is strongly recommended.
          • 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.
        • Only 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.
      • 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 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):

            • 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 hardware other 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 S85 or later. (July 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
        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
      • General Requirements

        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, IBM z15, or IBM z16
        or using
        • HiperSockets (if the Db2 subsystem runs in an LPAR on the same CEC).

        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:
        • OSA-Express7S 25 GbE cards are supported using maintenance level 7.5.2.2 or later
        • 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, the following is required:

        • A Web browser (Firefox or Chrome) with network access to the LPAR(s).
        • 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 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.  

        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.

        Note: 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.

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

        Why RoCE cards must be used in multi-node installations of IBM Db2 Analytics Accelerator

        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 cards will reduce IFL resource contention, ensure predictable query runtimes, and enhance operational stability.
        Therefore RoCE cards must be used for the inter-node communication between LPARs instead of HiperSockets.

        RoCE cards are supported with Accelerator maintenance level 7.5.10.1 or later.
        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 Express cards.

  • Software requirements
    • Operating Systems
      Operating systems
      Operating system Required z/OS base elements
      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
       

      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.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 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 number Db2 APAR number Mandatory since accelerator maintenance level Comments
          UI80810
          UI91652          		 PH45854 PH53700 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
          UI80519
          UI91651          		 PH06628
          PH23895
          PH28849
          PH37808
          PH40261
          PH45962
          PH53700          		 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.
      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.

  • Documentation, Technotes - section moved to the top of this web page
    This section has been moved to the top as entry in section "Support".
  • 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
    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":"LOB10","label":"Data and AI"},"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:
20 December 2024

UID

swg27050440

Page Feedback