To remove the bogus SAS switch entries – Netezza - learn Reading Time: < 1 minute

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



Meet Ananth Tirumanur. Hi there 👋

I work on projects in data science, big data, data engineering, data modeling, software engineering, and system design.

Connect with me:

My Resources:

Languages and Tools:

AWS, Bash, Docker, Elasticsearch, Git, Grafana, Hadoop, Hive, EMR, Glue, Athena, Lambda, Step Functions, Airflow/MWAA, DynamoDB, Kafka, Kubernetes, Linux, MariaDB, MySQL, Pandas, PostgreSQL, Python, Redis, Scala, SQLite