New features and enhancements

IBM Netezza Nexus

IBM Netezza Nexus is an open lakehouse catalog natively integrated into the Netezza engine. Built on the open Apache Iceberg REST Catalog specification, Nexus provides secure, governed, multi-engine access to Apache Iceberg tables—without copying or moving data. Nexus is available in this release as a private tech preview. For more information, see IBM Netezza Nexus.

Unstructured data in Netezza

Netezza now supports processing unstructured data, including PDF files, images, and JSON files, on AWS SaaS and BYOC deployments. Operations include text extraction from PDFs and images (six languages), table extraction using JSONPATH queries, metadata extraction, and vector embedding generation for RAG workflows. For more information, see Unstructured data.

Netezza built-in vector store

Netezza now supports a native vector data type for storing and managing embeddings in generative AI and Retrieval-Augmented Generation (RAG) workflows. Embedding tables are created directly in Netezza and benefit from the AMPP architecture for parallel, high-performance vector storage and retrieval. For more information, see Vector data type support.

Node.js driver support

A native Node.js driver is now available for direct Netezza database connectivity from JavaScript applications. The driver supports DDL, DML, and transaction management operations. A VS Code extension is also available. For more information, see nz-node driver and Netezza SQL Tool VS Code extension.

JDBC connector – Connection retry options

Two new JDBC connector options are available: ConnectionRetry sets the number of automatic retry attempts on connection failure, and ConnectionRetryDelay sets the delay in milliseconds between retries. The delay applies only between retries, not on the initial attempt.

ODBC connector – Connection retry delay

The new ConnectionRetryDelay option for the ODBC connector sets the delay in milliseconds between connection retry attempts. Configuration is supported through a DSN or connection string on Windows and Linux.

nzcli enhancements

This release includes the following nzcli additions and changes:

• nz manualvacuum: Performs vacuum and reindex on all databases to reclaim disk space and optimize performance. The command stops the system, creates a catalog backup, runs maintenance, and restarts. For more information, see The nz manualvacuum command.

• nzsqa: Provides system diagnostics and monitoring—front and back channel statistics, active jobs, disk and memory usage, scheduler queues, lock tables, and more. For more information, see The nzsqa command.

• setup-lh-connection command (replaces set-hm): The set-hm command has been renamed to setup-lh-connection to better reflect its purpose of configuring the Lakehouse connection as part of the Netezza–Iceberg Catalog integration. Update any scripts or automation that use set-hm to use setup-lh-connection before upgrading to this release.

The set-hm command is no longer available. Scripts that invoke set-hm will fail after upgrading.

Advanced Monitoring

The Advanced Monitoring feature delivers granular performance metrics, resource utilization analytics, and system health insights from a single interface in the Monitoring Dashboard. For more information, see Advanced Monitoring.

SOC 2 Type 2 compliance for AWS

IBM Netezza Performance Server as a Service (NPSaaS) on AWS is now covered under IBM's SOC 2 Type 2 attestation. For more information, see Security and compliance overview.

INZA 11.3.6 support

INZA has been upgraded to version 11.3.6. For more information, see Netezza Performance Server Analytics 11.3.6 release notes.

Known issues

IAM-based S3 authentication for backup and restore

Backup and restore operations require AWS Access Key and Secret Key credentials when configuring the S3 bucket in AWS BYOC deployments (public and private instances). IAM-based authentication is not available for this release.

Workaround: Configure the S3 bucket only using AWS Access Key and Secret Key credentials for backup and restore operations.

Components

• nzcli version: 11.3.1.3

New features and enhancements

Custom CIDR support

For Bring Your Own Cloud (BYOC) deployments, custom CIDR support now allows you to specify your own CIDR range during Netezza on Cloud cluster provisioning, with minimum supported ranges of /22 for AWS and /21 for Azure deployments. For more information, see Custom CIDR support.

Console experience enhancements

Enhanced the user interface to improve navigation and usability for Administration activities. The Administration page now consolidates navigation to pages that were previously separate under the Administration menu, including Settings, Scheduler rules, Lakehouse connections, and Destinations, as new controls on a single Administration page.

INZA 11.3.5 support

INZA has been upgraded to 11.3.5. For more information, see Netezza Performance Server Analytics 11.3.5 release notes.

Fixes

• Resolved connect and request timeout issue where the default 1-second limit was insufficient for slow or high-latency networks. Introduced a configurable TIMEOUT argument for AWS S3/IBM COS connectors to support appropriate timeout (in seconds). See AWS S3, MinIO, and IBM Cloud Object Storage connectors.

Components

• nzcli version: 11.3.1.2

New features and enhancements

Hostname verification for SSL/TLS authentication

Version 11.3.1.1 introduces the enableHostNameVerification parameter for nzsql, ODBC, and JDBC drivers to control hostname validation during SSL/TLS connections. When enabled (true), the client verifies that the server hostname matches the hostname in the SSL/TLS certificate; if the hostnames don't match, the connection is rejected. The parameter defaults to false. For more information, see nzsql command reference, ODBC driver configuration, and JDBC connection strings.

Unique cloud storage buckets

Netezza requires separate cloud storage for each feature, including backup and restore, lakehouse, and REST catalog. Each feature requires unique AWS S3 buckets or Azure Blob Storage containers to ensure proper isolation and management. The console prevents adding the same bucket for multiple purposes.

Resource release for auto-pause (BYOC only)

For Bring Your Own Cloud (BYOC) deployments, you can optimize costs by releasing resources when you enable auto-pause from the console. When resources are released, the system requires additional time to resume from the paused state.

API server URL accessibility

The API server URL is accessible from the console. To view the URL, click the profile icon, where it displays alongside the Console and Netezza versions.

Fixes

• CPU throttling issue in Postmaster is resolved for slow consuming clients that request large responses, preventing excessive CPU usage caused by continuous checking of socket buffers.
• Query abort operations no longer become unresponsive at the MTX_SYNCDIST_SEM0 semaphore.
• The schedqueues output now displays accurate fcomm channel accounting. The calculation logic is segregated to show correct channel usage.
• Segmentation faults no longer occur when packet queues are drained after channel closure.
• System hang conditions during state transitions are resolved. Node-level queues are now completely drained even after channel closure, preventing partially drained queue states.
• Resolved a rare concurrency issue where metadata columns in user tables could be incorrectly set during concurrent transactions. Systems should be validated and corrected as needed before upgrading to this release.

Components

• nzcli version: 11.3.1.1

New features and enhancements

Improved serviceability for BYOC deployment

The admin console now provides improved diagnostic capabilities and troubleshooting support through enhanced error messaging and system status indicators.

Amazon S3 bucket registration through IAM roles for AWS BYOC

Register Amazon S3 buckets using IAM roles for native cloud object storage. For more information, see Create IRSA policy and role for engine namespace, AWS S3 configuration.

INZA 11.3.4 support

INZA 11.3.4 introduces "Keyed Cryptographic Hashing" along with various security updates. For full details, see Netezza Performance Server Analytics 11.3.4 release notes.

Components

• nzcli version: 11.3.1.0

New features and enhancements

Azure and AWS NCOS (native cloud object storage) support

This release delivers native support for Azure Blob Storage and AWS S3, now generally available. Users can create tables in Netezza format directly on object storage systems. This enhancement delivers greater scalability, flexibility, and cost-efficiency compared to block-based storage architectures, allowing seamless integration with both Azure and AWS cloud environments. For more information, see Setting up a cloud object storage bucket and Create a table with object storage.

AWS S3 support was introduced as a public preview in the previous release and is now fully GA.

REST catalog support for BYOC

IBM Netezza now offers a built-in REST catalog for managing Iceberg tables, eliminating the need for external catalogs like AWS Glue. With Bring Your Own Cloud (BYOC) support, you can seamlessly configure your preferred object storage (AWS S3 or IBM Cloud Object Storage) and manage Lakehouse databases directly from the Netezza web console. This streamlined approach simplifies setup, reduces dependencies on third-party services, and provides a unified experience for managing Iceberg tables. For more information, see Managing Iceberg tables with IBM Netezza REST catalog.

IAM Access on AWS bucket for NCOS

You can now configure your fully managed AWS S3 bucket for object storage using cross-tenant IAM access. This eliminates the need to provide access keys for the bucket. For more information, see IAM Role-Based Access in How to enable object storage.

Built-in AI database assistant

The DBA AI chatbot is now integrated into your console for a more seamless experience. It is now conveniently located next to the Profile icon at the top of the window.

Customer-managed key for BYOC on AWS

Take full control of your data security with customer-managed encryption keys. This feature allows you to use your own keys to encrypt data drives, ensuring compliance with organizational security policies and enhancing protection against unauthorized access. By managing your own keys, you gain flexibility, transparency, and peace of mind for sensitive workloads running on AWS. For more information, see Customer managed KMS key in AWS.

Server certificate validation for SSL/TLS authentication for OLE DB driver

The Skip CA Certificate Verification setting is introduced with a default value of true. To modify this default and enforce server certificate SSL validation, you can either clear the Skip CA Certification Verification option or set the environment variable NZ_SKIP_CERT_VERIFICATION to false. When the Skip CA Certificate Verification parameter is set to false in either the console or through the environment variable NZ_SKIP_CERT_VERIFICATION, the value false takes precedence over all other configurations. Additionally, the NZ_SKIP_CERT_VERIFICATION and NZ_CA_CERT_FILE environment variables are introduced. For more details, see Configuring OLE DB.

Accurate client IP logging for AWS private instances

Improved client IP reporting for AWS private instances. Starting with version 11.3.0.5, pg.log and histdb now display the actual client machine IP used to connect to the database instead of the load balancer IP.

Download certificates

You can now download the certificates that are required to connect to Netezza Performance Server directly from the console. Under the Profile icon, you can download the certificate. You can use this certificate when you connect to Netezza Performance Server by using nzsql and the ODBC driver with skipCertVerification=false.

Default limit for fetching history records

When you open the Connection History and Query History pages, 2,000 records from the last 15 minutes are fetched by default. Previously, the default limit was much larger and led to longer load times for the initial fetch. You can then adjust the parameters to get the set of records that you want. For more information, see Query history.

Enhanced display of upcoming backups during daylight saving changes

Improved handling and display of upcoming backup times on the dashboard when daylight saving changes are in effect, ensuring accurate and consistent scheduling information.

Components

• nzcli version: 11.3.0.5-IF1

New features and enhancements

Predefined alert rule support in the web console

The predefined rules eliminate the need for manual configuration, making the process significantly faster and more efficient.

Server certificate validation for SSL/TLS authentication

Starting with version 11.3.0.4, the skipCertVerification parameter defaults to true for nzsql, ODBC, and JDBC drivers. To enforce mandatory server certificate SSL validation, set skipCertVerification to false. For more information, see Configuring the DSN and driver options with ODBC Driver Setup, Data source configuration file, JDBC connection strings, The nzsql command, Configuring the JDBC data source by using an nzjdbc.ini file (Windows).

INZA 11.3.3 support

INZA 11.3.3 is supported. For more information, see Netezza Performance Server Analytics 11.3.3 release notes.

Components

• nzcli version: 11.3.0.4

New features and enhancements

Netezza Cloud Object Storage (COS)

Netezza Performance Server (NPS) 11.3.0.3 IF1 introduces native support for S3-compatible object storage such as AWS S3, enabling users to create tables in Netezza format directly on object storage systems. This enhancement delivers a new level of scalability, flexibility, and cost-efficiency, surpassing the limitations of block-based storage architectures. It is now available in public preview for Netezza as a service on AWS. For more information, see Netezza Cloud Object Storage.

Netezza Bring Your Own Cloud on Azure

Netezza BYOC on Azure is now generally available. IBM Netezza as a Service Bring Your Own Cloud (BYOC) enables businesses to deploy Netezza directly within their own Virtual Private Cloud (VPC), enhancing data security and providing greater flexibility in managing infrastructure. For more information, see Netezza Performance Server for BYOC.

IBM Netezza Software

This form factor provides a comprehensive, software-only deployment of Netezza for data and AI workloads, designed to run on client-provided containerized platforms such as Red Hat OpenShift. It is engineered for high performance and ease of deployment, integrating database, storage, server, and analytics capabilities into a single, standards-based solution. For more information, see Netezza Performance Server - Software.

Server certificate validation for SSL/TLS authentication

To enhance security, server certificate validation is now required for all SSL/TLS connections using ODBC, JDBC, and nzsql. Users must specify the CA certificate path by using the caCertFile parameter, similar to how the securityLevel parameter is used. For more information, see Steps to acquire SSL certificates for Netezza.

Components

• nzcli version: 11.3.0.3-IF1

New features and enhancements

Notification setup for NPSaaS users

NPSaaS introduces notifications for critical service-related events, helping users monitor and respond to system changes. For more information, see Monitoring and alerts.

REST catalog support for Iceberg table management

IBM Netezza supports a built-in REST catalog for managing Iceberg tables, eliminating the need for external catalogs like AWS Glue. This feature allows users to configure their own object storage (AWS S3 or IBM COS) and create Lakehouse databases directly from the Netezza web console. For more information, see Managing Iceberg tables with IBM Netezza REST catalog.

Enhancement in Azure connector support

The Azure connector has been enhanced to support General Purpose v2 storage accounts with the Standard performance tier. This enhancement enables users to perform backup and restore operations using Gen2 storage accounts, expanding compatibility and flexibility for Azure-based storage solutions.

Customer-managed keys for Netezza BYOC on AWS

You can now use customer-managed keys to encrypt data drives, providing greater protection and supporting compliance requirements.

AWS Marketplace integration

Netezza Bring Your Own Cloud (BYOC) is now available as an offering on the AWS Marketplace. This integration simplifies deployment and enables seamless access through your existing AWS account. For more information, see IBM Netezza as a Service Bring Your Own Cloud.

Support for encrypted S3 buckets in Netezza backup and restore

Netezza backup and restore operations now support AWS S3 buckets encrypted with AWS KMS keys. This enhancement enables secure data storage and retrieval using AWS-managed encryption. To configure your S3 bucket with an AWS KMS key, see Configuring your bucket to use an S3 Bucket Key with SSE-KMS for new objects.

The bucket user must have access to the AWS KMS key.

Components

• nzcli version: 11.3.0.2

New features and enhancements

Netezza Iceberg enhancements

Version 11.3.0.1 introduces the following enhancements:

• CTAS support: Create Iceberg tables using CREATE TABLE AS SELECT from Netezza or Iceberg tables.
• Type promotion: Unsupported types in Netezza are automatically promoted when creating Iceberg tables.
• Cascade drop: Dropping schemas with Iceberg tables supports the CASCADE option.
• Truncate support: Use TRUNCATE TABLE to remove all data from Iceberg tables (data remains in snapshots).
• Delete support: Delete rows from Iceberg tables using DELETE queries.
• Update support: Update rows in Iceberg tables using UPDATE queries.
• Table properties: Netezza supports key Iceberg table properties for controlling read/write behavior.
• Show properties: Use SHOW TBLPROPERTIES to view non-default table settings.

For more information, see Supported SQL commands.

OIDC authentication in the Netezza ODBC driver

Added support for OIDC-based authentication in the Netezza ODBC driver. For more information, see Usage of ODBC driver with OIDC authentication.

Enhanced database assistant with new analytical skills

New skills are added to support user activity insights, data slice usage analysis, and permission visibility. For more information, see Using the Netezza database assistant.

Components

• nzcli version: 11.3.0.1

New features and enhancements

Database assistant for Azure and AWS

The Netezza Database Assistant chatbot is now generally available across AWS and Azure. Powered by watsonx, this AI-driven assistant provides conversational support to help streamline database operations. For more information, see Using the Netezza database assistant.

IBM Netezza JDBC driver update

The IBM Netezza JDBC driver now includes an upgraded Java Runtime Environment (JRE) version 15.0.2. This update enables support for Windows-integrated Kerberos ticket cache authentication, enhancing security and compatibility for enterprise environments.

Fixes

• Improved lazy vacuum operations with internal support for configurable time and threshold settings in nzvacuumcat.conf.
• Resolved issues where vacuum and reindex tasks were frequently skipped due to continuous query activity.
• Ensured periodic cleanup of system and global database entries to reduce dead space and improve overall maintenance efficiency.

Components

• nzcli version: 11.2.3.6

New features and enhancements

Connection history

A detailed history of successful and failed connections is now available, including the reasons for any failures. This feature offers improved insights into connectivity issues. For more information, see Connection history.

Automaint history

A new section has been added to track the details of the last successful execution of Groom and Genstats as part of the automaint process configured on the system. For more information, see Automaint history.

Query history shortcuts

Users can now quickly access information about short-running and long-running queries, improving efficiency in query management.

Components

• nzcli version: 11.2.3.5

New features and enhancements

Workload contour scaling

Scaling can now be performed while the instance is in a paused state. For more information, see Scaling.

Recent queries

The Recent queries section has been moved to Query history and now supports up to 500,000 rows, significantly increasing from the previous limit of 2,000 rows. For more information, see History.

Components

• nzcli version: 0.9.35

New features

Database assistant for AWS

Introducing the Netezza Database Assistant chatbot for AWS clusters, powered by watsonx. This AI-powered assistant is built on IBM’s decades of expertise in managing the world’s most mission-critical data workloads. For more information, see Using the Netezza database assistant.

New features and enhancements

Query cancellation

A feature to cancel long-running queries executed from the query editor. For more information, see Query cancellation.

IdP configuration

The IdP configuration page is now part of the Settings page. For details, see Setting SAML authentication with the Netezza UI and Setting Azure OIDC authentication with the Netezza UI.

Components

• nzcli version: 0.9.24

New features and enhancements

• Updated recent queries page: The page now includes visibility into error types for query failures.

  The Recent queries page now shows queries submitted within the last 15 minutes by default. Queries remain visible for up to 24 hours, with a limit of 2,000 queries.

• Enhanced IdP configuration options: Enhanced the IdP configuration page with dedicated tiles for streamlined management of SAML and OIDC configurations.

  • You can now download certificates for signed authentication validation in SAML to simplify setup and enhance security. For more details, see Configuring Signed Authentication on IdP.
  • Support for signed authentication has been introduced for SAML in NPSaaS, providing improved security for your configurations. For more details, see SAML.

• Introduced the new nzprogress command, allowing you to view and track ongoing plans. See Commands supported by the nz tool.

Fixes

• Time zone handling: Resolved issues related to time zone handling, ensuring consistent and accurate time display across the platform.
• History page fixes: Addressed the problem where auto pause and resume actions for recent entries were not showing on the History page of the web console, improving visibility and tracking.
• Scheduled backups update: Fixed the issue preventing the start date and time of scheduled backups from being edited, giving you full control over your backup schedules.

New features and enhancements

• Introduced a new feature in AWS network policies for ingress connections. You can now control which IP addresses are allowed to connect to the NPSaaS database, similar to Azure network policies. For details, see Network policies.
• Introduced a JWT token in the Administration > Tools tab, allowing SAML and OIDC users to copy the JWT token from the console after they log in.
• Enhanced platform AWS Administration functionality to include support for lakehouse connections, databases, and schemas on the console.
  • Introduced a new Lakehouse Connections tab in Administration specifically for creating lakehouse connections, databases, and tables.
• Added CRUD operations to the Query editor for lakehouse tables.
• Enabled SAML and OIDC for AWS and Azure platforms.
• Introduced the Destinations tab in Administration. You can now create buckets concurrently for database backups and Lakehouse data source.

Fixes

• Only administrators can enable and disable the auto-pause/resume feature. See Auto-pausing and auto-resuming.
• Fixed an issue where a differential backup from the Mako system failed on Netezza Performance Server during a restore.
• Introduced support for partial certificate chain verification in SSL. For more information, see The nzsql command.
• Improved transaction rollback performance by optimizing the handling of large tdj files.
• Improved signal handling for the DBOS process to avoid sessions getting hung in a disconnected state if a query with UDX was abnormally aborted.
• Prevented system restart due to crash when running stored procedures with execute immediate clause.
• Fixed an issue where some views couldn't access the toast data correctly after an OID reset.
• Fixed incorrect query results on tables distributed by char type columns with restrictions.

Components

• NPSaaS 11.2.3.1
• Web console 4.1.0.0

Known issues

• Issue with the date picker in Chromium-based browsers: You might experience an issue with the date picker in the console when you use the latest versions of Chrome and Edge browsers. When a date is selected and focus shifts to another input field, the date reverts to its default value.

  Affected versions: Chrome version 127.0.xxxx.xx and Edge version 127.0.xxxx.xx.

  Workaround

  Use Firefox or Safari.

  The behavior might vary on different operating systems and browser versions.

• IP address required for OIDC/SAML authentication in private instances: To use OIDC/SAML authentication in a private instance, access the web console by using the IP address, not the hostname. To get the IP address, see Configuring private endpoints.

Components

• NPSaaS 11.2.3.0-IF1
• Web console 4.0.3.2

Fixes

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

New features and enhancements

• NPS 11.2.3.0 supports SSO (single sign-on) with multi-factor authentication:
  • SAML
  • OIDC (Azure)
• Introduced the nc-start configuration on Azure that provides an entry-level configuration for BI and UAT workloads.
• A new checkbox option has been added to the console for deleting backups. When selected, this option also removes the backup from the underlying cloud object store (S3/Azure Blob).
• Introduced the capability to perform time travel in an Iceberg table. For details, see Time travel for Iceberg table.

Components

• NPSaaS 11.2.3
• Web console 4.0.3.2

New features and enhancements

• AWS IAM user authentication allows you to create and log in to your account by using your AWS IAM credentials. This means that you can use your existing AWS access and secret keys to sign in to your account with no additional steps required. Additionally, you can now use multi-factor authentication (MFA) to further secure your account. For more information, see Setting AWS IAM authentication.

Fixes

• Timezone issues: Fixed the incorrect time zone display issue. By default, all timestamps are now displayed in the database time zone. You can choose between the database time zone and the local time zone for scheduling automaintenance, BnR, and pause and resume jobs.

Components

• NPSaaS 11.2.2.11
• Web console 4.0.3.1

New features and enhancements

• A new Scheduler type column is introduced on the History page for past records. This column indicates whether the corresponding schedule is ad hoc or scheduled. For more information, see Checking scaling history.

• Enhanced system stability for smooth operations.

• RHEL8/GCC9 upgrade:
  Version 11.2.2.10 incorporates an upgrade to RHEL8/GCC9.
  GCC9 supports only 64-bit. NPS no longer provides 32-bit client builds.

  GCC9 upgrade has no impact on custom UDX. If you face any issues, contact IBM support.

• INZA:
  python2 and its adapter are no longer supported.

• Netezza client:
  Supports initiating, viewing, and manipulating schedules for ad hoc, pause, resume, and scaling operations. For more information, see Pausing and resuming instances and Scaling.

• Introduced new maintenance job types, Grooms and Genstats, under the Maintenance section. For more information, see Maintenance.

• Introduced a new Lakehouse option for creating databases. For more information, see Create databases.

• CREATE TABLE support for unpartitioned Iceberg tables.

• INSERT support for Iceberg tables.

Fixes

• .Net login timeout overflow is fixed.

Components

• NPSaaS 11.2.2.10
• Web console 4.0.1.7

Known issues

• For expansion failures due to node procurement issues, the Ops team restores the system to the online state. You will see the expansion scheduler state as Suspended in the Workload patterns > Scaling section. The Ops team will contact you once the required nodes become available. For more information, see Viewing suspended expansion.

• Differential schema level backup might fail with the error message - "Error: Backupset not found in history for specified database and connector." if full schema level backup is performed on some different schema. To overcome this issue, take full schema-level backup of the schemas before performing its differential schema level backup.

New features and enhancements

• New NPSaaS functions that are associated with watsonx.data are introduced. For more information, see watsonx.data SQL commands.

  You can also view your data lakehouse objects with the web console.

• Learn how to Run multiple SQL statements in a single session and Run multiple SQL statements in different sessions with the query editor in the web console.

• Updated the algorithm that calculates the profile of the day. The calculation is now made by subtracting two subsequent records' timestamp values if they are on the same day and appending the timedelta to that profile. For each day, the system compares the profiles, identifies the one with the longest duration, and declares that profile to be the profile of the day.

Components

• NPSaaS 11.2.2.9

• Web console 4.0.1.6

• JDBC driver (on all platforms) MD5 Auth requests are deprecated. All MD5 connections are dropped.

• OLEDB driver (only on Windows) TLS1.2 protocol is given preference for SSL connections.

• All Windows supported drivers (ODBC & OLEDB) Visual Studio VC++ runtime redistributables are upgraded to 2022.

Known issues

• For issues related to NPSaaS and watsonx.data, see watsonx.data known issues.
• The Word_diff function in the SQL extension toolkit does not support string input.

Fixes

• Updated APIs for IBM Cloud secret manager.

Components

• NPSaaS 11.2.2.8-IF4
• Web console 4.0.15

Known issues

• The console might not display an abort confirmation when the backup or restore process is aborted and might show that the operation is still in progress. Apply the following workaround on your system to overcome this issue.

  • If backup aborted

    update _t_backup_history set status=2, batchstatus=2 where status=0
    

  • If restore aborted

    update _t_restore_history set status=2, batchstatus=2 where status=0
    

New features and enhancements

• Technology preview support for SELECT operations from Apache Iceberg and Hive tables is available on NPSaaS on AWS. Apache Iceberg is an open table format that helps simplify data processing on large datasets that are stored in data lakes. With Hive table support, you can access Hive tables directly from your NPSaaS instance and perform complex analytics operations by joining the tables with NPSaaS tables. For more information, see Querying data from watsonx.data.

• NPSaaS on AWS is now available in Europe (Frankfurt) region. Other regions where the service is available on AWS include:

  • North America: US East (Northern Virginia), US West (Northern California), and Canada (Central).
  • Asia Pacific: Tokyo, Seoul.

Fixes

• Fixed an issue in the SQL query editor where commented-out queries that were separated by a semicolon on the same line were executed.
• Fixed an issue where multiple pause, resume, and scaling jobs with the same name were executed.

Components

• NPSaaS 11.2.2.8
• Web console 4.0.15

Known issues

• Contour scaling from NC-Start to NC0 with storage utilization higher than 90% might result in errors. Keep storage utilization under 90% or expand storage before you start contour scaling. Ops alerts notify you about storage utilization.
• The console might not display an abort confirmation when the backup or restore process is aborted and might show that the operation is still in progress. Apply the following workaround on your system to overcome this issue.

  • If backup aborted

    update _t_backup_history set status=2, batchstatus=2 where status=0
    

  • If restore aborted

    update _t_restore_history set status=2, batchstatus=2 where status=0
    

New features and enhancements

• NPSaaS is now enabled on Amazon Web Services (AWS) in the US East (N. Virginia) region. For more information, see Getting started with Netezza Performance Server and Connecting to Netezza Performance Server.
• On AWS, smart scaling with confidence score and seed model display is now available in the NPSaaS web console. For more information, see Smart scaling.
• On AWS, a new entry-level workload contour called NC-Start is available to support lower-volume BI and UAT workloads. You can scale this instance to NC0 performance profiles as your workload increases. For more information, see Scaling.
• Time travel functionality is supported in the NPSaaS web console. For more information, see Getting started with Netezza Performance Server time travel.
• INZA 11.2.28 is supported. For more information, see Netezza Performance Server Analytics 11.2.28 release notes.

Components

• NPSaaS 11.2.2.7
• Web console 4.0.14

Known issues

• Databases, schemas, and table names containing a dot character (".") do not show in the time travel statistics and graphs when you set the retention time interval to a nonzero value.

• On-demand (ad hoc) backup and restore for multiple large databases in one operation succeeds for only a few databases in the batch. For the remaining databases, an authentication error occurs.

  Workaround:

  • Take a backup of a single large database at a time.
  • Restore a single large database at a time.

New features and enhancements

• The default maximum number of database connections to the server is now increased to 1,000.

Fixes

• Fixed the issue with .pln files not getting stored in $NZ_KIT_LOG/plans directory if your query crashes.
• Fixed an issue where sensitive files from the host pod could be read by using external tables and the remote nzsql client. Starting with this release, you cannot load data into the /root and /home directories, so using nzload with a data file from /root or /home is restricted, along with creating external tables in these directories.

Components

• NPSaaS 11.2.2.6
• Web console 4.0.12

Known issues

• You might find that the paste option does not work in Mozilla Firefox 110.x when you use the query editor in the web console. This is a web browser limitation, and you must change the browser configuration preferences to allow web pages to access the clipboard by using JavaScript. This issue does not occur in other web browsers.

  Workaround:

  1. Open a new Firefox window.
  2. In the address bar, enter about:config.
  3. Click Accept the Risk and Continue button.
  4. In the Search preference name, type asyncc.
  5. Select dom.events.asyncClipboard.readText and dom.events.testing.asyncClipboard by clicking the toggle icon on the right. The settings change from false to true.
  6. Refresh the web console page.

New features and enhancements

• Use time travel queries to retrieve and analyze historical data without having to develop extra application logic such as history tables. NPSaaS time travel comes in handy when you want to track the history of data changes or reconstruct your data. By using this powerful tool, you can access historical data (data that was changed or deleted) at past points in time or within a past period of time. For more information, see Getting started with time travel.

• The nzbackup and nzrestore destination directory limit is updated. Previously, only 16 directory locations to read/write were supported. Now, the limit is 32.

• The location of the postmaster and postgres core dumps is changed.

• Automatic pause and resume are enabled in the web console.

Components

• NPSaaS 11.2.2.5
• Web console 4.0.11

Known issues

If a common table expression or derived table query contains column names or column aliases that begin with an underscore, Netezza Performance Server deletes these columns from the query result set. If there are no columns to display, Netezza Performance Server returns the following error.

ERROR:  No columns are selected because the column alias begins with an underscore

Example:

create table t1 ( c1 int , c2 int);
CREATE TABLE
with tab1 as ( select c1 as _c1 , c2 as _c2 from t1 ) select tab1.* from tab1; ERROR:  No columns are selected because the column alias begins with an underscore
select tab1.* from ( select c1 as _c1 , c2 as _c2 from t1 ) as tab1; ERROR:  No columns are selected because the column alias begins with an underscore

New features

Use NPSaaS as a data source or data sink. For more information, see Using Netezza Performance Server as a data source and Using Netezza Performance Server as a data sink.

Known issues

datasource is a reserved keyword now. If you want to use datasource as an identifier, enclose it in double quotation marks ("datasource").

Example:

SYSTEM.ADMIN(ADMIN)=> create table t1 ( "datasource" int);
CREATE TABLE

Fixes

• Fixed the issue with queries failing with error No such table exists on a second attempt.
• Fixed the issue with DBOS crashing while redumping modified plan to file.
• Fixed the issue with intermittent hangs.
• Fixed ERROR : unexpected error 12 that occurred when you ran merge queries dynamically through a stored procedure.
• Fixed the issue with memory leaks with stored procedures that occurred after the _ENABLE_SPROC_HIST_LOGGING_ variable was enabled.
• Fixed the issue with postmaster crashing by compiling librest with Go 1.18.

Known issues

• If a large database backup to Azure Blob Storage with a single stream fails, update the number of streams to 16 and retry the backup.

New features

• Two new workload contours NC0 and NC3 are available for a wider range of configuration options for provisioning and scaling.
• Network policy support is added. You can control the set of IP addresses and hostnames that your NPSaaS database can connect to or be connected from by using network policies. For more information, see Network policies and Network policies with the web console.

Known issues

• Netezza SQL Editor does not accept input for query requests. You can construct equivalent query requests by using the command line.