Netezza Performance Server 11.0.5.0 release notes

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

Version 11.0.5.0 introduces several stability fixes.

Enhancements and improvements

  • Added nzspupart -spare support. This option shows information about SPARE partitions. For more details, see Thr nzspupart command.
  • NFS mounts, cronjob, SQL Toolkit license file, bashrc, custom users/passwords, LDAP configuration and sshd keys are now preserved during container upgrade.
  • After connecting with the root user, the Netezza Performance Server prompt is now #.
  • The ipsnfs service handles tabs in /etc/fstab. For details, see Mounting NFS share to the host container.
  • Added diagnostic support for kernel crash dump.
  • Added diagnostics for disk issues.

Resolved issues

Upgrade stability
  • Fixed the issue with the REST server not starting together with the container.
  • Fixed the issue with SPUs not getting IPs when dnsmasq was bound to interface alias created on top of an Netezza Performance Server fabric IP.
  • Fixed the Cannot specify both -o and -r options upgrade error.
  • Added rpm dependencies for lgtoclnt and Kerberos.
SPU kernel stability
  • Introduced stability fixes from the upstream Linux kernel. This addresses some of the page handling issues.
System resiliency
  • Fixed the CLI performance issues which occurred while regen was in progress.
  • Fixed the ERROR: Too many open files error by setting user soft limit values.
  • Fixed the issue related to massive query aborts which was caused by a double mount problem with /dev/shm.
  • Fixed the issue with all disks of a failed SPU not being marked for failover which resulted in SPU crashes.
  • Fixed the issues related to handling different vendor disks during regen.
  • Added support to get Netezza Performance Server online if an SPU is unreachable.
SQL stability
  • Fixed the SPU crash which occurred when unloads were aborted.
  • Fixed the Precision range error error for SELECT FROM VIEW which occurred after backup and restore to Netezza Performance Server.
  • Fixed the wrong result issue which occurred when a query involved timestamp arithmetic.
  • Fixed the broken stored procedure execute as owner feature.
  • Fixed the grant help option and functionality for ROLE.
  • Fixed the issue with view definition causing issues in backup/restore. This was a result of missing precision and scale information.
  • Fixed the issue with Groom table <table_name> query versions crashing after the alter table sequence in which columns are added in the table.
  • Fixed the issue with history config event failing due to special characters in query.
  • Fixed the issue with nzrestore -disableGroom failing and the ERROR: NUMERIC precision 0 must be between 1 and 38" when col is having numeric 0.0”. error.
  • Fixed the Memory exhausted in AllocSetAlloc error which occurred while transferring large catalog objects during nzstart.
  • Fixed the postgres crash which occurred when refreshing cache with cross db references.
  • Fixed the ERROR: _bt_orderkeys: key(s) for attribute 1 missed error which occurred after executing ALTER USER.
  • Resolved the performance issue after OID rollover which was caused by a large sized catalog.
Netezza Performance Server resource monitoring
  • Fixed the issues which caused the rest server to stop abruptly.
  • Fixed the issue with event information gathering from Netezza Performance Server which was caused by a bug in parsing the JSON format.