IBM Support

Prerequisites and Maintenance for IBM DB2 Analytics Accelerator for z/OS, V5.1

Detailed System Requirements


Abstract

Hardware and software requirements for installing IBM® DB2® Analytics Accelerator for z/OS®, V5.1.0

Content

Removal of ISOdx package from Netezza machines
ISOdx is an obsolete diagnostic tool installed on Netezza that was used internally by IBM support. IBM removes this software from the Netezza machines by using one of the following methods:
  • Whenever a remote maintenance session is scheduled, IBM support runs a script to remove ISOdx.
  • When applying PTF UI67051 (APAR PH18395) the installation of the new maintenance level of the accelerator will be accompanied by an automatic removal of ISOdx.
Note:
This request is NOT related to any security vulnerabilities, known malfunctions, or software defects, but rather more specific to removing software no longer used for diagnostic purposes. Additionally, removal of this software reduces filesystem utilization from system-generated snapshots, which can contribute to directory /opt becoming exhausted.

What's new?

Find information about new functions here .

Preventive maintenance - defects you should know about

Information
published on
MM/YYYY
Maintenance level
affected by the defect
Details concerning the defect
 
Fix shipped
with the following
maintenance level
Recommended
maintenance level
08/2017 V5.1.0 PTF-5 Current timestamp discrepancy between DB2 and Accelerator UI49630
04/2017 V5.1.0 PTF-5
V5.1.0 PTF-4
Using IBM DB2 Analytics Accelerator Loader for z/OS (5639-OLE) can result in errors Loader-APAR PI78727 ,
UI46561
04/2017 V5.1.0 PTF-5
V5.1.0 PTF-4
V5.1.0 PTF-3
V5.1.0 PTF-2
V5.1.0 PTF-1a
V5.1.0 GA
V4.1 PTF-6
Duplicate Rows when using Continuous Incremental Updates and Partial Reload of Data on partitioned Tables.   CDC-APAR PI77397 , PTF UI45775
03/2017 V5.1.0 PTF-3
V5.1.0 PTF-2
V5.1.0 PTF-1a
V5.1.0 GA
V4.1 PTF-6
V4.1 PTF-5
Different number of rows in large result sets V5.1.0 PTF-4 V5.1.0 PTF-5
10/2016 V5.1.0 PTF-2
V5.1.0 PTF-1a
V5.1.0 GA
Data inconsistencies between accelerator-shadow tables and empty DB2 for z/OS tables V5.1.0 PTF-3 V5.1.0 PTF-5
04/2016 V5.1.0 PTF-1
V5.1.0 GA
Huge table sizes might lead to different query results V5.1.0 PTF-1a V5.1.0 PTF-5

Important other information

For open APARs you should know about read here.

To reduce possible spikes in offload activity, we strongly recommend applying the Db2 for z/OS PTFs for the APARs PH21726 and PH28050.



IBM DB2 Analytics Accelerator for z/OS - maintenance level

  • IBM DB2 Analytics Accelerator for z/OS 5.1.0 PTF-9 Update 1 (recommended)
    IBM DB2 Analytics Accelerator for z/OS V5.1.0
    maintenance level PTF-9 Update 1

    The V5.1 PTF-9 Release Notes still apply. Read them before installing this maintenance level


    Program number
    5697-DA5
    Heads up:
    if your IBM DB2 Analytics Accelerator version is less or equal to V4.1 PTF4, you have to follow these instructions:
    Migration recommendations and considerations

    Note:
    IBM DB2 Analytics Accelerator for z/OS V5.1.0 maintenance level PTF-9 Update 1 supports the following NPS versions:
    • NPS 7.2.1.11-P1
    • NPS 7.2.1.10-P2
    If you are running maintenance levels V5 PTF-6 or V5 PTF-7 and want to keep your active NPS version, contact IBM support for advice.
    Component APAR PTF Date Available
    MM/DD/YYYY
    Accelerator Server version: 5.1.9
    Build date: 20220608-1007
     
    Stored Procedures version: 5.1.9
    Build date: 20220519-0715
    PH47874 UI81454 19 July 2022
    Access Server 
    Core Version: 11.4.0.4.11065
    Build date: 20220608-1007
    Simple version: 4020101000130
    PH47876 UI81455 19 July 2022
    Replication Engine
    Core version: 11.4.0.4.5599
    Build date: 20220608-1007
    Simple version: 4030100001860
    PH47877 UI81456 19 July 2022
    Netezza Platform Software
    Core Version NPS: 7.2.1.11-P1 Build 4
    Build date: 20220608-1007
    Simple version:
    4040004010400
    PH47878 UI81457 19 July 2022
    PH47879 UI81458 19 July 2022
    PH47880 UI81459 19 July 2022
    PH47881 UI81460 19 July 2022
    PH47882 UI81461 19 July 2022
    PH47883 UI81462 19 July 2022
  • IBM DB2 Analytics Accelerator for z/OS 5.1.0 PTF-9
    IBM DB2 Analytics Accelerator for z/OS V5.1.0
    maintenance level PTF-9

    Before installing this version, read:
    V5.1 PTF-9 Release Notes

    Program number
    5697-DA5
    Heads up:
    if your IBM DB2 Analytics Accelerator version is less or equal to V4.1 PTF4, you have to follow these instructions:
    Migration recommendations and considerations

    Note:
    IBM DB2 Analytics Accelerator for z/OS V5.1.0 maintenance level PTF-9 supports the following NPS versions:
    • NPS 7.2.1.10-P2
    • NPS 7.2.1.8-P2
    If you are running maintenance levels V5 PTF-6 or V5 PTF-7 and want to keep your active NPS version, contact IBM support for advice.
    Component APAR PTF Date Available
    MM/DD/YYYY
    Accelerator Server version: 5.1.9
    Build date: 20220301-1646
    (Build date: 20210309-0924)
    Stored Procedures version: 5.1.9
    Build date: 20210902-1542
    UI79702
    (UI75279)
    UI78031
    15 March 2022
    (11 May 2021)

    13 Nov 2021
    Access Server 
    Core Version: 11.4.0.2.11016
    Build date: 20200421-01500
    Simple version: 4020101000120
    PH26769 UI70483
    11 July 2020
    Replication Engine
    Core version: 11.4.0.3.5566
    Build date: 20201019-1205
    Simple version: 4030100001850
    PH31483 UI72594
    17 November 2020
    Netezza Platform Software
    Core Version NPS: 7.2.1.10-P2 Build 5
    Build date: 20210309-0924
    Simple version:
    4040004010390
    PH32367 UI75280 11 May 2021
    PH32368 UI75281 11 May 2021
    PH32370 UI75282 11 May 2021
    PH32371 UI75283 11 May 2021
    PH32372 UI75284 11 May 2021
    PH32373 UI75285 11 May 2021
  • IBM DB2 Analytics Accelerator for z/OS 5.1.0 PTF-8
    IBM DB2 Analytics Accelerator for z/OS V5.1.0
    maintenance level PTF-8

    Before installing this version, read:
    V5.1 PTF-8 Release Notes

    Program number
    5697-DA5
    Heads up:
    if your IBM DB2 Analytics Accelerator version is less or equal to V4.1 PTF4, you have to follow these instructions:
    Migration recommendations and considerations

    Note:
    IBM DB2 Analytics Accelerator for z/OS V5.1.0 maintenance level PTF-8 supports the following NPS versions:
    • NPS 7.2.1.7-P2
    • NPS 7.2.1.8-P2
    If you are running maintenance levels V5 PTF-6 or V5 PTF-7 and want to keep your active NPS version, contact IBM support for advice.
    Component APAR PTF Date Available
    MM/DD/YYYY
    Accelerator Server version: 5.1.8
    Build date: 20200421-1500
    Stored Procedures version: 5.1.8
    Build date: 20191023-1705
    UI70178 07/06/2020
    Access Server (recommended)
    Core Version: 11.4.0.2.11016
    Build date: 20200421-01500
    Simple version: 4020101000120
    PH26769 UI70483
    07/11/2020
    Access Server
    Core Version: 11.4.10600
    Build date: 20190531-0147
    Simple version: 4020101000110
    PH12806
    PH13007
    PH14103
    UI64503
    09/01/2019
    Already delivered
    on top of V5 PTF7
    Replication Engine (recommended)
    Core version: 11.4.0.3.5566
    Build date: 20201019-1205
    Simple version: 4030100001850
    PH31483 UI72594
    11/17/2020
    Replication Engine
    Core version: 11.4.0.2.5537
    Build date: 20200421-1500
    Simple version: 4030100001830
    PH20556 UI70469
    07/11/2020
    Replication Engine update
    Core version: 11.4.0.2.5128
    Build date: 20190711-0033
    Simple version: 4030100001820
    UI64504
    09/01/2019
    Already delivered
    on top of V5 PTF7
    Netezza Platform Software
    Core Version NPS: 7.2.1.8-P2 Build 25
    Build date: 20190829-1500
    Simple version:
    4040004010380
    PH21678 UI67731 02/08/2020
    PH21692 UI67732 02/08/2020
    PH21707 UI67733 02/08/2020
    PH21711 UI67737 02/08/2020
    PH21712 UI67738 02/08/2020
    PH21721 UI67739 02/08/2020
  • IBM DB2 Analytics Accelerator for z/OS 5.1.0 PTF-7
    IBM DB2 Analytics Accelerator for z/OS V5.1.0
    maintenance level PTF-7

    Before installing this version, read:
    V5.1 PTF-7 Release Notes

    Program number
    5697-DA5
    Heads up:
    if your IBM DB2 Analytics Accelerator version is less or equal to V4.1 PTF4, you have to follow these instructions:
    Migration recommendations and considerations

    Note:
    IBM DB2 Analytics Accelerator for z/OS V5.1.0 maintenance level PTF7 supports the following NPS versions:
    • NPS 7.2.1.4-P3
    • NPS 7.2.1.5-P1-IF1
    • NPS 7.2.1.7
    • NPS 7.2.1.7-P2
    Component APAR PTF Date Available
    MM/DD/YYYY
    Accelerator Server version: 5.1.7
    Build date: 20191212-1800
    PH08914
    PH18395
    PH20337
    UI67051 12/17/2019
    Accelerator Server version: 5.1.7
    Build date: 20190118-1726
    Stored Procedures version: 5.1.7
    Build date: 20181126-0915
    PH06275 UI61027 02/04/2019
    Access Server component update
    Core Version: 11.4.10600
    Build date: 20190531-0147
    Simple version: 4020101000110
    PH12806
    PH13007
    PH14103
    UI64503 09/01/2019
    Access Server component update
    Core Version: 11.4.10600
    Build date: 20181207-0000
    Simple version: 4020101000100
    PH06276
    UI61021
    02/04/2019
    Replication Engine update component
    Core version: 11.4.0.2.5128
    Build date: 20190711-0033
    Simple version: 4030100001820
    UI64504 09/01/2019
    Replication Engine update component
    Core version: 11.4.0.1.5800
    Build date: 20181025-0000
    Simple version: 4030100001780
    PH06277 UI61020 02/04/2019
    Netezza Platform Software
    Core Version NPS: 7.2.1.7 Build 34
    Build date: 20181011-2142
    Simple version: 4040004010360
    PH06278 UI61014 02/04/2019
    PH06279 UI61015 02/04/2019
    PH06280 UI61016 02/04/2019
    PH06281 UI61017 02/04/2019
    PH06282 UI61018 02/04/2019
    PH06283 UI61019 02/04/2019
    Netezza Platform Software
    Core Version NPS: 7.2.1.7-P2 Build 27
    Build date: 20190215-1621
    Simple version:
    PH08901 UI62152 03/29/2019
    PH08902 UI62154 03/29/2019
    PH08903 UI62155 03/29/2019
    PH08904 UI62156 03/29/2019
    PH08905 UI62157 03/29/2019
    PH08906 UI62158 03/29/2019
  • IBM DB2 Analytics Accelerator for z/OS 5.1.0 PTF-6
    IBM DB2 Analytics Accelerator for z/OS V5.1.0
    maintenance level PTF-6

    Before installing this version, read:
    V5.1 PTF-6 Release Notes

    Program number
    5697-DA5
    Heads up:
    if your IBM DB2 Analytics Accelerator version is less or equal to V4.1 PTF4, you have to follow these instructions:
    Migration recommendations and considerations
    Note:
    IBM DB2 Analytics Accelerator for z/OS V5.1.0 maintenance level PTF6 supports the following NPS versions:
    • NPS 7.2.1.4-P1
    • NPS 7.2.1.4-P3
    • NPS 7.2.1.5-P1-IF1
    Component APAR PTF Date Available
    MM/DD/YYYY
    Accelerator Server version: 5.1.6
    Build date: 20180109-0000
    Stored Procedures version: 5.1.6
    Build date: 20171109-1136
    PI87839 UI53528 02/03/2018
    Stored Procedures
    version 5.1.6 1
    Build date: 20180509-1706
    PI94666 UI55928 05/23/2018
    Access Server component update
    Core Version: 11.4.0.0.10267
    Build date: 20171208-1326
    Simple version: 4020101000070
    PI87844 UI52872 02/03/2018
    Replication Engine update component
    Core version: 11.4.0.0.5044
    Build date: 20171117-0921
    Simple version: 4030100001760
    PI87847 UI52873 02/03/2018
    Netezza Platform Software
    Core Version NPS: 7.2.1.4-P3 Build 105
    Build date: 20170817-1148
    Simple version: 4040004010320
    PI87848 UI52826 02/03/2018
    PI87858 UI52867 02/03/2018
    PI87877 UI52868 02/03/2018
    PI87890 UI52869 02/03/2018
    PI87902 UI52870 02/03/2018
    PI87903 UI52871 02/03/2018
    Netezza Platform Software
    Core Version NPS: 7.2.1.5 -P1 Build 30
    Build date: 20180213-0916
    Simple version: 4040004010330
    PI94801 UI55039 (PE) 04/16/2018
    PI94802 UI55074 (PE) 04/16/2018
    PI94803 UI55075 (PE) 04/16/2018
    PI94804 UI55076 (PE) 04/16/2018
    PI94806 UI55077 (PE) 04/16/2018
    PI94807 UI55078 (PE) 04/16/2018

    Netezza Platform Software
    Core Version NPS:
    7.2.1.5-P1-IF1 Build 6
    Build date: 20180822-1527
    Simple version: 4040004010340

    PH00844 UI58938 10/14/2018
    PH00845 UI59002 10/14/2018
    PH00846 UI59003 10/14/2018
    PH00847 UI59004 10/14/2018
    PH00848 UI59005 10/14/2018
    PH00849 UI59021 10/14/2018

    (1) Supports federated access with Db2 12 for z/OS

  • IBM DB2 Analytics Accelerator for z/OS 5.1.0 PTF-5
    IBM DB2 Analytics Accelerator for z/OS V5.1.0
    maintenance level PTF-5

    Before installing this version, read:
    V5.1 PTF-5 Release Notes

    Program number
    5697-DA5
    Heads up:
    if your IBM DB2 Analytics Accelerator version is less or equal to V4.1 PTF4, you have to follow these instructions:
    Migration recommendations and considerations
    Component APAR PTF Date Available
    MM/DD/YYYY
    Accelerator Server version: 5.1.5
    Build date: 20170627-0200
    Stored Procedures version: 5.1.5
    Build date: 20170622-1947
    PI77066 UI48681 07/11/2017
    Replaced by:
    Accelerator Server version: 5.1.5
    Build date: 20170808-1945
    Stored Procedures version: 5.1.5
    Build date: 20170622-1947
    PI85560
    PI85615
    UI49630

    08/22/2017
    Access Server component update
    Core Version: 11.3.3.2.5300
    Build date: 20170706-1141
    Simple version: 4020100043170
    PI83910 UI48682 07/11/2017
    Replication Engine update component
    Core version: 11.3.3.3.Release_46
    Build date: 20170126-0000
    Simple version: 4030100001550
    PI75517 UI44936 02/28/2017
    Netezza Platform Software
    Core Version NPS: 7.2.1.4-P1
    Build date: 20170627-0200
    Simple version: 4040004010300
    PI83911 UI48683 07/11/2017
    PI83918 UI48684 07/11/2017
    PI83940 UI48687 07/11/2017
    PI83957 UI48688 07/11/2017
    PI83980 UI48689 07/11/2017
    PI83981 UI48690 07/11/2017
  • IBM DB2 Analytics Accelerator for z/OS 5.1.0 PTF-4
    IBM DB2 Analytics Accelerator for z/OS V5.1.0
    maintenance level PTF-4

    Before installing this version, read:
    V5.1 PTF-4 Release Notes

    Program number
    5697-DA5
    Heads up:
    if your IBM DB2 Analytics Accelerator version is less or equal to V4.1 PTF4, you have to follow these instructions:
    Migration recommendations and considerations
    Component APAR PTF Date Available
    MM/DD/YYYY
    Accelerator Server version: 5.1.4
    Build date: 20170217-1406
    Stored Procedures version: 5.1.4
    Build date: 20170130-1046
    PI75504 UI44937 02/28/2017
    Access Server component update
    Core Version: 11.3.3.2.5300
    Build date: 20170126-0000
    Simple version: 4020100043100
    PI75508 UI44935 02/28/2017
    Replication Engine update component
    Core version: 11.3.3.3 (Build Release_46)
    Build date: 20170126-0000
    Simple version: 4030100001550
    PI75517 UI44936 02/28/2017
    Netezza Platform Software
    Core Version NPS: 7.2.1.3-P3
    Build date. 20170126-0000
    Simple version: 4040004010270
    PI75523 UI44938 02/28/2017
    PI75530 UI44939 02/28/2017
    PI75541 UI44940 02/28/2017
    PI75552 UI44941 02/28/2017
    PI75554 UI44942 02/28/2017
    PI75576 UI44943 02/28/2017
  • IBM DB2 Analytics Accelerator for z/OS 5.1.0 PTF-3
    IBM DB2 Analytics Accelerator for z/OS V5.1.0
    maintenance level PTF-3

    Before installing this version, read:
    V5.1 PTF-3 Release Notes

    Program number
    5697-DA5
    Heads up:
    if your IBM DB2 Analytics Accelerator version is less or equal to V4.1 PTF4, you have to follow these instructions:
    Migration recommendations and considerations
    Component APAR PTF Date Available
    MM/DD/YYYY
    Accelerator Server version: 5.1.3
    Build date: 20161019-0001
    Stored Procedures version: 5.1.2
    Build date: 20160310-1108
    PI71144 UI42327 11/11/2016
    Access Server component update
    Core Version: 11.3.3.2.5300
    Build date: 20161019-0001
    Simple version: 4020100043060
    PI71146 UI42328 11/11/2016
    Replication Engine update component
    Core version: 11.3.3.2
    (Build Release_25)
    Build date: 20161019-0001
    Simple version: 4030100001530
    PI71151 UI42329 11/11/2016
    The corresponding APAR/PTFs
    are the same as in V5.1 PTF-2
    Netezza Platform Software
    Core Version NPS: 7.2.1.2
    (build 47843)
    Build date: 20160405-0918
    Simple version: 4040004010240
    PI60233 UI37785 06/02/2016
    PI60234 UI37786 06/02/2016
    PI60237 UI37793 06/02/2016
    PI60238 UI37794 06/02/2016
    PI60239 UI37795 06/02/2016
  • IBM DB2 Analytics Accelerator for z/OS 5.1.0 PTF-2
    IBM DB2 Analytics Accelerator for z/OS V5.1.0
    maintenance level PTF-2

    Before installing this version, read:
    V5.1 PTF-2 Release Notes

    Program number
    5697-DA5
    Heads up:
    if your IBM DB2 Analytics Accelerator version is less or equal to V4.1 PTF4, you have to follow these instructions:
    Migration recommendations and considerations
    Component APAR PTF Date Available
    MM/DD/YYYY
    Accelerator Server version: 5.1.2
    Build date: 20160422-0100
    Stored Procedures version: 5.1.2
    Build date: 20160310-1108
    PI60229 UI37796 06/02/2016
    Access Server component update
    Core Version: 11.3.3.2.5300
    Build date: 20160305-0101
    Simple version: 4020100043050
    PI60231 UI37783 06/02/2016
    Replication Engine update component
    Core version: 11.3.3.2
    (Build Release_25)
    Build date: 20160204-0822
    Simple version: 4030100001520
    PI60232 UI37784 06/02/2016
    Netezza Platform Software
    Core Version NPS: 7.2.1.2
    (build 47843)
    Build date: 20160405-0918
    Simple version: 4040004010240
    PI60233 UI37785 06/02/2016
    PI60234 UI37786 06/02/2016
    PI60237 UI37793 06/02/2016
    PI60238 UI37794 06/02/2016
    PI60239 UI37795 06/02/2016
  • IBM DB2 Analytics Accelerator for z/OS 5.1.0 PTF-1
    IBM DB2 Analytics Accelerator for z/OS V5.1.0
    maintenance level PTF-1

    Before installing this version, read:
    V5.1 PTF-1 Release Notes

    Program number
    5697-DA5
    Component APAR PTF Date Available
    MM/DD/YYYY

    Accelerator Server version: 5.1.1
    Build date: 20151217-2301

    Stored Procedures version: 5.1.1
    Build date: 20160112-1532

    Replaced by:
    Accelerator Server version: 5.1.1
    Build date: 20160419-2149
    Stored Procedures version: 5.1.1
    Build date: 20160112-1532

    PI56036

    UI35012

    02/09/2016
    PI60730 UI37271

    04/26/2016
    Access Server
    Version: 11.3.3.4289
    Build date: 20151217-2301
    Simple version: 4020100042320
    PI56040 UI35007 02/09/2016
    Replication Engine base
    Core version 11.3.3
    Build BR_LSTYTHIK_96_9
    Build date: 20151110-1859
    Simple version: 44030100001100
    n/a

    n/a 11/27/2015
    Replication Engine update
    Core version 11.3.3.1
    Build BR_IDAA_10
    Build date: 20151110-1859
    Simple version: 4030100001410
    n/a

    n/a 11/27/2015
    Netezza Platform Software 7.2.1.1
    Build 46779
    Build date: 20151217-2301
    Simple version: 4040004010130
    PI56045 UI35006 02/09/2016
    PI56047 UI35008 02/09/2016
    PI56050 UI35009 02/09/2016
    PI56051 UI35010 02/09/2016
    PI56052 UI35011 02/09/2016
  • IBM DB2 Analytics Accelerator for z/OS 5.1.0 GA
    IBM DB2 Analytics Accelerator for z/OS V5.1.0
    maintenance level GA

    Before installing this version, read:
    V5.1.0 GA Release Notes

    Program number
    5697-DA5

    Heads up:
    IBM DB2 Analytics Accelerator for z/OS Version 5.1.0 GA
    replaced by
    IBM DB2 Analytics Accelerator for z/OS 5.1.0 PTF-1
    Component APAR PTF Date Available
    MM/DD/YYYY

    Accelerator Server version: 5.1.0
    Build date: 20151110-1859
    Stored Procedures version: 5.1.0
    Build date: 20151117-1527

    n/a n/a 11/27/2015

    Access Server
    Core version: 11.3.3.4289
    Build date: 20151112-2141
    Simple version: 4020100042310

    n/a n/a 11/27/2015

    Replication Engine base
    Core version 11.3.3
    Build BR_LSTYTHIK_96_9
    Build date: 20151110-1859
    Simple version: 44030100001100

    n/a n/a 11/27/2015

    Replication Engine update
    Core version 11.3.3.1
    Build BR_IDAA_10
    Build date: 20151110-1859
    Simple version: 4030100001410

    n/a n/a 11/27/2015

    Netezza Platform Software (NPS) 7.2.1.0
    Build 46322
    Build date: 20151110-1859
    Simple version: 4040004010060

    n/a n/a 11/27/2015

Coexistence with Db2 Analytics Accelerator V7

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.
 

Minimum space settings in SMP/E for the installation of IBM DB2 Analytics Accelerator V5.1.0
and its prerequisites PTFs

1. Temporary data set SYSUT1, SYSUT2, SYSUT3, SYSUT4 in the target, distribution, and global zones: SPACE=(TRK,(2000,1000))
2. Work data set SYSWRK1, SYSWRK2, SYSWRK3, SYSWRK4, SYSWRK5, SYSWRK6 in the target and distribution zones: SPACE=(TRK,(1000,1000,450))

Reserve enough storage space for the installation of IBM DB2 Analytics Accelerator for z/OS. The table "Total DASD space required by IBM DB2 Analytics Accelerator for z/OS V5.1.0" shows the space requirements for a basic installation.
Total DASD space required by IBM DB2 Analytics Accelerator for z/OS V5.1.0
Library type Total space required on a DASD 3390
Target 1865 tracks for DB2 Analytics Accelerator
854 tracks for InfoSphere Data Replication
Distribution 79865 tracks for DB2 Analytics Accelerator
1632 tracks for InfoSphere Data Replication
File system(s) 105000 tracks for /usr/lpp/IBM/aqt/v5r1m0
750 tracks for /usr/lpp/chc/V10R2M1

Total DASD space required by optional feature "in-database analytics"
Library type Total Space required on a DASD 3390
File system(s) 22000 tracks for /usr/lpp/IBM/aqt/v5r1m0


Information for IBM service personnel

Before shipping any hardware or software, make sure that you fill in the system assurance confirmation form.
 

Hardware requirements

The following table shows the minimum hardware requirements that must be met to successfully install IBM DB2 Analytics Accelerator for z/OS.

  • Computers
    Quantity Product Program number
    1 IBM zEnterprise® 196 (z196)
    or
    2817
    IBM zEnterprise® 114 (z114)
    or
    2818
    IBM zEnterprise® EC12 (zEC12)
    or
    2827
    IBM zEnterprise® BC12 (zBC12)
    or
    2828
    IBM z13™
    Models: N30, N63, N96, NC9, or NE1
    or
    2964
    IBM z14™
    Models: M01, M02, M03, M04, M05
    3906
    IBM z15™
    Models: T01
    8561
    1 IBM PureData System for Analytics N1001-3
    with North American power connectors 1
    or
    5725-E46
    IBM PureData System for Analytics N1001-3
    with European power connectors 1
    or
    5725-E47
    IBM PureData System for Analytics N1001-6 1
    or
    5725-E48
    IBM PureData System for Analytics N1001-12 1
    or
    5725-E49
    IBM PureData System for Analytics N1001-18 1
    or
    5725-E50
    IBM PureData System for Analytics N1001-24 1
    or
    5725-E51
    IBM PureData System for Analytics N1001-36 1
    or
    5725-E52
    IBM PureData System for Analytics N1001-48 1
    or
    5725-E53
    IBM PureData System for Analytics N1001-72 1
    or
    5725-E54
    IBM PureData System for Analytics N1001-96 1
    or
    5725-E55
    IBM PureData System for Analytics N1001-120 1
    or
    5725-E56
    IBM PureData® System for Analytics N1001-002
    with North American power connectors 1
    or
    5725-E46
    IBM PureData® System for Analytics N1001-002
    with North European connectors 1
    or
    5725-E47
    IBM PureData System for Analytics N1001-005 1
    or
    5725-E48
    IBM PureData System for Analytics N1001-010 1
    or
    5725-E49
    IBM PureData System for Analytics N1001-015 1
    or
    5725-E50
    IBM PureData System for Analytics N1001-020 1
    or
    5725-E51
    IBM PureData System for Analytics N1001-030 1
    or
    5725-E52
    IBM PureData System for Analytics N1001-040 1
    or
    5725-E53
    IBM PureData System for Analytics N1001-060 1
    or
    5725-E54
    IBM PureData System for Analytics N1001-080 1
    or
    5725-E55
    IBM PureData System for Analytics N1001-100 1
    or
    5725-E56
    IBM PureData System for Analytics N2001-005 1
    or
    5725-I26
    IBM PureData System for Analytics N2001-010
    or
    5725-I27
    IBM PureData System for Analytics N2001-010
    with 3-Phase Delta Power
    or
    5725-I28
    IBM PureData System for Analytics N2001-020
    or
    5725-I29
    IBM PureData System for Analytics N2001-020
    with 3-Phase Delta Power
    or
    5725-I30
    IBM PureData System for Analytics N2001-040
    or
    5725-I31
    IBM PureData System for Analytics N2001-040
    with 3-Phase Delta Power
    or
    5725-I32
    IBM PureData System for Analytics N2002-002
    or
    5725-N24
    IBM PureData System for Analytics N2002-005
    or
    5725-N25
    IBM PureData System for Analytics N2002-010
    or
    5725-N26
    IBM PureData System for Analytics N2002-020
    or
    5725-N27
    IBM PureData System for Analytics N2002-040
    or
    5725-N28
    IBM PureData System for Analytics N3001-001
    or
    5725-S22
    IBM PureData System for Analytics N3001-002
    or
    5725-R40
    IBM PureData System for Analytics N3001-005
    or
    5725-R41
    IBM PureData System for Analytics N3001-010
    or
    5725-R42
    IBM PureData System for Analytics N3001-020
    or
    5725-R43
    IBM PureData System for Analytics N3001-040
    or
    5725-R44
    IBM PureData System for Analytics N3001-080
    or
    5725-R45
    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

    ( 1 ) See the Support statement on IBM PureData Systems for Analytics N1001 running Red Hat Enterprise Linux (RHEL) 5.x . In accordance with this statement, IBM will continue to provide critical and priority fixes for IBM DB2 Analytics Accelerator for z/OS (Version 4 and Version 5), using the described combination of hardware and software.

Networking
For the data network between IBM z Systems and PureData System for Analytics N1001 (N2001, N3001), 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 P/N
1 OSA-Express3 10GbE (dual port) IBM zEnterprise System (*)
OSA-Express4S 10GbE (single port) zEnterprise 196 or zEnterprise 114 (*)
OSA-Express5S 10GbE zEnterprise EC12 or zEnterprise BC12
AND
1 10GbE SFP + Switch
Lenovo RackSwitch G8264
Lenovo RackSwitch G8124E
Network (**)
3 Optical fiber cables Network
(*) IBM/BNT® 10Gb SFP + Optical Transceiver Switch (*)
1
Note: only needed for
IBM PureData System for Analytics
N3001-001
1 GbE RJ45 Switch
Lenovo RackSwitch G7028
Network
2
Note: only needed for
IBM PureData System for Analytics
N3001-001
RJ45 cable Network

(*) For details about supported OSA-Express 10GbE cards and the required type and number of transceivers see:
  Network requirements for IBM Z
(**) If you want to know why a direct network connection does not provide automatic fail-over support and hence at least one switch is needed, see:
Network Configurations for IBM DB2 Analytics Accelerator for z/OS

Recommended network configuration
The following components are required for a fully redundant (high availability) network between IBM z Systems and the PureData System for Analytics N1001 (N2002, N3001).

Quantity Product Location P/N
2 OSA-Express3 10GbE (dual port) IBM zEnterprise System (*)
OSA-Express4S 10GbE (single port) zEnterprise 196 or zEnterprise 114 (*)
OSA-Express5S 10GbE zEnterprise EC12 or zEnterprise BC12
8 Optical fiber cables Network
2 10GbE SFP + Switch
Lenovo RackSwitch G8264
Lenovo RackSwitch G8124E
Network (**)
(*) IBM/BNT® 10Gb SFP + Optical Transceiver Switch (*)
1
Note: only needed for
IBM PureData System for Analytics
N3001-001
1 GbE RJ45 Switch
Lenovo RackSwitch G7028
Network
2
Note: only needed for
IBM PureData System for Analytics
N3001-001
RJ45 cable Network

Software requirements
Operating system Required z/OS base elements
z/OS V2R5
z/OS V2R4
z/OS V2R3
z/OS V2R2
z/OS OpenSSH
Data Facility System Managed Storage Base (DFSMSdfp)
Communications Server IP
Required features and PTFs
XML Toolkit for z/OS1 2 (5655-J51), V1.10.0, APAR OA51592, PTF UA83613

(1) The XML Toolkit V1.10.0 is no longer required with accelerator maintenance level 'V5 PTF9' or higher.
(2) The XML Toolkit V1.11.0 is not compatible with IBM Db2 Analytics Accelerator Version 5. 


Database management software

Use one of the supported database management systems on your IBM Z server (DB2 10 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
Database management system Required features and PTFs Program number
DB2 10 for z/OS 1
New Function Mode (NFM)
MLC
or
Value Unit Edition
5605-DB2

5697-P31
DB2 Utilities Suite for z/OS version 10.1 5655-V41
A number of Db2-supplied stored procedures must be configured. See the Installation Guide, SH12-7062, for details.
DB2 11 for z/OS
New Function Mode (NFM),
Conversion Mode (CM)
MLC
or
Value Unit Edition
5615-DB2

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

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

( 1 ) Withdrawn from programming service on September 30, 2017 .
( 2 ) For known issues concerning support of DB2 12 for z/OS read here.

Recommended minimum level of JDBC driver
IBM support can verify the version of your JDBC driver by using the following command on the accelerator:
/nz/dwa/ext/iu/AccessServer/jre64/jre/bin/java -cp /nz/dwa/ext/iu/dwa-iu-interface/lib/db2jcc4.jar 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
for DB2 10 for z/OS
3.64.111
PM65007 for DB2 10 for z/OS
IBM Data Server Driver for JDBC and SQLJ (db2jcc4.jar) 1 4.13.145
PM65004 for DB2 10 for z/OS
4.14.119
PM65003 for DB2 10 for z/OS
IBM Data Server Driver for JDBC and SQLJ V10.1 Fix Pack 2 IP23387-IP23396
Depending on the platform. This is sometimes required if you need to specify Db2 for z/OS special registers as part of the connection URL.

Required ODBC driver level
Depending on your Linux, UNIX, or Windows operating system, the minimum level for DB2 Connect Version 10.5 is fix pack 4 and the minimum level for DB2 Connect Version 10.1 is fix pack 4. To enable the special registers for query acceleration,see Enabling query acceleration with IBM DB2 Analytics Accelerator for ODBC and JDBC applications 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.

 

(1) If using Db12 with function level 501 or higher, enabling and use of replication or the use of the Analytics Accelerator plugin may no longer work!
Depending on the maintenance level of IBM Db2 Analytics Accelerator for z/OS V5.1 the following corrective action is needed:
a) Your maintenance level is PTF7:
Install the PTFs for APARs PH14103 and PH14105 and upgrade both the access server and replication engine components.
b) Your maintenance level is lower than PTF7:
Please contact IBM support to replace the JDBC driver on the accelerator.



Mandatory DB2-PTFs

Mandatory PTFs when using Db2 10

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

Db2 PTF number Db2 APAR number Mandatory since accelerator maintenance level Comments
UI48441 PI76645 V5 PTF-5

Note that neither the federation feature nor the HTAP feature are supported with DB2 10.

Mandatory PTFs when using Db2 11

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

Db2 PTF number Db2 APAR number Mandatory since accelerator maintenance level Comments
UI48442 PI76645 V5 PTF-5
UI48595 PI77826 V5 PTF-5 Required when using the federation feature
UI51280 PI83286
PI83288
V5 PTF-6 Required when using the HTAP (1) feature
(1) Note that use of the HTAP feature also requires CDC PTFs.
 

Mandatory PTFs when using Db2 12

When running IBM Db2 Analytics Accelerator for z/OS V5.1.0 with Db2 12, all PTFs included up to PUT1609 are mandatory. This maintenance level of DB2 12 was certified in combination with IBM DB2 Analytics Accelerator for z/OS V5.1.0 maintenance level PTF-2 or higher.
In addition, the following DB2-PTFs must be installed:

Db2 PTF number Db2 APAR number Mandatory since accelerator maintenance level Comments
UI48621 PI82739 V5 PTF-5
UI54293 PI91620 V5 PTF-6 Required when using the HTAP (1) feature
(1) Note that use of the HTAP feature also requires CDC PTFs .

Find known issues for use of IBM Db2 Analytics Accelerator for z/OS V5.1.0 with Db2 12
here .

Recommended DB2-PTFs

We recommend having PUT-level 1609 installed for your Db2 environment. To determine all (DB2-)PTFs recommended for use with IBM DB2 Analytics Accelerator for z/OS V5.1.0, use the SMP/E REPORT MISSINGFIX command along with FIXCAT HOLDDATA as follows:

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

Netezza database management software

Use the following certified Netezza Platform Software (NPS) version on your PureData System for Analytics as indicated in the following table. If more than one NPS version is certified, upgrade to the highest version.

 
IBM PureData System
for Analytics families
Applicable with
IBM DB2 Analytics Accelerator
for z/OS V5.1.0 maintenance level
NPS version
N1001
N2001
N2002
N3001
GA 7.2.1.0
PTF-1 7.2.1.0,
7.2.1.1
PTF-2 7.2.1.1,
7.2.1.2
PTF-3 7.2.1.2
PTF-4 7.2.1.2,
7.2.1.3-P3
PTF-5
7.2.1.3-P3
7.2.1.4-P1
PTF-6
7.2.1.4-P1
7.2.1.4-P3
7.2.1.5-P1-IF1
PTF-7
7.2.1.4-P3
7.2.1.5-P1-IF1
7.2.1.7
7.2.1.7-P2
PTF-8
7.2.1.7-P2
7.2.1.8-P2
(7.2.1.4-P3
7.2.1.5-P1-IF1
7.2.1.7:
contact IBM support)
PTF-9
7.2.1.8-P2
7.2.1.10-P2


Netezza Host Platform (HPF) and Netezza Firmware (FDT)

The table below shows the recommended versions of Netezza Host Platform (HPF) and the minimum recommended version of Netezza Firmware (FDT) for your PureData System for Analytics. Recommended in this content means: these versions have been certified during development and test of IBM DB2 Analytics Accelerator Version 5.

The minimum versions of HPF and FDT supported are listed in the release notes of the specific NPS version. These can be found on Fix Central.

You can check the current HPF and FDT versions using IBM DB2 Analytics Accelerator Studio Version 4 or later. To display the current versions, open the About section in the Accelerator view. If an update is required, open a service request against IBM DB2 Analytics Accelerator.


Netezza Platform Software Netezza model Minimum HPF versions Minimum FDT version
7.2.1.0
7.2.1.1
7.2.1.2
7.2.1.3-P3
7.2.1.4-P1
7.2.1.4-P3
7.2.1.5-P1-IF1
7.2.1.7
7.2.1.7-P2
7.2.1.8-P2
7.2.1.10-P2
N1001
N2001
N2002
N3001
N3001-001
N1001: 4.13
N2001: 5.0
N2002: 5.3
N3001: 5.4.
N3001-001: 5.4.1
N1001: 2.3.1
N2001: 3.0
N2002: 3.0.5
N3001: 4.2
N3001-001: 4.2.1.

For download of HPF or FDT start on Fix Central . Proceed with 'Select product' and select 'Product Group' > Information Management,
'Select from Information Management' > IBM NetezzaPlatform, 'Installed Version' > {required HPF or FDT version}


Incremental update function

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

IBM DB2 Analytics Accelerator Studio

IBM Db2 Analytics Accelerator Studio can be downloaded from:

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

IBM DB2 Analytics Accelerator Studio V7 is compatible with all maintenance levels of the accelerator software. We recommend to use the latest maintenance level, 7.5.9-Information_Management-IDAA_Studio-Multiplatform-20220705-1612.
To download the corresponding IBM Installation Manager repository for upgrades use the following link: Fix Central.

You can also add the plug-ins to an existing installation of IBM Data Studio or to products that are based on IBM Data Studio.

The following maintenance level of IBM Data Studio is supported:

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

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

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

Running IBM DB2 Analytics Accelerator Studio on Linux

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

IBM Data Studio 4.1.4 supports:

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

Read the Eclipse FAQ entry for Eclipse 4.4.


In-database analytics

To exploit the new in-database analytics function, download IBM Netezza Analytics for IBM Z from here.

IBM DB2 Analytics Accelerator for z/OS V5.1.0 maintenance level Required version of
in-database analytics
Required version of NPS
5.1.0 GA 3.2.1.0-IM-Netezza-ANALYTICS-IDAA-fp105780
(dwa-inza-3.2.1-20151217-2301)
7.2.1.0
5.1.0 PTF-1 3.2.1.0-IM-Netezza-ANALYTICS-IDAA-fp105780
(dwa-inza-3.2.1-20151217-2301)
7.2.1.0
or
7.2.1.1
5.1.0 PTF-2 3.2.2.0-IM-Netezza-ANALYTICS-IDAA-fp110852
(dwa-inza-3.2.2-20160404-0100)
7.2.1.1
or
7.2.1.2
5.1.0 PTF-3 3.2.2.0-IM-Netezza-ANALYTICS-IDAA-fp110852
(dwa-inza-3.2.2-20160414-0100)
7.2.1.2
5.1.0 PTF-4 3.2.4.0-IM-Netezza-ANALYTICS-IDAA-fp116948
(dwa-inza-3.2.4-20170128_0000)
7.2.1.3-P3
5.1.0 PTF-5 3.2.4.0-IM-Netezza-ANALYTICS-IDAA-fp116948
(dwa-inza-3.2.4-20170128_0000)
7.2.1.4-P1
5.1.0 PTF-6 3.2.4.0-IM-Netezza-ANALYTICS-IDAA-fp116948
(dwa-inza-3.2.4-20170128_0000)
7.2.1.4-P3
or
7.2.1.5-P1-IF1
5.1.0 PTF-7 3.3.8.0-IM-Netezza-ANALYTICS-IDAA-fp9587
(dwa-inza-3.3.8-20211118_1118)
7.2.1.4-P3
or
7.2.1.5-P1-IF1
or
7.2.1.7
or
7.2.1.7-P2
5.1.0 PTF-8 3.3.8.0-IM-Netezza-ANALYTICS-IDAA-fp9587
(dwa-inza-3.3.8-20211118_1118)
7.2.1.7-P2
or
7.2.1.8-P2
5.1.0 PTF-9 3.3.8.0-IM-Netezza-ANALYTICS-IDAA-fp9587
(dwa-inza-3.3.8-20211118_1118)
7.2.1.8-P2
or
7.2.1.10-P2

Encryption of data in motion

Encryption of data in motion is an optional feature. It is only supported for IBM PureData System for Analytics N2001, N2002, and N3001.
Before setting up encryption in motion, open a service request to get the

  • Libreswan module on your accelerator updated to version 3.23 or higher.
  • Hardware acceleration activated by IBM support (by using command 'sh upgrade_kernel.sh install_fips')
Product Required version Location
Red Hat Enterprise Linux (RHEL)
Note: the installation has to be done by IBM support
6.6 or higher IBM PureData System for Analytics
Host Management Kit (HMK)
Note:
  • The HMK includes the libreswan package
  • The installation has to be done by IBM support
5.4.22 or higher IBM PureData System for Analytics
z/OS Communications Server 1.13 or higher z/OS

Migration scenarios

You can upgrade IBM DB2 Analytics Accelerator for z/OS as indicated in the following diagram .
For further information, refer to the IBM DB2 Analytics Accelerator for z/OS Version 5.1.0 Installation Guide.


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.
 
Maintenance level information
Setup Mandatory requirements
The Loader is used with Accelerator V5.
PTF for Loader-APAR PI78727
and
Accelerator V5 Stored Procedures on maintenance level V5 PTF-4 or higher
The Loader is used with Accelerator V5.
The V5 Stored Procedures are on maintenance level V5 PTF-8 or higher.
PTF for Loader-APAR PH37059
The Loader is used with Accelerator V5 and Accelerator V7 in a coexistence setup.
Data are loaded to both a V5 accelerator and a V7 accelerator (HALOAD).
PTF for Loader-APAR PH37059
and
Accelerator V5 Stored Procedures on maintenance level V5 PTF-8 or higher 
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

 
History of changes
September 9, 2022:
  • Delete list of outdated maintenance levels of DB2 Analytics Accelerator Studio; adapt link to most current maintenance level
September 13, 2022:
  • Mention Loader APAR PH46656 and the parallel need for installing the PTF belonging to Db2 APAR PH45948
August 25, 2022:
  • Adapt link to list of Loader PTFs
July 20, 2022:
  • New maintenance level V5 PTF-9 Update 1
March 15, 2022:
  • New accelerator server within maintenance level V5 PTF-9: APAR PH44721 / PTF UI79702
  • 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"
February 2, 2022:
  • Provide correct maintenance level of latest version of IBM Db2 Analytics Accelerator plugin'
February 1, 2022:
  • Maintenance level information in section for 'IBM Db2 Analytics Accelerator Loader'
January 27/28, 2022:
  • Adapt V5 maintenance levels in section 'Coexistence with Db2 Analytics Accelerator V7'
  • Specify PTF for Loader-APAR PH37059 as mandatory maintenance level rather than the PTF number
  • Add new section for 'IBM Db2 Analytics Accelerator Loader'
November 24, 2021:
  • Maintenance level V5 PTF9: new stored procedure maintenance level: add PH42008 / UI78031
  • Add new INZA package 3.3.8.0-IM-Netezza-ANALYTICS-IDAA-fp9587
October 4, 2021:
  • List of supported operating systems: add z/OS 2.5, remove z/OS 2.1
September 3, 2021:
  • Clarify need of XML Toolkit for z/OS V1.10.0 (also required for z/OS 2.4; not required with accelerator maintenance level V5PTF9
May 21, 2021:
  • Availability of maintenance level V5PTF9
Mar 10, 2021:
  • Point to important Db2 12 maintenance: PTFs PH28050/UI71492 and PH21726/UI71209
Nov 18, 2020:
  • V5-PTF8: New version Replication Engine 11.4.0.3-5566
  • Replace download link for Data Studio (due to sunset of developerworks)
  • Mention latest version of IBM Db2 Analytics Accelerator Studio (7.5.3)
Sep 23, 2020:
  • V5-PTF8: Build number 27 corrected to 25 in "Core Version NPS: 7.2.1.8-P2 Build 25"
Jul 15, 2020:
  • Update information for maintenance new level V5-PTF8: updates of accelerator server, access server, and replication engine
  • Update latest available level of IBM DB2 Analytics Accelerator Studio
Feb 26, 2020:
  • Change references of the Installation Guide: point to the new file name released with V5 PTF-8
  • Correct HPF and FDT minimum versions according to Netezza documentation
  • Describe maintenance level requirements for coexistence between V5 and V7

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

Product Synonym

IDAA

Document Information

Modified date:
13 September 2022

UID

swg27046305