Netezza Performance Server 11.0.1.0 release notes

Deployment options: Netezza Performance Server for Cloud Pak for Data System

Version 11.0.1.0 introduces enhancements such as support for global temporary tables, configuration optimization, and provides fixes for known issues.

Note: Netezza Performance Server software upgrade is performed by IBM Support. Contact your IBM representative to schedule the upgrade.

Enhancements and improvements

  • Global Temporary Tables

    Global temporary tables store schemas in catalogs. By using SQL commands, you can create, identify and remove global temporary tables. For more information, see Managing global temporal tables.

  • Software Support Tools for Netezza Performance Server

    The tools are pre-installed and are the same as on IBM® PureData® System for Analytics. Small fixes are introduced in version 11.0.1.0.

Configuration optimization

  • Any valid UTF-8 codepoint is loaded or inserted into a table by default. 
    host.disableNfcGlobally = yes
  • The JIT-Stats Sample Scan queries are included in the _T_QRYSTAT / _T_QRYHIST tables by default.
    host.queryHistShowInternal = yes

    For more, see Changing configuration settings.

  • The C++ files for every snippet don't have to be stored in the limited shared memory pool.
    enable_cpp_collection = false
  • Latency based scheduler (LBS) introduced in IBM PureData System for Analytics 7.2 is disabled by default.
  • A database is created with DBTRACKCHANGES enabled by default.

Resolved issues

Version 11.0.1.0 provides stability fixes related to container deployment, Postgres, backup and restore, failover, etc.
  • Stability fixes for Geospatial functions:
    • Fixed wrong ELF class: ELFCLASS32 error for select query using ST_Distance()
    • Fixed crash for select query using ST_Transform()
    • Fixed crash for select query using ST_Intersection()
  • Node activation support

    If a SPU goes down or a failover occurs, post node activation, regeneration or rebalance is supported.

  • Host Container deployment and upgrade

    Contact IBM Support to deploy or upgrade a host container.