Netezza Performance Server 11.0.6.1 release notes

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

Version 11.0.6.1 provides a stability patch for critical issues.

Resolved issues

Fixed the issue that occurred when the CREATE EXTERNAL TABLE query was used with includeheader and alias.
Fixed the issue which caused dbos to crash during data load.
Fixed the issue with queries getting stuck in extremally concurrent read-writes on a single disk block.
Fixed upgrade error: Failed to bring IPS offline: Error: login error - LDAP authentication failed for user 'NZ_INTERNAL_TEMP_USER'.

Known issues

1. Upgrade

Upgrading from 11.0.4.1 to 11.0.6.1 with authentication set to other than local
The upgrade is successful, but a non-fatal error appears:
```
WARNING: Could not drop nz_internal_temp_user user
```
WORKAROUND:
Once the system comes online with 11.0.6.1, do the following:
1. As the nz user, run the commands inside the container:
  1. ```
  nzsql -c "update  _t_object set objowner = U.usesysid, objmodifier = U.usesysid from _t_user U where objid = 5342 and U.oid = 4900; "
```
2. ```
nzsql -c "drop user NZ_INTERNAL_TEMP_USER;"
```

Upgrading from 11.0.4.1 to 11.0.6.0

The upgrade is successful with a non-fatal error:

“WARNING: Could not drop nz_internal_temp_user user”

Use this mandatory procedure, after the system comes online with 11.0.6.0.

WORAKAROUND:

As the nz user, run the commands inside the container:

nzsql -c "update  _t_object set objowner = U.usesysid, objmodifier = U.usesysid from _t_user U where objid = 5342 and U.oid = 4900; "

nzsql -c "drop user NZ_INTERNAL_TEMP_USER;"

Upgrading from 11.0.6.0 to 11.1.0.0
nzstart returns a
```
Sysctl value for 'kernel.sem' is '128 1048576 32 32000'; must be at least '128 1048576 32 32768
```
error after upgrading the container from 11.0.6.0 to 11.1.0.0. Note that in this case Netezza Performance Server is still on 11.0.6.0.
WORKAROUND:
1. As the root user, run the commands inside the container:
```
sed -i '/^kernel.sem =/s/65535/32768/' /etc/sysctl.conf
sysctl -w kernel.sem="128 1048576 32 32768"
```
2. As the nz user, run:
```
nzstart
```

After container upgrade to 11.0.6.0 or 11.0.6.1 OR downgrading from 11.0.6.0 to 11.0.4.1, nzstart might fail with this error message:

WARNING: SELinux is configured to be started on reboot (/etc/selinux/config)
Use of uninitialized value $ENV{"NZ_REMOTE_FILE_SERVER"} in concatenation (.) or string at /nz/kit/bin/adm/nzchkhost line 415.
Use of uninitialized value in concatenation (.) or string at /nz/kit/bin/adm/nzchkhost line 415.
Use of uninitialized value in concatenation (.) or string at /nz/kit/bin/adm/nzchkhost line 415.
Use of uninitialized value in concatenation (.) or string at /nz/kit/bin/adm/nzchkhost line 415.
mount.nfs: Failed to resolve server : Name or service not known
mount.nfs: Operation already in progress
Use of uninitialized value $ENV{"NZ_REMOTE_FILE_SERVER"} in concatenation (.) or string at /nz/kit/bin/adm/nzchkhost line 417.
Use of uninitialized value in concatenation (.) or string at /nz/kit/bin/adm/nzchkhost line 417.
Use of uninitialized value in concatenation (.) or string at /nz/kit/bin/adm/nzchkhost line 417.
Use of uninitialized value in concatenation (.) or string at /nz/kit/bin/adm/nzchkhost line 417.
ERROR:  Unable to mount gpfs export: :/ipshost on /mnt/gpfs_test/

WORKAROUND:

As the nz user, run the commands inside the container:
```
mv /nz/kit.11.0.4.1/bin/adm/nzchkhost /nz/kit.11.0.4.1/bin/adm/nzchkhost.original
cp /nz/kit.11.0.6.0/bin/adm/nzchkhost /nz/kit.11.0.4.1/bin/adm/
```
Note: If you are upgrading to 11.0.6.1 or downgrading from 11.0.6.1, replace kit.11.0.6.0 with kit.11.0.6.1 in the command.
As the nz user, run:
```
nzstart
```