IBM Support

What's new with IBM DB2 Analytics Accelerator for z/OS V5.1.0

Product documentation


This document contains a brief description of the new functions shipped with each maintenance level of version 5.1.0


What's new with maintenance level PTF-6

  1. Add-column support for replicated tables
    Feature description
    Replicated tables can now be synchronized using the IBM DB2 Analytics Accelerator Studio or the stored procedure SYSPROC.ACCEL_SYNCHRONIZE_SCHEMA. Thus there is no need anymore to remove, add again and reload the table when a new column is being added. This feature complements the corresponding support of non-replicated tables introduced with maintenance level PTF-5.
    Please find further information in the Knowledge Center.
  2. Hybrid Transactional Analytical Processing (HTAP) - currently Technical Preview only
    Feature description
    When using HTAP it is guaranteed that the result set of queries takes all transactions into account that have been committed at the point-in-time the query is run.
    Please find further information in the Knowledge Center.
    The new HTAP feature is currently only supported with DB2 Version 11. If you plan to use it, you must also install the following PTFs:
  3. Secure FTP support for Call-home
    Feature description
    Security enhancement to protect z/OS user passwords and content in the context of automatic opening of a PMR using call-home.
    Please find further information in the Knowledge Center.
  4. Federation (now also supported for DB2 12 for z/OS)
    Feature description
    Queries can reference tables of another DB2 subsystem paired to the same accelerator.
    Please find further details here.
    The federation feature requires the following PTFs:
    Db2 Version 11: PTF UI48595 (APAR PI77826)
    Db2 Version 12: PTF UI54293 (APAR PI91620)
    in combination with IDAA-PTF UI55928 (APAR PI94666)

What's new with maintenance level PTF-5

  1. Add-column support for non replicated tables
    Feature description
    Columns can be added to existing accelerator-shadow tables.
    Please find further details here.
  2. Multi row insert
    Feature description
    Faster loading of data into accelerator-only tables by supporting multi row insert in application programs.
    Please find further details here.
  3. Federation (DB2 11 for z/OS only)
    Feature description
    Queries can reference tables of another DB2 subsystem paired to the same accelerator.
    Please find further details here.

What's new with maintenance level PTF-4

  1. Restoring archived partitions from different accelerators
    Feature description
    Table partitions that are archived on more than one Accelerator can now be restored to all accelerators that they were archived from, either by calling the ACCEL_RESTORE_ARCHIVE_TABLES stored procedure for each accelerator or by using the Storage Saver function from IBM DB2 Analytics Accelerator Studio. Until now, you could not restore a partition from a second accelerator. The operation failed with message AQT10422.
    Additional information
    Only the first call from the first accelerator restores the data back to DB2 by using the associated image copies. The following calls for the remaining accelerators just correct the catalog information for and on the remaining accelerators.
  2. Multi-row inserts (beta version)
    Feature description
    Multi-row inserts are now supported. This allows faster inserts into an accelerator-only table (AOT) through JDBC, ODBC, or local SQL applications. This feature is still in beta state.
    Additional information
    How to enable multi-row-inserts:
    1. Activate (apply) the accelerator software for version 5.1 PTF-4.
    2. Apply the DB2 for z/OS fix (PTF) for APAR PI66753.
    3. Run an application that inserts multiple rows into an AOT. Make sure to use the correct syntax for JDBC, ODBC, or your local SQL applications.
    For more information on the INSERT read here                                  
  3. Changing the IP address or the TCP/IP port of the Capture Agent
    Feature description
    If incremental updates are enabled for a DB2 subsystem, and the IP address or the TCP/IP port of the Capture Agent on z/OS changed afterwards, then you can now specify the new address or port on the accelerator without having to stop and restart incremental updates to make the change take effect. Incremental updates continue immediately after the change.
    Additional information
    To specify a new IP address or TCP/IP port from the DB2 Analytics Accelerator Console, select: Manage Incremental Updates -> Change Capture Agent IP address and TCP port on z/OS

What's new with maintenance level PTF-3

  1. Load performance improvements when loading small tables
    Feature description
    The load performance was significantly improved for cases in which many load operations are executed in parallel and each load operation contains just one or only a few small tables.

What's new with maintenance level PTF-2

  1. Alerts to incremental update outages
    Feature description
    New DSNX messages alert users to outages of the incremental update function and give hints on how to recover from these outages. The new messages use the IDs 3004 through 3007. In addition, some of the former ID 20 messages have now been given separate IDs from 3000 through 3003. For compatibility reasons, these messages remain ID 20 messages in this release, but are marked as deprecated. ID 20 is used for InfoSphere Change Data Capture (CDC) messages that are passed to the DB2 log. They can be informational messages, warnings or error messages. Do not use the information in ID 20 messages to start programs or actions automatically because these messages might not take the overall system state into account. Instead, use the messages with the IDs from 3000-3999 for automatic actions because these messages include information about the overall system state.
    Additional information
    For more information, see chapter 7 in the Users's Guide and the technote at: Structure of DSNX881I Messages
  2. Support DB2 local dates in the format YYYYMMDD (padded with two blanks)
    Feature description
    Customers can run queries with date expressions that use this local date format as their point of reference. Such queries might be found in existing applications.
    Additional information
    To enable the new date format, set the ZPARM QUERY_ACCEL_OPTIONS = 7 and install the DB2 user exit with this local date format. Note that your version of the Netezza Platform Software (NPS) must be or later.

What's new with V5.1.0 GA

  1. Support for temporal DB2 tables (tables with system or business period definitions)
  2. Support for encryption of data at rest and encryption of data in motion
  3. In-database analytics capabilities enable the acceleration of predictive analytics applications. This way, SPSS and Netezza Analytics data mining and in-database models can be processed on an accelerator.
  4. In-database transformation supports the consolidation of ETL/ELT processing in DB2 for z/OS, resulting in a more cost-effective, simplified architecture.
  5. Support for accelerator-only tables
  6. Serves statistics and analytics tools that use temporary data for reports. The high velocity of execution enables these tools to gather all required data quickly.
  7. Accelerates SQL data transformations.
  8. Installation enhancements
  9. The environment variable AQT_INSTALL_PREFIX has been dropped.
    The update transfer function has been simplified. It now uses no more than one environment variable: AQT_HOST_PACKAGE_DIRECTORY. Specify an absolute path as the value of this variable. Note that it must not be empty because otherwise, the software transfer function does not work.
  10. The new installation program AQTTRIN simplifies installation because it automatically detects the DB2 version and already present DB2 objects. It only installs missing objects or modifies objects not yet in the proper state.
  11. By default, only the most recent software packages are kept in the hierarchical file system (HFS) when SMP/E updates are applied.
  12. Load and continuous operation improvements in the incremental update function
  13. Improved backward compatibility during the installation. Stored procedures can now be at a higher level than accelerator software, which facilitates software updates.
  14. Improved serviceability through the automatic call-home capability

Document information

More support for: DB2 Analytics Accelerator for z/OS

Software version: 5.1.0

Operating system(s): z/OS

Reference #: 7050101

Modified date: 11 June 2018

Translate this page: