Netezza Performance Server 11.0.4.1 release notes

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

Version 11.0.4.1 introduces new enhancements such as a technical preview of the zstd compression support for external tables and nzbackup on same sized systems/data slices.

Note:

After a new software is released, you must upgrade your system within a month. IBM supports downgrading only to a previous version of the latest release.

Enhancements and improvements

Added a native backup and restore connector for widely popular cloud storage: AWS S3 and IBM Cloud Object Storage. For more information, see Cloud connectors and Cloud connectors examples.
Added a utility to upload/download filesystem backups from/to cloud on AWS S3 and IBM COS.
This helps PDA customers to migrate data to Netezza Performance Server through AWS S3 and IBM COS. For more information, see Migrating backups from file systems to cloud storages and from cloud storages to file systems and Examples of the nz_s3connector command.
Introduced a technical preview of the zstd compression support for external tables and nzbackup on same sized systems/data slices. The advantages of the solution are:
- Up to 40% improvement in speed.
- 25% reduction in CPU cycles.
For more information, see Compress option, External table option summary and Command syntax for nzbackup.
Added SPU Activation Support to activate a failed SPU in the system and trigger the regeneration of data for failed disks associated with that SPU.
Note: You have to check if there are any failed SPUs in the system:
1. Run the nzhw -issues command.
  If there is a failed SPU:
  1. Run nzhw -activate to activate it.
  2. Manually trigger regen by running the commands as described in The nzhw command and The nzspupart command.
Netezza Performance Server is compatible with Netbackup 8.0. For more information, see Veritas NetBackup connector.
Introduced a new NFS mount option. Use the new method as described in Mounting NFS share to the host container instead of the deprecated NFS mount option to mount a share to dir on control plane node and make it visible via the docker -v option to container. The new method persists across host failover.

Resolved issues

Fixed the issues with nzsqa memtbl reporting.
Fixed the issue with excessive memory use on SPU due to caching iSCSI target writes.
Fixed ERROR: reserve exceeded (host) : Out of memory for GROOM PAGES START and GENERATE STATISTICS.
Fixed the issue with nzrestore converting MView to View.
Fixed upgrade issues with json data types.
Fixed the replication enablement issue with the inability to add a database to replication set.
Fixed the issue with the scheduler rule getting dropped when one of the user associated with the rule was dropped.
Fixed the issue with metadata table _v_table not getting updated properly after altering table object.
Fixed the issue with cross database groom.
Fixed the Attribute T49303.ITEM_COST must be GROUPed or used in an aggregate function error.
Fixed Error: 0 : External file corrupted, file header incomplete when nz_migrate was initiated for IBM® PureData® System for Analytics to Netezza Performance Server migration).
Added help \? for \dpr to show ROLE information.
Fixed the issue with creating the same name aggregates within multiple schemas not working.
Fixed the issue with nzrestore with increment 2 failing with database error relation does not exist for vtl_rest.admin.bnr416514_49801_43777855.
Fixed issues releted to the regen performance.
Fixed performance issue for nzlocal regen.
The system is now prevented from going down in case disk is unreachable.
Fixed issues related to the regeneration of different disk partitions. Now simultaneous regen of different disk partitions on the same disk is enabled.
Fixed issues to handle regen in case of undesired abort of the regen process.
Fixed ERROR: 256 : Code generation failure caused by RHEL gcc being out of memory.
Fixed the container upgrade issue mentioning a nonexistent file in files_to_backup.conf which caused upgrade failure.
Fixed the issue with the /etc/sudoers content which occurred during the Netezza Performance Server upgrade.
Introduced a fix for emulator crashes.
Fixed the issue with Netezza Performance Server not starting automatically after the Netezza Performance Server container starts.
Added support for mounting Windows share on Netezza Performance Server through a cifs_utlils package.