Netezza Performance Server 11.2.1.3 release notes

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

Version 11.2.1.3 provides a stability patch for critical issues.

Known issues

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

Postgres

Fixed the issue with running a subquery within a memory hash join that resulted in SPU crashes.
Fixed the issue of having an external table query with an empty file as input to avoid a crash.
Fixed the issue with using nzevent with a non-admin user.
Fixed the postmaster crash due to setting the default value multiple times for a temp table column.
Fixed the postgres crash for bridge queries with NAME, TEXT, and CHAROID.
Fixed the postgres crash for queries that have many union clauses.
Fixed the issue with the nzpassword utility storing FQDN hostnames.
Fixed the issue of describing view with the WITH clause and delimited identifiers.
Resolved performance degradation when fact table broadcast was preferred over distribution.

System management

Fixed the issue where NPS needs to be restarted manually when the container moves to another node.
Resolved the issue with backup hangs occurring due to the packet sizes being greater than 9000.
Resolved the issue with query hangs occurring on cloud systems due to buffered packet handling.
Fixed a hang issue of fcommrtx threads trying to acquire memory while sending packets.
Fixed the issue with log collections when SPU restarts.

Backup and restore

Event management

Security