Netezza Performance Server 11.2.1.10 release notes

New features and enhancements

Stored procedures

Added a spi_simplify_expr flag to prevent the expression_tree_walker error from occurring.

If you set spi_simplify_expr=false and run your stored procedure, the simplification of expressions that are part of stored procedures is skipped.

For more information, see Running stored procedures and Creating stored procedures.

CREATE USER command help information

Added IDENTIFIED BY clause in the CREATE USER command, which works similarly to PASSWORD clause.

Backup and restore

Updated the number of directories that are supported for backup and restore from 16 to 30 for the -dir parameter. For more information, seeCommand syntax for nzbackup.

Resolved issues

• Fixed the issue in parsing the enclosure number while performing replace disk procedure.
• Fixed INZA installation issue when there are orphan records in _t_depend.
• Fixed the issue with providing additional attribute in JDBC for allowing maxErrors to be configured.
• Fixed the system restart issue when the record size grows beyond 4096 and the system runs out of memory and crashes.
• Fixed the NetezzaSQL ODBC driver loading issue due to C++ 2015/2022 runtime libraries.
• Fixed the issue of checksum error while restoring the database.
• Fixed the crash issue that occurs while performing BPCHAR->CHAR explicit casting in queries.
• Added additional log collection in monitor.sh using nzpush -a status for identifying network interface information.
• Changed the confirmation message about incompatible UDXs to a warning message. The confirmation message was to confirm the architecture purge of the incompatible UDXs identified during the upgrade.
• Fixed the NPS restart issue that happens while running large number of insert statements inside BEGIN-COMMIT block.
• Provided additional logging mechanism through solconsoledaemon to collect SPU console logs when problematic SPU goes unreachable.
• Fixed the issue that caused bad deletexids getting written on the disk page to avoid corruption.
• Fixed the issue with backup transactions that caused waiting for a long time.
• Fixed the Postgres crash issue that happens while running delete command on versioned table.
• Fixed the performance issues reported after expanding the system from Base+16 to Base+32.
• Fixes the issue with setting up nzpassword while using connector node.
• Fixed the error Unable to find role: disk serial number not provided that occurs while performing disk replacement.
• Fixed the issue that caused the error: Bad date external representation '00000000' wit ENABLE_NEW_CASE set to OFF.

Known issues

• If you get the following error message during Netezza Performance Server upgrade, contact IBM support.

  ERROR: Duplicate Records found in $n databases.
  Please contact IBM customer support for assistance.

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