Netezza Performance Server 11.2.1.5 release notes

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

Netezza Performance Server 11.2.1.5 provides a stability patch for critical issues.

Note:
  1. If you are using custom SSL certificates, learn how to preserve them across Netezza Performance Server upgrade. For more information, see Preserving custom SSL certificates.
  2. If you are on Netezza Performance Server for Cloud Pak for Data, before you upgrade to 11.2.1.5, you must back up tables with a compression ratio greater than 7.95 and databases that contain these tables. After the upgrade is complete, truncate the tables from their databases and restore them. To identify tables with compression ratio greater than 7.95, follow the instructions from https://www.ibm.com/support/pages/node/6564067.

    Tables that were identified as having a compression ratio greater than 7.95 before upgrade must not be accessed until they are restored after upgrade.

    Make sure you completed the backup of the listed databases before upgrading.

  3. Learn about the preferred cipher suites, how to enable, disable the TLS 1.2 ciphers, and create and enable certificates if you are on 11.2.1.5, 11.2.2.0 and later. For more information, see TLS 1.2 ciphers.

Resolved issues

Postgres
  1. Resolved the issue with queries getting aborted after the first attempt, which was caused by No such table exists.
  2. Prevented a SPU crash in case of buffer overflow when query results are typecast to a variable length data type.
  3. Resolved the issue with nzload fixed format with data typecast.
  4. Updated the cipher list with IBM supported ciphers for TLS1.2 communication.
Backup and restore
  1. Disabled checking validity of views and mviews before a backup is taken. This option is set for nzbackup when executed by nzbatchbnr.
Connector
  1. Resolved the OLE DB connection issue with MS Azure Analysis Service.
  2. Resolved the issue with quotations in schema name with the .NET driver.
Upgrade
  1. Resolved issues with mount location and mount directories preservation after container upgrade.
  2. Resolved the issue with space being filled up with debug logs.
Even management
  1. Resolved the issue with multiple hwDiskFull alerts for each logical partition by changing implementation at system level.
Provisioning
  1. Added support to log nzdeploy and nzdeploy-remote runs using aphistory.
Serviceability
  1. Added support to start NVMe Telemetry utilities remotely and through nzpush
  2. Upgraded nvme-cli to 1.8.1 to support the mvcli utility.
  3. Added support for different SPU utilities. For example: mlxconfig, mlxfwreset, mlxlink.
System management
  1. Resolved the issue with Intel drives with locking enabled during Netezza Performance Server restart.
  2. Removed password logging from logs after keystore is created.

  3. If you are on Netezza Performance Server for Cloud Pak for Data, support to make table compression ratio configurable was added. Before you upgrade to 11.2.1.5, you must back up tables with a compression ratio greater than 7.95 and databases that contain these tables. After the upgrade is complete, truncate the tables from their databases and restore them. To identify tables with compression ratio greater than 7.95, follow the instructions from https://www.ibm.com/support/pages/node/6564067.

    Tables that were identified as having a compression ratio greater than 7.95 before upgrade must not be accessed until they are restored after upgrade.

    Make sure you completed the backup of the listed databases before upgrading.

  4. Resolved the issue with emulator memory pages resulting in SPU crashes.
  5. Added instrumentation for improved analysis of fcomm cores.
  6. Resolved the issue with fcomm while releasing buffers.
  7. Improved the regen process to handle interrupted regen due to restart.
  8. Resolved the issue with enabling locking after new disk is added.
  9. Upgraded MCP image for SPU kernel to address SPU stability.

Known issues

  1. Due to the limitation on clients, the ODBC Windows driver works only with the AES128-GCM-SHA256 cipher with hostssl set on the Netezza Performance Server host.

    To change ciphers set on the Netezza Performance Server host, see Enabling and disabling ciphers.

  2. 2. zLinux clients work only with the AES128-GCM-SHA256 cipher with hostssl set on the Netezza Performance Server host.

    To change ciphers set on the Netezza Performance Server host, see Enabling and disabling ciphers.

  3. nzrestore fails if backup is taken with BUCKET_URL having slashes.
    Whenever the nzrestore failure happens with following error:
    [Restore Server] : Starting the restore process
[Restore Server] : Operation aborted 
Error: Connector exited with error: 'The specified key does not exist. with address : xx.xxx.xx.xxx'.
    Check the backup command and verify whether BUCKET_URL is having slashes as shown in the following example:
    BUCKET_URL=bakcupbucket/subdir/
UNIQUE_ID=2024-01-12
    WORKAROUND:
    Modify BUCKET_URL and UNIQUE_ID as shown:
    BUCKET_URL=bakcupbucket 
UNIQUE_ID=subdir/2024-01-12
    Note: UNIQUE_ID is a combination of string that is taken from BUCKET_URL after the first slash and actual UNIQUE_ID. Pass these two arguments to the nzrestore command.