Prerequisites and Maintenance for IBM DB2 Analytics Accelerator for z/OS Version 2.1.0

Product documentation


Abstract

Hardware and software requirements for installing IBM® DB2® Analytics Accelerator for z/OS®

Content

For Prerequisites and Maintenance information for Version 3.1.0 see this technote

Important:
The information on this page is subject to change. Make sure that you always refer to the most recent version on the web before installing the product.

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
IBM zEnterprise® 114 (z114)
or
IBM zEnterprise EC12 (zEC12)
2817
2818
2827
1 IBM Netezza® 1000-3 with North American power 5725-E46
or
IBM Netezza® 1000-3 with European power 5725-E47
or
IBM Netezza® 1000-6 5725-E48
or
IBM Netezza® 1000-12 5725-E49
or
IBM Netezza® 1000-18 5725-E50
or
IBM Netezza® 1000-24 5725-E51
or
IBM Netezza® 1000-36 5725-E52
or
IBM Netezza® 1000-48 5725-E53
or
IBM Netezza® 1000-72 5725-E54
or
IBM Netezza® 1000-96 5725-E55
or
IBM Netezza® 1000-120 5725-E56
or
IBM PureData® System for Analytics N1001-002 with North American power 5725-E46
or
IBM PureData® System for Analytics N1001-002 with European power 5725-E47
or
IBM PureData® System for Analytics N1001-005 5725-E48
or
IBM PureData® System for Analytics N1001-010 5725-E49
or
IBM PureData® System for Analytics N1001-015 5725-E50
or
IBM PureData® System for Analytics N1001-020 5725-E51
or
IBM PureData® System for Analytics N1001-030 5725-E52
or
IBM PureData® System for Analytics N1001-040 5725-E53
or
IBM PureData® System for Analytics N1001-060 5725-E54
or
IBM PureData® System for Analytics N1001-080 5725-E55
or
IBM PureData® System for Analytics N1001-100 5725-E56
or
IBM PureData System for Analytics N2001-005 5725-I26
or
IBM PureData System for Analytics N2001-010 5725-I27
or
IBM PureData System for Analytics N2001-010
with 3-Phase Delta Power
5725-I28
or
IBM PureData System for Analytics N2001-020 5725-I29
or
IBM PureData System for Analytics N2001-020
with 3-Phase Delta Power
5725-I30
or
IBM PureData System for Analytics N2001-040 5725-I31
or
IBM PureData System for Analytics N2001-040
with 3-Phase Delta Power
5725-I32
1 Workstation (Intel® or compatible) for IBM DB2 Analytics Accelerator Studio. This workstation must have connectivity to the zEnterprise system. For the hardware and software requirements of this workstation, see: System requirements for IBM Data Studio Version 2.2.x (stand-alone package) Depends on manufacturer

Networking

For the data network between the IBM zEnterprise System and the Netezza appliance, a dedicated physical network connection is required.

Minimum network configuration

The minimum network configuration is only supported for Test and Development scenarios without any high availability requirements. This configuration should not be used in a production environment. The minimum network configuration requires the following components:
Heads up: a 300 meter distance limit for 10 GbE SR connections requires OM3 fiber optic cables. Other types support less distance

Quantity
Product
Location
P/N
1 OSA-Express3 10 GbE (dual port) IBM zEnterprise System (*)
or
1 OSA-Express4S 10 GbE (single port) z196 or z114 (*)
or
OSA-Express5S 10 GbE zEC12 or zBC12
and
1 10 GbE SFP+ Switch
(e.g.
IBM RackSwitch G8264
IBM RackSwitch G8124E)
Network (**)
3 Optical Fiber Cables Network
(*) IBM/BNT® 10Gb SFP+ Optical Transceiver Switch (*)

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 or PureData System for Analytics N2001:
Quantity
Product
Location
P/N
2 OSA-Express 10 GbE IBM zEnterprise System (*)
8 Optical Fiber Cables Network
2 10 GbE SFP+ Switch
(e.g.
IBM RackSwitch G8264
IBM RackSwitch G8124E)
Network (**)
(*) IBM/BNT® 10Gb SFP+ Optical Transceiver Switch (*)

(*) For Details about supported OSAExpress 10GbE cards and required type and numbers of Transceivers see the following technote.

(**) For details about why a direct network connection does not provide automatic fail-over and hence at least one switch is needed, see the following technote

Software requirements

See the following sections for information about the software that is required to run IBM DB2 Analytics Accelerator for z/OS.

Operating systems

Use one of the supported System z® operating systems as indicated in the following table. Make sure that mandatory program temporary fixes (PTFs) and features are installed. Optional features are marked as such.
Operating system
Required PTFs and features
Program number
z/OS Version 1.12 or higher XML Toolkit for z/OS, V1.10.0 5655-J51, FMID HXML 1A0
IBM Ported Tools for z/OS V1.2.0 (OpenSSH server with AllowTcpForwarding or OpenSSH client + OpenSSH server) 5655-M23, FMID HOS1120
z/OS Version 1.11.x UA52960
(BSAM PTF for XSAM, which supports FIFO to IBM Smart Analytics Optimizer, PTF for APAR OA31256)
UA51767
(WLM not starting enough server address spaces, PTF for APAR OA31018)
XML Toolkit for z/OS, V1.10.0 5655-J51, FMID HXML 1A0
IBM Ported Tools for z/OS V1.2.0 (OpenSSH server with AllowTcpForwarding or OpenSSH client + OpenSSH server) 5655-M23, FMID HOS1120

Database management software

Use one of the supported database management systems on your System z server as indicated in the following table. Make sure that required program temporary fixes (PTFs) and features are installed. Optional features are marked as such.

To assist you in determining if you have the recommended service for IBM DB2 Analytics Accelerator for z/OS, V2.1 installed on your system, you can 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 file directly from http://service.software.ibm.com/holdata/390holddata.html. 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.Device.Appliance.Netezza-1000.IDAA.V2R1. The report will identify any missing PTFs associated with that category on that system. For complete information about the SMP/E REPORT MISSINGFIX command, see SMP/E Commands (http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/GIMCOM50/CCONTENTS?SHELF=gim2bk90&DN=SA22-7771-15&DT=20110523141208).
  3. Periodically you should acquire the latest HOLDDATA file and rerun the REPORT MISSINGFIX command to determine if there are any new recommended PTFs for IBM DB2 Analytics Accelerator for z/OS, V2.1.
Database management system
Required PTFs and features
Program number
DB2 for z/OS Version 9.1 MLC
or
Value Unit Edition
5635-DB2
5697-P12
DB2 Utility Suite for z/OS Version 9.1 5655-N97, FMID JDB991K
DB2 Java™ Database Connectivity/SQL Java FMID JDB9912
Recommended PUT Level 1202
UK56634
(APAR PK96023: ENABLE UNLOAD UTILITY TO USE LARGE BLOCK INTERFACE WHEN THE OUTPUT (SYSREC) IS A USS NAMED PIPE.)
A number of DB2 supplied stored procedures must be configured. See the Installation Guide for details.
DB2 for z/OS Version 10.1 MLC
or
Value Unit Edition
5605-DB2

5697-P31
DB2 Utility Suite for z/OS Version 10.1 5655-V41, FMID JDBAA1K
DB2 Java™ Database Connectivity/SQL Java FMID JDBAA12
A number of DB2 supplied stored procedures must be configured. See the Installation Guide for details.

Closed PTFs (DB2 for z/OS Version 9.1)
APAR
PTF
PUT level *¹
RSU
PM40117 UK71068 1109 1112
PM45145 UK71068 1109 1112
PM48429 UK72392 1110 1203
PM45482 UK73661 1111 1203
PM45483 UK73647 1111 1203
PM50764 UK73661 1111 1203
PM51075 UK73647 1111 1203
PM45829 UK73184 1111 1112
PM51150 UK75330 1201 1206
PM54508 UK76160 1202 1203
PM53634 UK76161 1202 1206
PM56492 UK76157 1202 1203
PM58224 UK76989 1203 1204
PM57643 UK77399 1204 1209
PM58732 UK77858 1204 1209
PM59818 UK77377 1204 1205
PM59393 UK78775 1205 1209
PM61161 UK78287 1205 1206
PM63022 UK78887 1206 1209
PM60170 UK79405 1206 1209
PM64912 UK79590 1206 1207
PM67130 UK80358 1207 1209
PM66388 UK80822 1208 1212
PM65524 UK80440 1208 1209
PM72956 UK82623 1210 1303
PM71856 UK82422 1210 1303
PM72264 UK83461 1211 1303
PM70287 UK83221 1211 1212
PM71930 UK83403 1211 1303
PM73634 UK90235 1212 1301
PM72913 UK90445 1212 1303
PM73214 UK90220 1212 1303
PM75890 UK83650 1212 1303
PM80766 UK91596 1302 1306
PM81268 UK92060 1303 1306
PM85786 UK93817 1305
PM86043 UK95048 1306
PM87554 UK95831 1307
PM87668 UK95798 1307 1308
PM89587 UK96627 1308
PM93746 UK97053
PM92807 UK96953
PM92293 UK96949
*1 the above PUT level is only for information it is not required to install the complete PUT Level


Closed PTFs (DB2 for z/OS Version 10.1 NFM (New Function Mode) )
APAR
PTF
PUT level *¹
RSU
PM45829 UK73183 1111 1112
PM50434 UK76103 1202 1112
PM50435 UK76104 1202 1206
PM50436 UK76105 1202 1206
PM50437 UK76106 1202 1206
PM51918 UK76107 1202 1206
PM57643 UK77398 1204 1209
PM58732 UK77857 1204 1209
PM59818 UK77376 1204 1205
PM59393 UK78774 1205 1209
PM61161 UK78286 1205 1206
PM60820 UK78215 1205 1209
PM63022 UK78886 1206 1209
PM60170 UK79404 1206 1209
PM64912 UK79589 1206 1207
PM64396 UK79290 1206 1207
PM67130 UK80357 1207 1209
PM65524 UK80439 1208 1209
PM66983 UK80823 1208 1212
PM60921 UK81770 1209 1212
PM70302 UK81725 1209 1210
PM71856 UK82421 1210 1303
PM69968 UK81900 1210 1211
PM70287 UK83220 1211 1212
PM71930 UK83402 1211 1313
PM72265 UK83462 1211 1303
PM72913 UK90444 1212 1303
PM73214 UK90219 1212 1303
PM75890 UK83649 1212 1303
PM75917 UK83965 1212 1303
PM73636 UK90809 1301 1302
PM80766 UK91595 1302 1306
PM81268 UK92059 1303 1306
PM81418 UK92156 1303 1306
PM81632 UK92099 1303 1306
PM85786 UK93816 1305
PM86043 UK95047 1306
PM87554 UK95830 1307
PM87668 UK95797 1307 1308
PM89587 UK96625 1308
PM92807 UK96951
PM92293 UK96935
*1 the above PUT level is only for information it is not required to install the complete PUT Level

IBM DB2 Analytics Accelerator for z/OS



Install the IBM DB2 Analytics Accelerators software and apply the latest DB2 Analytics Accelerator PTFs in addition to the DB2 for z/OS PTFs. The DB2 Analytics Accelerator PTFs include the DB2 Analytics Accelerator libraries and stored procedures.

IBM DB2 Analytics Accelerator, Version 2.1
Build label
Program number
Date available
Required PTFs and features
PTF 1
5697-SAO
11/12/01
APAR
PTF
PM50253 UK73729
PTF 1A
5697-SAO
12/02/02
APAR
PTF
PM55646 UK75648
PTF 2
5697-SAO
12/03/01
APAR
PTF
PM52335 UK75994
PTF 2a
5697-SAO
12/05/02
APAR
PTF
PM60626 UK77744
PTF 3
5697-SAO
12/07/02
APAR
PTF
PM57960 UK78362
PTF 4 Server: 2.1.4.20120927-1452
Stored procedures: 2.1.4.20120919-1628
5697-SAO
12/10/24
APAR
PTF
PM69574 UK82772
PM70728 UK82580
PM75395 UK82772
PTF 5 Server: 2.1.5.201212101950
Stored procedures: 2.1.5.20121130-1131
5697-SAO
13/02/04
APAR
PTF
PM75749 UK90859
PTF 6 Server: 2.1.5.201306131153
Stored Procedures: 2.1.5.20130610-1548
5697-SAO
13/06/30
APAR
PTF
PM76973 UK95393
PTF 7 Server: 2.1.5.201309061502
Stored Procedures: 2.1.5.20130823-1344
5697-SAO
13/09/30
APAR
PTF
PM94290 UK97786

Netezza Database management software

Use the following certified Netezza Performance Server (NPS) version on your PureData System for Analytics N1001 appliance as indicated in the following table.
If more then one NPS version is certified it is recommanded to upgrade to the highest certified version.

PureData System for Analytics N1001
Applicable DB2 Analytics Accelerator PTF
NPS Version
IBM Netezza Platform Software
PTF 1, PTF 1A, PTF 2, PTF 2A, PTF 3
6.0.5 P5
IBM Netezza Platform Software
PTF 4
6.0.8 P1
IBM Netezza Platform Software
PTF 5
6.0.8 P1
IBM Netezza Platform Software
PTF 6
6.0.8 P8
IBM Netezza Platform Software
PTF 7
6.0.8 P2
6.0.8 P9

IMPORTANT: If you install the IBM DB2 Analytics Accelerator for z/OS software on a PureData System for Analytics N1001 bought after December 31st, 2013 then use the following certified Netezza Performance Server (NPS) version as indicated in the following table

IBM Puredata System for Analytics
N1001
Applicable DB2 Analytics Accelerator PTF
NPS Version
IBM Netezza Platform Software
any
7.0.2 P9

Use the following certified Netezza Performance Server (NPS) version on your PureData System for Analytics N2001 appliance as indicated in the following table.If more then one NPS version is certified it is recommanded to upgrade to the highest certified version.

IBM PureData System for Analytics N2001
Applicable DB2 Analytics Accelerator PTF
Version
IBM Netezza Platform Software
PTF 6
7.0.2 P3
IBM Netezza Platform Software
PTF 7
7.0.2 P6

IBM DB2 Analytics Accelerator Studio

IBM DB2 Analytics Accelerator Studio is the graphical administration interface for the product and is delivered on the product DVD. It consists of a set of Eclipse plug-ins that are added to IBM Data Studio Administration Client 3.1.1.

IBM DB2 Analytics Accelerator Studio (client) must be at the same or newer level as the DB2 Analytics Accelerator Software (server). It is recommended to upgrade the client first. You can use a Version 3 client to connect to a version 2 server

Version of Accelerator Server Software
Required DB2 Analytics Accelerator Studio (client) Software
IBM DB2 Analytics Accelerator Version 2.1 PTF 1 IBM DB2 Analytics Accelerator Studio 2.1.0 or higher
IBM DB2 Analytics Accelerator Studio 3.1.0 or higher
IBM DB2 Analytics Accelerator Version 2.1 PTF 2 IBM DB2 Analytics Accelerator Studio 2.1.2 or higher
IBM DB2 Analytics Accelerator Studio 3.1.0 or higher
IBM DB2 Analytics Accelerator Version 2.1 PTF 3 IBM DB2 Analytics Accelerator Studio 2.1.3 or higher
IBM DB2 Analytics Accelerator Studio 3.1.0 or higher
IBM DB2 Analytics Accelerator Version 2.1 PTF 4 IBM DB2 Analytics Accelerator Studio 2.1.4 or higher
IBM DB2 Analytics Accelerator Studio 3.1.0 or higher
IBM DB2 Analytics Accelerator Version 2.1 PTF 5 IBM DB2 Analytics Accelerator Studio 3.1.0 or higher *)
IBM DB2 Analytics Accelerator Version 2.1 PTF 6 IBM DB2 Analytics Accelerator Studio 3.1.0 or higher *)
IBM DB2 Analytics Accelerator Version 2.1 PTF 7 IBM DB2 Analytics Accelerator Studio 3.1.0 or higher *)

Instead of installing IBM DB2 Analytics Accelerator Studio from the product DVD, you can also add the plug-ins to an existing IBM Data Studio 3.1.1 Administration Client or IBM Data Studio 3.1.1 Full Client installation. Both IBM Data Studio products are free of charge and can be downloaded from here

In addition, you can install the plug-ins into a shell-sharing environment. Shell-sharing means that several products share the same Eclipse instance. The following combinations are supported:

  • IBM Optim™ Query Workload Tuner 2.2.1 plus IBM Optim Database Administrator 2.2.3
  • IBM DataStudio 2.2.1.1 IDE plus IBM Optim Query Workload Tuner 2.2.1
  • IBM DataStudio 2.2.1.1 IDE plus IBM Optim Database Administrator 2.2.3
The plug-ins and fixes to IBM DB2 Analytics Accelerator Studio are available from the following download site:
http://public.dhe.ibm.com/ibmdl/export/pub/software/data/db2/analytics-accelerator-studio
The procedure to upgrade these products with IBM DB2 Analytics Accelerator Studio are described in the IBM DB2 Analytics Accelerator for z/OS Version 2.1 Installation Guide, Chapter "Updating IBM DB2 Analytics Accelerator Studio from another product"

Running IBM DB2 Analytics Accelerator Studio Studio on Linux

IBM DB2 Analytics Accelerator Studio uses the Eclipse SWT Browser Control for some Software Update dialogs.

To run IBM DB2 Analytics Accelerator Studio on Linux you must therefore install a compatible Mozilla/XulRunner. IBM DB2 Analytics Accelerator Studio 3.1 supports

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

See the Eclipse FAQ Entry for Eclipse 3.6 on

http://www.eclipse.org/swt/faq.php#browserlinux

Migration scenarios

You can upgrade or downgrade IBM DB2 Analytics Accelerator for z/OS as indicated in the following diagram.

Every colored box describes one V2 PTF with the supported DB2 version.
To find out which certified database management software (NPS) is needed please refer the tables "Database management software" above.

How to read the migration graphic
Identify your current IBM DB2 Analytics Accelerator version in the below graphic and the target version you want to migrate to.
Take the shortest path between your current and your target version by following the arrow of the same color of the current version.


Original publication date

2011/10/11

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 Analytics Accelerator for z/OS

Software version:

2.1.0

Operating system(s):

z/OS

Reference #:

7022331

Modified date:

2014-09-26

Translate my page

Machine Translation

Content navigation