Skip to content

To remove the bogus SAS switch entries – Netezza

To remove the bogus SAS switch entries from the system catalogs :

1) Shut down NPS: nzstop

2) Connect to postgres database:

Chance are this will not work:
> /nz/kit/sbin/postgres -P -D /nz/data –O system

OR

Try this 1st:
> /nz/kit/sbin/postgres -D /nz/data system –P

3) Delete bad entries, and exit postgres:

delete from _t_hwcomp where hw_hwid=1200;
delete from _t_hwcomp where hw_hwid=1201;
delete from _t_hwcomp where hw_hwid=1202;
delete from _t_hwcomp where hw_hwid=1203;

Issue ctrl-d to exit from single user postgres

4) Start NPS: nzstart