Netezza Performance Server 11.2.1.1 release notes

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

Version 11.2.1.1 provides a stability patch for critical issues.

Known issues

  1. Fixed-format data files that contain numeric fields might be loaded incorrectly into the database. For more information, see https://www.ibm.com/support/pages/node/6583457.

  2. 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.

Resolved issues

Postgres
  1. Fixed issues with converting unknown to numeric that resulted in dbos crashes.
  2. Fixed issues with segmentation fault for views that contain the varlena constant that resulted in dbos crashes.
  3. Fixed the nzdumpschema error Can't use an undefined value as an ARRAY reference.
  4. Added a precheck before accessing a UDX adapter while cleaning up a UDX function call.
  5. Added LDAP authentication with crypto enabled.
  6. Fixed security issues with schema level privileges.
Serviceability
  1. Updated the support tools scripts in accordance with recent catalog changes.
System management
  1. Fixed the issues with accessing core and log file name that resulted in bootsvr cores.
  2. Fixed the spucores issue that occurred after upgrade on a higher configuration (Lenovo 24 SPUs and higher, Dell 10 SPUs and higher).
  3. Removed unnecessary SCSI PFE monitoring.
  4. Fixed the LP15MonitorProcess issue for NVME drives.
  5. Empty tables during rack expansion are skipped now, which reduces data redistribution time.
Upgrade
  1. Fixed the issue with duplicate kernel.shmmax values that occurred when upgrading from versions 11.2.0.0 and lower.
  2. Fixed the performance issue that was caused by data being loaded into the _t_event_info catalog table .
  3. Added support to prevent non-upgrade processes interrupting upgrade.
  4. Fixed catalog performance issue after an upgrade to 11.2.1.1 and upcoming releases.