How to Check the History of Netezza Versions?

To find the history of NPS upgrades on your server, run the following command:

$more /nz/.versions/versionhistory

Here's an example of the output you might see:

2017-08-22 15:17:28 -0400 (EDT): ACTION=upgrade ORIGIN=6.0.5-0.F-1.P-10.Bld-24823 TARGET=7.0.2-0.F-1.P-5.Bld-31068 STATE=Successful
2018-02-15 22:35:36 -0500 (EST): ACTION=upgrade ORIGIN=7.0.2-0.F-1.P-5.Bld-31068 TARGET=7.0.2-0.F-1.P-8.Bld-32960 STATE=Successful
2018-07-22 03:42:59 -0400 (EDT): ACTION=upgrade ORIGIN=7.0.2-0.F-1.P-8.Bld-32960 TARGET=7.0.2.11-P2-F1-Bld35921 STATE=Successful

Note that the latest version of Netezza is V7.2.1 according to the IBM website: IBM Netezza Release Notes

How to Check Netezza Versions History

This article will guide you on how to check the history of Netezza versions that have been installed or upgraded in your system. Knowing the version history is essential for understanding the features, fixes, and compatibility of your Netezza environment.

Prerequisites

Access to a Netezza system with proper privileges.
SQL knowledge or familiarity with the Netezza command line interface (CLI).

Method 1: Using SQL Query

You can use SQL queries to view the history of installed and upgraded versions of Netezza. Here's a step-by-step guide:

Step 1: Connect to the Netezza system

    $ nzsys -u username -p password -h hostname -d database_name

Step 2: Run the SQL Query

    SELECT install_time, version FROM netezza.nz_system_version WHERE is_current = 1 ORDER BY install_time DESC;

This query will return the most recent Netezza version that is currently in use and its installation time. If you want to see all versions, including those that are not current, remove the WHERE clause.

Method 2: Using the Netezza Command Line Interface (CLI)

The Netezza CLI also provides a way to check the history of installed and upgraded versions. Here's how:

Step 1: Connect to the Netezza system

    $ nzcli -u username -p password -h hostname -d database_name

Step 2: Run the Netezza CLI Command

    show system-version detail

This command will return a detailed output of all installed and upgraded versions of Netezza, along with their installation times.

Comparison Table

Method	Advantages	Disadvantages
SQL Query	Allows for filtering of current versions only, and can be used in other SQL queries.	Requires SQL knowledge and may not provide a detailed view of all installed versions.
Netezza CLI	Provides a detailed view of all installed and upgraded versions, no SQL knowledge required.	May require more effort to filter or parse the output for specific information.