Find Netezza Model
To find if Netezza system is a Mustang box, TwinFin or Striper use the nz_get_model command by connecting to the server using putty or query the system table:
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
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
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
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.