Netezza Basic Commands

Some Netezza basic commands use regularly

[nz@CELDNTZ1 ~]$ nzrev
Release 6.0.8 (P-11) [Build 32232]
[nz@CELDNTZ1 ~]$ nzstats

Field Name           Value
-------------------- ------------------------------
Name                 CELDNTZ1
Up Time              2941439 secs
Up Time Text         34 days, 1 hr, 3 mins, 59 secs
Date                 19-May-14, 17:50:38 SGT
State                8
State Text           Online
Model                IBM Netezza 100-1
Num SFIs             0
Num SPAs             1
Num SPUs             1
Num Data Slices      8
Num Hardware Issues  0
Num Dataslice Issues 0

[nz@CELDNTZ1 ~]$ nzhw -issues
No items found
[nz@CELDNTZ1 ~]$ nzds -issues
No items found
[nz@CELDNTZ1 ~]$ nzstate
System state is 'Online'.
[nz@CELDNTZ1 ~]$

Checking sessions (all/active)

nzsession -activeTxn

Netezza logs can be found in this directory

/nz/kit/log/postgres
/nz/kit/log/sysmgr
/nz/kit/log/startupsvr
/nz/kit/log/dbos