Netezza Performance Server 11.0.0.0 release notes
Netezza Performance Server (also called Netezza Performance Server or NPS), is an add-on data warehouse solution available for Cloud Pak for Data System platform.
Netezza Performance Server data is stored, managed, and processed on solid-state disks (SSDs) attached to a collection of SPU (Snippet Processing Unit) nodes. The SPU nodes are aggregated into one or more Cloud Pak for Data System expansion units, where each expansion unit has 4 nodes. Each SPU node has 4 locally-attached 4TB NVMe (non-volatile memory express) SSDs. The SSDs are self-encrypting drives (SEDs), and NPS makes available the encryption capabilities of the drives.
New features
- An SQL client driver for the GO programming language.
- The ability to modify data in a different database than the one currently connected to. Exceptions to this are: operations on row-secure tables (RSTs), and ALTER TABLE { ADD | DROP | RENAME | MODIFY } COLUMN.
- Database ROLE functionality (CREATE ROLE, ALTER ROLE, DROP ROLE, SHOW ROLE, SET ROLE), for
packaging sets of privileges in a role object and granting users the ability to assume
a role (via SET ROLE) in an SQL session.
Netezza Performance Server database users, groups, and roles.
- The ability to run more concurrent queries with fewer out-of-memory errors than on Netezza, as a result of new 64-bit SPU software allowing global shared memory to be increased significantly.
- Cloud Pak for Data System capabilities are leveraged for
hardware monitoring and failover, managing events, and CallHome.
- A new nzsw command-line utility is available for reporting software issues (analogous to nzhw -issues or nzds -issues), for example: generate statistics (including estimates of the time these will take), groom, and reindex operations, orphaned tables, and catalog inconsistencies. System statistics and changes made to Netezza Performance Server configuration parameters can also be shown with nzsw.
- nzbackup, when not invoked in verbose mode, provides running progress
feedback of the form
Number of objects/tables remaining: x out of n. - JSON data type support as outlined in https://www.postgresql.org/docs/9.2/datatype-json.html
- A new feature to create global temporary tables. For more information, see Create global temporary tablefs.
Compatibility with Netezza
Netezza Performance Server is fully compatible with IBM PureData System for Analytics (Netezza appliances). Any existing Netezza scripts and SQL applications can be run without modification on the Netezza Performance Server.
Netezza Performance Server host command-line interface (CLI) commands are generally identical to IBM PureData System for Analytics 7.2.1.x.
IBM PureData System for Analytics Release 7.2.1.x clients work against NPS 11.0.0.0 hosts (servers), using the configured host name and IP address. The server port numbers are the same for both products.
The NzAdmin and NzPortal tools are not provided with Netezza Performance Server 11.0.0.0. However, equivalent functionality is provided in the IBM Performance Server web console.
The database backup and restore format is compatible across Netezza Performance Server 11.0.0.0 and IBM PureData System for Analytics 7.2.1.X (and earlier).
- Netezza Performance Server primary - Netezza Performance Server subordinate
- IBM PureData System for Analytics 7.2.1.X primary - Netezza Performance Server subordinate
- Netezza Performance Server primary - IBM
PureData System for Analytics 7.2.1.X subordinate Note: In this particular combination, if the Netezza Performance Server master node uses the new Role functionality or updates a different replicated database than the one connected to in a session, replication to the IBM PureData System for Analytics 7.2.1.X subordinate node will fail and will require manual intervention to recover and synchronize.
Netezza Performance Server is compatible with IBM Netezza Analytics (INZA). It is 100% compatible with PDA INZA functionality-wise.
IBM Performance Server for PostgreSQL Analytics (IPSA) currently does NOT support nzLUA UDX.