Skip to content

How to find Netezza model type?

To find if Netezza system is a Mustang box, TwinFin or Striper by connecting to the server using putty:

1) Run Netezza provided support script nz_get_model

eg. Below was run on Mustang 10100 model
/export/home/nz->nz_get_model
10100SL

eg. Below was run on TwinFin 12 (newer model)
/nz/support/bin->nz_get_model
IBM PureData System for Analytics N1001-010

eg. Below was run on TwinFin 48 (old model)
/export/home/nz->nz_get_model
IBM Netezza 1000-48

eg. Below was run on Striper (1 rack)
/export/home/nz->nz_get_model
IBM PureData System for Analytics N2001-010

2) If you are on version 5 or above then you can find the system family and details by running below sql query

eg. Below query was run on TwinFin 48. NPS_MODEL = P400X_A means 4 rack i.e. TF-48
/export/home/nz->nzsql -c “select * from _t_environ where name like ‘NPS%’;”
NAME | VAL
————–+———
NPS_PLATFORM | xs
NPS_MODEL | P400X_A
NPS_FAMILY | PSeries

eg. Below query was run on TwinFin 12
/export/home/nz->nzsql -c “select * from _t_environ where name like ‘NPS%’;’
NAME | VAL
————–+———
NPS_PLATFORM | xs
NPS_MODEL | P100_A
NPS_FAMILY | PSeries

eg. Below query was run on TwinFin 120
/export/home/nz->nzsql -c “select * from _t_environ where name like ‘NPS%’;”
NAME | VAL
————–+————
NPS_PLATFORM | xs
NPS_MODEL | P1000X_A_E
NPS_FAMILY | PSeries

NOTE: NPS_MODEL = P* means TwinFin machine and NPZ_MODEL = Q* means Striper series. For 10 rack Striper NPS_Model will be Q1000*

Also, under NPS_FAMILY, PSeries means TwinFin and QSeries means Striper.