In this article, we will look into new features that are introduced in the Netezza latest version 7.2.X.
IBM Netezza Latest Version New Features includes some useful developer features. Below are the some of the important new features which developer can use.
Read:
Netezza Concurrent Truncate Support
In Netezza version 7.2.x and later, disk storage for a truncated table is freed only when there are no active concurrent transactions that are started before system committed the TRUNCATE table. If there are no such concurrent transactions at the time a truncate commits, the storage is freed a few seconds after the commit. Open transactions that started before the TRUNCATE committed can still see the rows in the table from before the TRUNCATE table.
This features helps when you are working on application that has an access to same table that other application is using.
Table-oriented zone maps
In Netezza version 7.2.x and later, IBM has introduced table oriented zone maps. When you upgrade to latest version 7.2.x and later, the column oriented zone maps are preserved. You must use the nzzonemapformat -table command to convert the column oriented zone maps to table oriented zonemaps. During conversion phase, the system must be paused.
Data loading changes
nzload Command: The nzload command now supports merge operations. You can read about this new feature in my other article – Netezza nzload merger operation and examples.
nzsql Command – The nzsql command can be used to establish a connection before a load from a remote external table or an unload into a remote external table. NZSQL option is introduced in latest version.
External Table – There are two new external table load options for changing the default delimiter of a space (‘ ‘) in time and timestamp values:
Read: Netezza External Table and Examples
- MeridianDelim option – Specifies a single-byte character that separates the seconds component from the AM or PM token in the 12-hour delimited
- DateTimeDelim option – Specifies a single-byte character that separates the date and time components of the timestamp data type
Database and SQL language
Netezza SQL language new feature:
CREATE TABLE command now includes support for the IF NOT EXISTS syntax.
The DROP TABLE command now includes support for the IF EXISTS syntax.
Kerberos authentication changes
The latest version support for NPS administrators to create locally authenticated database users as exception cases when the system is configured to use Kerberos authentication for database user accounts.