Transferring update packages for the accelerator

Transfer update packages for IBM Db2 Analytics Accelerator for z/OS, the Access Server, the replication engine, or the Netezza® Platform Software (NPS®) by completing the steps in this section.

Before you begin

Make sure that the following conditions apply:
  • Suitable accelerator installation packages exist in the usr/lpp/IBM/aqt/<version>/packages directory on your z/OS data server, where <version> is a placeholder for a directory whose name indicates the product version. Update packages for the IBM Db2 Analytics Accelerator for z/OS software are named version.tar.z, where version is the first part of the package name, which indicates the version of the software. Update packages for the Access Server, the replication engine, or the Netezza Platform Software (NPS) are named differently.
  • The value of the AQT_HOST_PACKAGE_DIRECTORY environment variable determines where IBM Db2 Analytics Accelerator Studio looks for software updates. If it is not set correctly, the packages cannot be located and thus cannot be transferred or installed.
  • The user ID has read and write access to the directory that the AQT_HOST_PACKAGE_DIRECTORY environment variable points to and to all of this directory's sub-directories. You specify this variable in the AQTENV data set. The AQTENV data set must be referenced by the Workload Manager (WLM) environment that was set up for the IBM Db2 Analytics Accelerator for z/OS stored procedures. To avoid a setup with obsolete or wrong entries, use the sample AQTENV data set that comes with IBM Db2 Analytics Accelerator for z/OS Version 5.1.x.

    However, if the stored procedures are still at a previous level (version 4 or earlier), make sure that you copy the previous setting of AQT_INSTALL_PREFIX to your new AQTENV data set. It is still needed by the back-level stored procedures.

  • When you transfer an NPS update package, it is checked whether the NPS version is compatible with the installed Netezza Firmware (FDT) and Netezza Host Platform (HPF) versions. If the NPS is incompatible, you must first update the FDT, the HPF, or both. These tasks, however, can only be completed with the help of IBM support and require a downtime of about one day. So, if the NPS update is really necessary, make sure that you plan it thoroughly in advance. For more information, follow the Related information link at the end of this topic.

    Another caveat exists in connection with an NPS transfer: If the NPS package fails the compatibility check, the process ends prematurely without transferring any packages, no matter how many other packages were selected. It is therefore recommended that you first transfer packages for IBM Db2 Analytics Accelerator, the Access Server, or the replication engine, then activate these, and transfer and activate the NPS update in a later step.

About this task

The update packages are copied from the z/OS UNIX file system (zFS) to the accelerator, but are not yet activated. However, to actually use a new version, you must activate it. How to do this is described in a later topic. See the hint at the end of this topic.

Installing a software update invokes the SYSPROC.ACCEL_UPDATE_SOFTWARE stored procedure on your data server. For information about the privileges that are required to run this procedure and further details, follow the appropriate Related reference link at the end of this topic.

Procedure

  1. Start IBM Db2 Analytics Accelerator Studio.
  2. In the Administration Explorer, select the Accelerators folder.
  3. In the Object List Editor on the right, double-click the accelerator.
  4. If necessary, expand the About section.
  5. In the About section, click the Transfer updates link.
  6. In the Transfer Updates window, you can see all software packages that are available in the zFS of your z/OS data server. Select the appropriate check boxes in the first column of the table to mark the packages that you want to transfer.
    Attention: Make sure that you select the proper packages, that is, packages belonging to the release level that you want to upgrade to. The list in the Transfer Updates window might be confusing, especially if it also contains older packages. To find the correct package numbers, see the closing information or the release notes for the latest program temporary fix (PTF). You find the closing information or the release notes for a PTF on the support home page, in the category Plan and install documentation (see link under Related information at the end of this topic). If a PTF was shipped with a major product release, then, in general, you must transfer the packages included in the PTF rather than the packages in the base version.
  7. Click Transfer to complete the installation.