Detailed System Requirements
Abstract
Hardware and software requirements for installing IBM® DB2® Analytics Accelerator for z/OS®, V5.1.0
Content
- 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.
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
-
IBM DB2 Analytics Accelerator for z/OS V5.1.0
- IBM DB2 Analytics Accelerator for z/OS - maintenance level
- Coexistence with V7
- Space settings
-
Hardware requirements
- Computers
- Networking
-
Software requirements
- Operating systems
- Database management software
- Mandatory DB2-PTFs
- Recommended DB2-PTFs
-
Netezza database management software
- Netezza database management software
- Netezza Host Platform (HPF) and Netezza Firmware (FDT)
-
Incremental update function
- Incremental update function
-
IBM DB2 Analytics Accelerator Studio
- IBM DB2 Analytics Accelerator Studio
-
Optional features
- In-database analytics
- Encryption of data in motion
-
Migration scenarios
- Migration scenarios
-
IBM Db2 Analytics Accelerator Loader
- IBM Db2 Analytics Accelerator Loader
-
Documentation
- Manuals
- IBM Documentation
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/YYYYAccelerator Server version: 5.1.9
Build date: 20220608-1007
Stored Procedures version: 5.1.9
Build date: 20220519-0715PH47874 UI81454 19 July 2022 Access Server
Core Version: 11.4.0.4.11065
Build date: 20220608-1007
Simple version: 4020101000130PH47876 UI81455 19 July 2022 Replication Engine
Core version: 11.4.0.4.5599
Build date: 20220608-1007
Simple version: 4030100001860PH47877 UI81456 19 July 2022 Netezza Platform Software
Core Version NPS: 7.2.1.11-P1 Build 4
Build date: 20220608-1007
Simple version:4040004010400PH47878 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/YYYYAccelerator Server version: 5.1.9
Build date: 20220301-1646
(Build date: 20210309-0924)Stored Procedures version: 5.1.9
Build date: 20210902-1542UI79702(UI75279)UI7803115 March 2022(11 May 2021)
13 Nov 2021Access Server
Core Version: 11.4.0.2.11016
Build date: 20200421-01500
Simple version: 4020101000120PH26769 UI70483 11 July 2020Replication Engine
Core version: 11.4.0.3.5566
Build date: 20201019-1205
Simple version: 4030100001850PH31483 UI72594 17 November 2020Netezza Platform Software
Core Version NPS: 7.2.1.10-P2 Build 5
Build date: 20210309-0924
Simple version:4040004010390PH32367 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/YYYYAccelerator Server version: 5.1.8
Build date: 20200421-1500Stored Procedures version: 5.1.8
Build date: 20191023-1705UI70178 07/06/2020 Access Server (recommended)
Core Version: 11.4.0.2.11016
Build date: 20200421-01500
Simple version: 4020101000120PH26769 UI70483 07/11/2020Access Server
Core Version: 11.4.10600
Build date: 20190531-0147
Simple version: 4020101000110PH12806
PH13007
PH14103UI64503 09/01/2019Already deliveredon top of V5 PTF7Replication Engine (recommended)
Core version: 11.4.0.3.5566
Build date: 20201019-1205
Simple version: 4030100001850PH31483 UI72594 11/17/2020Replication Engine
Core version: 11.4.0.2.5537
Build date: 20200421-1500
Simple version: 4030100001830PH20556 UI70469 07/11/2020Replication Engine update
Core version: 11.4.0.2.5128
Build date: 20190711-0033
Simple version: 4030100001820UI64504 09/01/2019Already deliveredon top of V5 PTF7Netezza Platform Software
Core Version NPS: 7.2.1.8-P2 Build 25
Build date: 20190829-1500
Simple version:4040004010380PH21678 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/YYYYAccelerator Server version: 5.1.7
Build date: 20191212-1800PH08914
PH18395
PH20337UI67051 12/17/2019 Accelerator Server version: 5.1.7
Build date: 20190118-1726
Stored Procedures version: 5.1.7
Build date: 20181126-0915PH06275 UI61027 02/04/2019 Access Server component update
Core Version: 11.4.10600
Build date: 20190531-0147
Simple version: 4020101000110PH12806
PH13007
PH14103UI64503 09/01/2019 Access Server component update
Core Version: 11.4.10600
Build date: 20181207-0000
Simple version: 4020101000100PH06276 UI6102102/04/2019 Replication Engine update component
Core version: 11.4.0.2.5128
Build date: 20190711-0033
Simple version: 4030100001820UI64504 09/01/2019 Replication Engine update component
Core version: 11.4.0.1.5800
Build date: 20181025-0000
Simple version: 4030100001780PH06277 UI61020 02/04/2019 Netezza Platform Software
Core Version NPS: 7.2.1.7 Build 34
Build date: 20181011-2142
Simple version: 4040004010360PH06278 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 considerationsNote:
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/YYYYAccelerator Server version: 5.1.6
Build date: 20180109-0000
Stored Procedures version: 5.1.6
Build date: 20171109-1136PI87839 UI53528 02/03/2018 Stored Procedures
version 5.1.6 1
Build date: 20180509-1706PI94666 UI55928 05/23/2018 Access Server component update
Core Version: 11.4.0.0.10267
Build date: 20171208-1326
Simple version: 4020101000070PI87844 UI52872 02/03/2018 Replication Engine update component
Core version: 11.4.0.0.5044
Build date: 20171117-0921
Simple version: 4030100001760PI87847 UI52873 02/03/2018 Netezza Platform Software
Core Version NPS: 7.2.1.4-P3 Build 105
Build date: 20170817-1148
Simple version: 4040004010320PI87848 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: 4040004010330PI94801 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: 4040004010340PH00844 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 considerationsComponent APAR PTF Date Available
MM/DD/YYYYAccelerator Server version: 5.1.5
Build date: 20170627-0200
Stored Procedures version: 5.1.5
Build date: 20170622-1947PI77066 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-1947PI85560
PI85615UI49630 08/22/2017 Access Server component update
Core Version: 11.3.3.2.5300
Build date: 20170706-1141
Simple version: 4020100043170PI83910 UI48682 07/11/2017 Replication Engine update component
Core version: 11.3.3.3.Release_46
Build date: 20170126-0000
Simple version: 4030100001550PI75517 UI44936 02/28/2017 Netezza Platform Software
Core Version NPS: 7.2.1.4-P1
Build date: 20170627-0200
Simple version: 4040004010300PI83911 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 considerationsComponent APAR PTF Date Available
MM/DD/YYYYAccelerator Server version: 5.1.4
Build date: 20170217-1406
Stored Procedures version: 5.1.4
Build date: 20170130-1046PI75504 UI44937 02/28/2017 Access Server component update
Core Version: 11.3.3.2.5300
Build date: 20170126-0000
Simple version: 4020100043100PI75508 UI44935 02/28/2017 Replication Engine update component
Core version: 11.3.3.3 (Build Release_46)
Build date: 20170126-0000
Simple version: 4030100001550PI75517 UI44936 02/28/2017 Netezza Platform Software
Core Version NPS: 7.2.1.3-P3
Build date. 20170126-0000
Simple version: 4040004010270PI75523 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 considerationsComponent APAR PTF Date Available
MM/DD/YYYYAccelerator Server version: 5.1.3
Build date: 20161019-0001
Stored Procedures version: 5.1.2
Build date: 20160310-1108PI71144 UI42327 11/11/2016 Access Server component update
Core Version: 11.3.3.2.5300
Build date: 20161019-0001
Simple version: 4020100043060PI71146 UI42328 11/11/2016 Replication Engine update component
Core version: 11.3.3.2
(Build Release_25)
Build date: 20161019-0001
Simple version: 4030100001530PI71151 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: 4040004010240PI60233 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 considerationsComponent APAR PTF Date Available
MM/DD/YYYYAccelerator Server version: 5.1.2
Build date: 20160422-0100
Stored Procedures version: 5.1.2
Build date: 20160310-1108PI60229 UI37796 06/02/2016 Access Server component update
Core Version: 11.3.3.2.5300
Build date: 20160305-0101
Simple version: 4020100043050PI60231 UI37783 06/02/2016 Replication Engine update component
Core version: 11.3.3.2
(Build Release_25)
Build date: 20160204-0822
Simple version: 4030100001520PI60232 UI37784 06/02/2016 Netezza Platform Software
Core Version NPS: 7.2.1.2
(build 47843)
Build date: 20160405-0918
Simple version: 4040004010240PI60233 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-DA5Component APAR PTF Date Available
MM/DD/YYYYAccelerator Server version: 5.1.1
Stored Procedures version: 5.1.1
Build date: 20151217-2301
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-1532UI35012
02/09/2016 PI60730 UI37271 04/26/2016 Access Server
Version: 11.3.3.4289
Build date: 20151217-2301
Simple version: 4020100042320PI56040 UI35007 02/09/2016 Replication Engine base
Core version 11.3.3
Build BR_LSTYTHIK_96_9
Build date: 20151110-1859
Simple version: 44030100001100n/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: 4030100001410n/a n/a 11/27/2015 Netezza Platform Software 7.2.1.1
Build 46779
Build date: 20151217-2301
Simple version: 4040004010130PI56045 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-1Component APAR PTF Date Available
MM/DD/YYYYAccelerator Server version: 5.1.0
Build date: 20151110-1859
Stored Procedures version: 5.1.0
Build date: 20151117-1527n/a n/a 11/27/2015 Access Server
Core version: 11.3.3.4289
Build date: 20151112-2141
Simple version: 4020100042310n/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: 44030100001100n/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: 4030100001410n/a n/a 11/27/2015 Netezza Platform Software (NPS) 7.2.1.0
Build 46322
Build date: 20151110-1859
Simple version: 4040004010060n/a n/a 11/27/2015
Coexistence with Db2 Analytics Accelerator V7
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)
or2817 IBM zEnterprise® 114 (z114)
or2818 IBM zEnterprise® EC12 (zEC12)
or2827 IBM zEnterprise® BC12 (zBC12)
or2828 IBM z13™
Models: N30, N63, N96, NC9, or NE1
or2964 IBM z14™
Models: M01, M02, M03, M04, M053906 IBM z15™
Models: T018561 1 IBM PureData System for Analytics N1001-3
with North American power connectors 1
or5725-E46 IBM PureData System for Analytics N1001-3
with European power connectors 1
or5725-E47 IBM PureData System for Analytics N1001-6 1
or5725-E48 IBM PureData System for Analytics N1001-12 1
or5725-E49 IBM PureData System for Analytics N1001-18 1
or5725-E50 IBM PureData System for Analytics N1001-24 1
or5725-E51 IBM PureData System for Analytics N1001-36 1
or5725-E52 IBM PureData System for Analytics N1001-48 1
or5725-E53 IBM PureData System for Analytics N1001-72 1
or5725-E54 IBM PureData System for Analytics N1001-96 1
or5725-E55 IBM PureData System for Analytics N1001-120 1
or5725-E56 IBM PureData® System for Analytics N1001-002
with North American power connectors 1
or5725-E46 IBM PureData® System for Analytics N1001-002
with North European connectors 1
or5725-E47 IBM PureData System for Analytics N1001-005 1
or5725-E48 IBM PureData System for Analytics N1001-010 1
or5725-E49 IBM PureData System for Analytics N1001-015 1
or5725-E50 IBM PureData System for Analytics N1001-020 1
or5725-E51 IBM PureData System for Analytics N1001-030 1
or5725-E52 IBM PureData System for Analytics N1001-040 1
or5725-E53 IBM PureData System for Analytics N1001-060 1
or5725-E54 IBM PureData System for Analytics N1001-080 1
or5725-E55 IBM PureData System for Analytics N1001-100 1
or5725-E56 IBM PureData System for Analytics N2001-005 1
or5725-I26 IBM PureData System for Analytics N2001-010
or5725-I27 IBM PureData System for Analytics N2001-010
with 3-Phase Delta Power
or5725-I28 IBM PureData System for Analytics N2001-020
or5725-I29 IBM PureData System for Analytics N2001-020
with 3-Phase Delta Power
or5725-I30 IBM PureData System for Analytics N2001-040
or5725-I31 IBM PureData System for Analytics N2001-040
with 3-Phase Delta Power
or5725-I32 IBM PureData System for Analytics N2002-002
or5725-N24 IBM PureData System for Analytics N2002-005
or5725-N25 IBM PureData System for Analytics N2002-010
or5725-N26 IBM PureData System for Analytics N2002-020
or5725-N27 IBM PureData System for Analytics N2002-040
or5725-N28 IBM PureData System for Analytics N3001-001
or5725-S22 IBM PureData System for Analytics N3001-002
or5725-R40 IBM PureData System for Analytics N3001-005
or5725-R41 IBM PureData System for Analytics N3001-010
or5725-R42 IBM PureData System for Analytics N3001-020
or5725-R43 IBM PureData System for Analytics N3001-040
or5725-R44 IBM PureData System for Analytics N3001-080
or5725-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.1Depends on manufacturer
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 |
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 |
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. |
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. |
Mandatory DB2-PTFs
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.
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 |
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 |
Find known issues for use of IBM Db2 Analytics Accelerator for z/OS V5.1.0 with Db2 12
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:- 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. - 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 .
- 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. |
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
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:
- IBM Data Studio 4.1.4 amended by the APAR1-patch
We strongly recommend to upgrade your IBM Data Studio installation to this maintenance level using the following steps:
- 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”.
- Un-install existing Data Studio 4.1.3 (or previous version)
- Install Data Studio 4.1.4, described here
- 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.
- Install Data Studio 4.1.4 APAR1.
- Get latest version of IBM Db2 Analytics Accelerator Studio plugin.
- 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:
|
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
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
|
Documentation
See here for the entry page to the IBM Documentation of IBM Db2 Analytics Accelerator for z/OS V5.1.
- Delete list of outdated maintenance levels of DB2 Analytics Accelerator Studio; adapt link to most current maintenance level
- Mention Loader APAR PH46656 and the parallel need for installing the PTF belonging to Db2 APAR PH45948
- Adapt link to list of Loader PTFs
- New maintenance level V5 PTF-9 Update 1
- 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"
- Provide correct maintenance level of latest version of IBM Db2 Analytics Accelerator plugin'
- Maintenance level information in section for 'IBM Db2 Analytics Accelerator Loader'
- 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'
- 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
- List of supported operating systems: add z/OS 2.5, remove z/OS 2.1
- 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
- Availability of maintenance level V5PTF9
- Point to important Db2 12 maintenance: PTFs PH28050/UI71492 and PH21726/UI71209
- 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)
- V5-PTF8: Build number 27 corrected to 25 in "Core Version NPS: 7.2.1.8-P2 Build 25"
- 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
- 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 Synonym
IDAA
Was this topic helpful?
Document Information
Modified date:
13 September 2022
UID
swg27046305