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

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	MTM
1	IBM zEnterprise® 196 (z196) or IBM zEnterprise® 114 (z114) or IBM zEnterprise EC12 (zEC12)	2817
		2818
		2827
	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
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: IBM Data Studio Version 3.1 system requirements	Depends on manufacturer

Networking

For the data network between the IBM zEnterprise System and the PureData System for Analytics or Netezza 1000 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:

Quantity	Product	Location	P/N
1	OSA-Express3 10 GbE (dual port)	IBM zEnterprise System	(*)
or
1	OSA-Express4S 10 GbE (single port)	IBM zEnterprise System	(*)
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 the PureData System for Analytics or Netezza 1000 appliance:

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.13	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
	Data Facility System Managed Storage Base (DFSMSdfp)	HDZ1D10
	Communications Server IP	HIP61D0
z/OS Version 1.12	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
	Data Facility System Managed Storage Base (DFSMSdfp)	HDZ1C10
	Communications Server IP	HIP61C0
z/OS Version 1.11	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
	Data Facility System Managed Storage Base (DFSMSdfp)	HDZ1B10
	Communications Server IP	HIP61B0

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, V3.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.DB2.AnalyticsAccelerator.V3R1. 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, V3.1.

Database management system	Required PTFs and features	Program number
DB2 for z/OS Version 10.1 NFM (New Function Mode)	MLC or Value Unit Edition	5605-DB2 5697-P31
	UK83402 UK90809
	DB2 Utility Suite for z/OS Version 10.1	5655-V41, FMID JDBAA1K
	DB2 Java™ Database Connectivity/SQL Java For T4 drivers--IC88719 For T2 drivers--PM65004 (jcc4.13) and PM65005 (jcc3.63)	FMID JDBAA12
	A number of DB2 supplied stored procedures must be configured. See the Installation Guide for details.
	Closed PTFs
	UK83402 UK90809 UK82841 UK82731 UK82538 UK82421 UK82333 UK81770 UK81581 UK81181 UK81139 UK81047 UK79701 UK79406 UK79404 UK79290 UK78723 UK78514 UK78215 UK77038 UK76870 UK76162 UK76106 UK76105 UK76104 UK76103 UK75294 UK57366 UK83088 UK82408 UK81899 UK79243 UK74929 UK61350 UK61346 UK83171 UK82006 UK79447 UK78575 UK70508 UK66427 UK61349 UK60236 UK82494 UK79829 UK82115 UK78127 UK77366 UK74520 UK74308 UK74175 UK72212 UK71352 UK69328 UK68627 UK68364 UK62151 UK61345 UK81900 UK80357 UK81725 UK83168 UK83114 UK83220 UK83462 UK83312 UK83463 UK83965 UK78774 UK90219 UK83649 UK92059 UK92156

IBM DB2 Analytics Accelerator for z/OS

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

IBM DB2 Analytics Accelerator	Date Available	Required PTFs and features
IBM DB2 Analytics Accelerator Version 3.1 PTF 1	11/30/2012	UK83573 prerequisite (UK83711) requisite (UK83533,UK83532,UK83530)
IBM DB2 Analytics Accelerator Version 3.1 PTF 2 Upgrade from Version 3.1 PTF1	04/30/2013	UK93569, UK93568, UK93624
IBM DB2 Analytics Accelerator Version 3.1 PTF 2 New installation	04/30/2013	UK93569, UK93568, UK93624 prerequisite (UK83530, UK83711)

Minimum space settings in SMP/E for installation of UK83573 and prerequisite PTFs
Due to the size of the PTFs the following minmum space settings in SMP/E are required:
1. temporary data set SYSUT1 in in target, distribution and global zones: SPACE=(CYL,(100,20)).
2. work data set SYSWRK6 in target and distribution zones: SPACE=(CYL,(1000,500,10)).
3. SYSMOD repository SMPPTS: SPACE=(3120,(410000,40000,300),,,ROUND)
4. distribution library AAQTHFS: SPACE=(CYL,(1000,500,5)).


Required JDBC Driver level for IBM DB2 Analytics Accelerator

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.1413.64.106	3.63.141	3.64.106
IBM Data Server Driver for JDBC and SQLJ (db2jcc4.jar)4.13.1454.14.113	4.13.145	4.14.113

Older versions of the driver may allow connections to DB2 for z/OS but might fail for results from certain timestamp column definitions.

You may check the version of your JDBC driver using the following command:
java com.ibm.db2.jcc.DB2Jcc -version

Netezza Database management software

Use the following supported database management software on your the PureData System for Analytics or Netezza 1000 appliance as indicated in the following table.

IBM Puredata System for Analytics or IBM Netezza 1000	Version	Applicable DB2 Analytics Accelerator PTF
IBM Netezza Platform Software	Release 6.0.8 P2	PTF 1
IBM Netezza Platform Software	Release 6.0.8 P6	PTF 2

Incremental Update

IBM DB2 Analytics Accelerator comes with a version of IBM InfoSphere Change Data Capture for z/OS included in the product package. The followingChange Data Capture for z/OS PTFs are needed for the Incremental Update feature of DB2 Analytics Accelerator:

Incremental Update	Version	Required PTFs and features
IBM InfoSphere Change Data Capture for z/OS	Version 6.5.0	UK82885 UK83105

The CDC for z/OS Installation Guide can be accessed under the following links:

• Hardcopy (pdf) version: https://www-01.ibm.com/support/docview.wss?uid=swg27022987

html version: http://publib.boulder.ibm.com/infocenter/cdc/v6r5m1/topic/com.ibm.cdcdoc.cdcforzos.doc/concepts/ibminfospherechangedatacaptureinstallationorupgrade.html

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 V3.1.1 or Data Studio V3.2.

Instead of installing IBM DB2 Analytics Accelerator Studio from the product DVD, you can also install and donwload IBM DB2 Analytics Accelerator Studio V3.1 with Data Studio client V3.2. Both products are free of charge and can be downloaded from http://www.ibm.com/developerworks/downloads/im/data/ . For installation details see document How to install IBM DB2 Analytics Accelerator Studio V3.1 with Data Studio V3.2 .

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.

Version of Accelerator Server Software	Required DB2 Analytics Accelerator Studio (client) Software
IBM DB2 Analytics Accelerator Version 3.1 PTF 1	IBM DB2 Analytics Accelerator Studio 3.1.0 or higher
IBM DB2 Analytics Accelerator Version 3.1 PTF 2	IBM DB2 Analytics Accelerator Studio 3.1.2 or higher

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

The following combinations are supported:

(Note: IBM recommends that Customers running IDAA Studio on older versions of Data Studio should move to Data Studio Client 3.2)

• Data Studio 3.1.1 Administration Client
• Data Studio 3.1.1 Full Client

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 3.1 Installation Guide, Chapter "Updating IBM DB2 Analytics Accelerator Studio from another product"

For silent installations refer to the Data Studio Administration Client document for silent installation

Running IBM DB2 Analytics Accelerator 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: