Netezza Performance Server 11.2.1.11-IF1 release notes

Netezza Performance Server for Cloud Pak for Data System Version 11.2.1.11 IF1 provides fixes for critical issues.

New features and enhancements

Online redistribution
Online data redistribution addresses the potentially long outage experienced by client applications by opening up access to the data after software expansion and allowing data redistribution to proceed and with WLM (workload management) resource limits of your choice. For more details, see Online data redistribution.
Schema level backup
Added support for schema level backup where you can take a backup of only specified schemas. For more details, see Command syntax for nzbackup.
Role reversal support in NRS 3.0.x.x
Netezza Performance Server now has functionality to enable the role reversal capability in NRS 3.0.x.x. NRS release 3.0.3.0 in conjunction with this Netezza Performance Server release will now allow you to swap the role of a replica and primary for a replicated database. For more details, see Netezza Performance Server Replication Services 3.0.X.X.
ODBC driver
Added a new option for the ODBC driver:
  • ConnectionRetryCount: The number of times the driver retries connection attempts to the database server.
SSL certificate
Added feature to allow password-enabled keys in SSL certificate validation.

Resolved issues

  • Fixed an issue where nzredrexpand was failing due to nzsql notice.
  • Capturing siginfo information in SPU crash that would help to provide the address information about crash.
  • Added a check where nzredrexpand might fail if executed from node other than control node.
  • Added a check in upgrade to identify duplicate records in _t_description system table.
  • Fixed postgres crash when you try to select null date entries from view _v_user.
  • Fixed an issue where file header was missing when datatype does not match (from char to varchar) in create external table query.
  • Fixed postmaster crash for an alter sequence query on cross database. Now, query will error out as alter sequence on cross database is not allowed.
  • Fixed an issue where SQLToolKit function regexp_extracat_all was giving incorrect output for different input.
  • Fixed an issue where ODBC query with comments was failing with segmentation fault.
  • Fixed nzredr script to handle materialized views in non-admin schema.
  • Fixed an issue where alter group was failing due to null value of GROCROSSJOIN column in _t_group table.
  • Fixed an issue where nzstop getting hung after the SPU power cycle.
  • Fixed the issue of nzbackup running slow when there are large delete files.
  • Fixed the issue of nzrestore failure due to chain inconsistency.
  • Fixed the incorrect results issue with restrictions on CHAR/VARCHAR/NCHAR/NVARCHAR columns in the following two cases:
    • when a clustered table has an organizing column of one of these types.
    • when a materialized view uses a column of one of these types in its order by clause.