Skip to content

Find Netezza version from client

You can check Netezza version from your client machine by either of the following ways.

1) Using nzsql run the below command:

nzsystem showRev -host host -u user -pw password

2) Using NzAdmin:
Connect to Netezza server using NzAdmin
Go to Help (tab) –> About NzAdmin
New page will open
This will show the NzAdmin version as well as NPS version

3) Using Aginity:
Connect to Netezza server using Aginity
Go to Help –> System info
New window will open
This will show you NPS version under “DBMS Version:” field

4) Buy issuing below query to system view:

select system_software_version from _v_system_info

SYSTEM_SOFTWARE_VERSION
———————–
Release 7.0.2 (P-5) [Build 31068]

5) Buy issuing below query to management table:

select label, rev_stamp from _t_Vt_NZREV

LABEL REV_STAMP
===== =========
Release 7.0.2 (P-5) [Build 31068] 7.0.2-0.F-1.P-5.Bld-31068