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

  • What's new?

    Please find information about new functions here.



IBM DB2 Analytics Accelerator for z/OS - maintenance level

  • 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
  • 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 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 consideration V5.1.0 PTF-2
    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-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 consideration V5.1.0 PTF-3
    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-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 consideration V5.1.0 PTF-4
    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-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 consideration V5.1.0 PTF-5
    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
    Access Server component update
    Core Version: 11.3.3.2.5300
    Build date: 20170706-1141
    Simple version: 4020100043100
    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

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) 2828
    IBM z13™
    Model: N30, N63, N96, NC9 or NE1
    2964
    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 ) Please 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 the IBM zEnterprise System and the 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 10 GbE 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 10 GbE (dual port) IBM zEnterprise System (*)
OSA-Express4S 10 GbE (single port) zEnterprise 196 or zEnterprise 114 (*)
OSA-Express5S 10 GbE zEnterprise EC12 or zEnterprise BC12
AND
1 10 GbE 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 OSAExpress 10GbE cards and the required type and number of transceivers see:
  Network requirements for System 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 the IBM zEnterprise System and the PureData System for Analytics N1001, the PureData System for Analytics N2001 and the PureData System for Analytics N2002, or the PureData System for Analytics N3001.
Quantity Product Location P/N
2 OSA-Express 10 GbE IBM zEnterprise System (*)
8 Optical fiber cables Network
2 10 GbE 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 systems
Operating system Required features and PTFs Program number
z/OS V2R1 XML Toolkit for z/OS, V1.10.0
APAR OA51592, PTF UA83613
5655-J51
IBM Ported Tools for z/OS V1.3.0 or later
(OpenSSH server with AllowTcpForwarding or
OpenSSH client + OpenSSH server) 1
5655-M23
Data Facility System Managed Storage Base
(DFSMSdfp)
5695-DF1
Communication Server IP HIP61D0
z/OS V2R2 XML Toolkit for z/OS, V1.10.0
APAR OA51592, PTF UA83613
5655-J51
z/OS OpenSSH
Use the following link for information
to plan your changes to the system
Accommodate the OpenSSH ported level
integrated in z/OS V2R2
Data Facility System Managed Storage Base
(DFSMSdfp)
5695-DF1
Communication Server IP HIP61D0

( 1 ) For ordering contact IBM with keywords "Withdrawn Order Process".


Database management software

Use one of the supported database management systems on your System z server (DB2 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
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 1 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 ) For known issues concerning support of DB2 12 for z/OS read here.

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


Mandatory DB2-PTFs

  • V5.1.0 maintenance level PTF-5

    When running IBM DB2 Analytics Accelerator for z/OS V5.1.0 with maintenance level PTF-5 or higher, the following DB2-PTFs must be installed:

    • DB2 Version 10: PTF UI48441 (APAR PI76645)
    • DB2 Version 11: PTF UI48442 (APAR PI76645)
    • DB2 Version 12: PTF UI48621 (APAR PI82739)

    The new federation feature is only supported with DB2 Version 11. If you plan to use it, you must also install the following DB2-PTF:

    • DB2 Version 11: PTF UI48595 (APAR PI77826)
  • DB2 12 for z/OS

    All PTFs included up to PUT1609 are required. 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. When running IBM DB2 Analytics Accelerator for z/OS V5.1.0 with maintenance level PTF-5 or higher PTF UI48621 is also required.
    Please find known issues here.


Recommended DB2-PTFs

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


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

Use the following certified versions of Netezza Host Platform (HPF) and Netezza Firmware (FDT) for your PureData System for Analytics as indicated in the table below. 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 Required minimum version
HPF
Required minimum version
FDT
7.2.1.0
7.2.1.1
7.2.1.2
7.2.1.3-P3
7.2.1.4-P1
N1001 4.13 2.3.1
N2001 5.0 3.0
N2002 5.3 3.0.5
N3001 5.4 4.2
N3001-001 5.4.1 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 DB2 Analytics Accelerator product package. The following CDC PTFs are recommended for the incremental update function:

IBM InfoSphere Change Data Capture for z/OS
IBM InfoSphere Change Data Capture
for z/OS Version 10.2.1
or
Service Update (SUP)-tape
Version 10.2.2
IBM DB2 Analytics Accelerator for z/OS
V5.1.0 maintenance level
APAR PTF
GA
PTF-1
PTF-2
PTF-3
PTF-4
PTF-5
All CDC PTFs up to and including PUT level 1601 and the following ones:
PI57199 UI42946
PI63384 UI38702
PI65350
PI74715
UI43865
PI65518 UI40401
PI66448 UI39921
PI69113 UI42626
PI69991 UI41378 1
PI75970 UI46865
PI77397 UI45775

( 1 ) Enable CDC for z/OS with DB2 12
For information how to install or upgrade InfoSphere CDC for z/OS read here.

Until further notice we recommend to NOT install PTF UI47911.


IBM DB2 Analytics Accelerator Studio

IBM DB2 Analytics Accelerator Studio is the graphical administration interface for the product and can be downloaded from:
IBM developerworks:
developerWorks/downloads/im/data
IBM Fix Central:
Information Management/DB2 Analytics Accelerator Studio
The Full Image for initial installation, including DataStudio, is available here:
DB2 Analytics Accelerator Studio Full Image

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

IBM DB2 Analytics Accelerator
for z/OS
V5.1.0 maintenance level
IBM DB2 Analytics Accelerator Studio (client) required minimum version
Refresh-Pack name as appearing
on Fix Central
Version string in About section
of IBM Data Studio
GA 5.1.0.0-Information Management-IDAA
Studio-Multiplatform-20151112-1939
5.1.0.0.201511121939
PTF-1 5.1.0.1-Information Management-IDAA
Studio-Multiplatform-20151211-1549
5.1.0.1.201512111549
PTF-2
PTF-3
5.1.0.2-Information Management-IDAA
Studio-Multiplatform-20160318-1327
5.1.0.2.201603181305
PTF-4 6.1.0.0-Information Management-IDAA
Studio-Multiplatform-20161111-0819
6.1.0.201611110815
PTF-5 6.1.0.3-Information Management-IDAA
Studio-Multiplatform-20170628-2249
6.1.3.201706282249

The latest version of IBM DB2 Analytics Accelerator Studio, 6.1.0.3-Information_Management-IDAA_Studio-Multiplatform-20170628-2249 is recommended to be used with all versions of the accelerator server software. To download the corresponding IBM Installation Manager repository for upgrades use the following link: Fix Central
You can also add the plug-ins to an existing installation of IBM Data Studio or to products that are based on IBM Data Studio.
Recommendation: If you use IBM DB2 Analytics Accelerator Studio with an older version of IBM Data Studio, consider moving to IBM Data Studio 4.1.2.

The following versions are supported:

  1. IBM Data Studio 4.1
  2. IBM Data Studio 4.1.0.1
  3. IBM Data Studio 4.1.1
  4. IBM Data Studio 4.1.2

The plug-ins and fixes for IBM DB2 Analytics Accelerator Studio are available from the following download sites:
Installation Manager repository for IBM Data Studio 4.1, IBM Data Studio 4.1.0.1, IBM Data Studio 4.1.1 and IBM Data Studio 4.1.2
Eclipse update site for IBM Data Studio 4.1, IBM Data Studio 4.1.0.1, IBM Data Studio 4.1.1 and IBM Data Studio 4.1.2

The upgrade from these products is described in the IBM DB2 Analytics Accelerator for z/OS Version 5.1.0 Installation Guide, chapter "Updating IBM DB2 Analytics Accelerator Studio".

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

Running IBM DB2 Analytics Accelerator Studio on Linux

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

IBM Data Studio 4.1, IBM Data Studio 4.1.0.1, and IBM Data Studio 4.1.1 support:

Mozilla 1.4 GTK2 - 1.7.x GTK2, XULRunner 1.8.x - 1.9.x and 3.6.x (but not 2.x), WebKitGTK+ 1.2.x

Read the Eclipse FAQ entry for Eclipse 4.2.2

IBM Data Studio 4.1.2 supports:

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

Read the Eclipse FAQ entry for Eclipse 4.4


In-database analytics

To exploit the new in-database analytics function, download IBM Netezza Analytics for System 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

Encryption of data in motion

Encryption of data in motion is a new optional feature. It is only supported for IBM PureData System for Analytics N2001, IBM PureData System for Analytics N2002 and IBM PureData System for Analytics N3001.

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
Note: the installation has to be
done by IBM support
5.4.1.0 or higher IBM PureData System for Analytics
z/OS Communications Server 1.13 or higher z/OS

Migration options

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.

Original publication date

2016/1/8

Product Alias/Synonym

IDAA

Document information

More support for: DB2 Analytics Accelerator for z/OS

Software version: 5.1.0

Operating system(s): z/OS

Reference #: 7046305

Modified date: 05 January 2017


Translate this page: