Download and run a diagnostic binary on your Netezza host. Email the output to Smart Associates. Receive a detailed report with findings and specific remediation advice for every issue identified.
When to Get a Health Check
If you are running Striper, Mako, or heading towards CP4D Hammerhead EOS in March 2026, understanding your actual risk profile is the logical starting point.
Queries that used to run in minutes now take hours. Data loads are missing windows. You suspect something is wrong but do not have the internal expertise to pinpoint it.
Before committing to a migration programme — to PostgreSQL, Snowflake, or another platform — you need an honest assessment of what you have and what complexity a migration involves.
Your organisation has a security audit, a regulatory review, or an internal governance review on the horizon. You need to know whether your Netezza access control posture can withstand scrutiny.
A new DBA has taken over the Netezza environment. A system has been inherited after a restructure. You want an independent baseline before taking on full accountability.
Some of our clients commission health checks on a regular cadence — annual or bi-annual — as a standard part of their infrastructure governance cycle. There does not need to be a crisis.
What It Examines
The health check software covers every material aspect of your Netezza environment automatically. Nothing is assumed to be fine. Everything is verified and reported.
Hardware version, firmware levels, NPS version, patch status, HA configuration, and deviation from IBM best-practice baseline.
Query history analysis, slow query identification, disk and CPU utilisation trends, workload contention, skew analysis, and GROOM/statistics currency.
User account inventory, privilege audit, dormant accounts, superuser exposure, network configuration, and comparison against security baseline.
Review of your current NPS version against IBM EOS dates, active support status, available upgrade paths, and the commercial and operational risk of your current position.
Backup and recovery configuration, data retention practices, housekeeping schedules, and space capacity trajectory.
Upstream data sources, downstream consumers, ETL tooling, replication pipelines, and the resilience of the overall data flow architecture.
What You Receive
NPS version, RHEL version, Host Platform Framework (HPF) and Field Diagnostics Tool (FDT) versions — with specific upgrade recommendations where appropriate.
Assessment of hardware health across the appliance, identifying any issues or components showing signs of failure or degraded performance.
GROOM state across tables, data skew analysis, and statistics currency — with per-issue remediation advice in the legacy NPS report.
Workload and query performance observations, identifying common causes of degraded throughput and slow query execution.
Smart Associates provides smartdsa.bin — a single diagnostic binary for your Netezza platform. Versions are available for legacy NPS appliances and CP4D.
Execute the binary on a host with access to your Netezza system. It collects software versions, hardware state, database health metrics, and performance data automatically.
Send the collected diagnostic output to info@smart-associates.biz. No data leaves your site until you choose to send it.
Smart Associates analyses the output and returns a structured report with findings and specific remediation advice for each issue. Legacy NPS reports include per-issue guidance. CP4D reports cover warnings and errors.
The health check is built into SMF and runs on a regular schedule as part of the Netezza Support Plus Managed Service tier. No manual steps required.
Contact us to get access to the software, or find out how it fits into your Netezza Support Plus engagement.
Get in Touch