Netezza Stability

Kapil Sharma
Technical Lead at a tech services company with 10,001+ employees
As a database administrator, and in warehousing part for the last 12 years, we always have stability issues in every technology. So the issue is how well they support their product. IBM does support their product very well. We have had issues where there were queries that were generating billions of rows. It's all about how you understand the underlying architecture. The coder who understands the architecture can write a better query. We sometimes need to educate them. So there are always stability issues but not in terms of hardware or support. It's always how well you write your queries. If you don't know Netezza, if you don't SQL or you don't know the underlying architecture but you are a good SQL developer, you know all the business logic and you write a query - but it is not actually performing - it's because you have not understood the distribution part of it. You need to consider the distribution keys or the organization keys. That makes the difference. The stability doesn't depend on the hardware, it depends on your coding in SQL. View full review »
Govind Dutt Pullat
Business Intelligence Solution Architect at a financial services firm with 5,001-10,000 employees
The database runs stable unless there are hundreds of queries running in parallel. View full review »
Thomas Starr
Lead Business Intelligence Analyst at a logistics company with 1,001-5,000 employees
I would say it's very stable. Whenever we have any sort of outage, the hardware team always communicates it, and it's been months since we've had any sort of outage, outside of the standard maintenance window. There have never really been any issues there. Stability has been good. View full review »
Ranganath Praveen
Lead Consultant at a tech services company with 10,001+ employees
We rarely had stability issues. You may expect an average of one outage every two months for a few minutes, if it is maintained properly. This is mostly due to “pollreplytimeout” errors of the SPU. All the rack components are dual for redundancy. Almost all components have failsafe/backup, including the host that is configured in cluster for high availability. With this, the system is up and running all the time, or you can get it up at the earliest possible time in case of component failures/system down situations. View full review »
IntelAdm5071
Business Intelligence Administrator at a comms service provider with 1,001-5,000 employees
It's pretty good when it works. It's pretty stable overall. But if you have a problem, support is a nightmare. View full review »
Reviewer232198
Database Admin. Manager at a financial services firm with 1,001-5,000 employees
Stability-wise, the product has improved. Netezza has improved the product over the past 10 years. We now have better monitoring and can be more proactive about detecting issues. View full review »
Ariovaldo Santos
Senior Solution Architect at a tech vendor with 1,001-5,000 employees
We did not have any stability issues. View full review »
SRMGR0987
Senior Manager - Data Quality and Governance with 1,001-5,000 employees
It is stable. We use it in our data warehousing complex, and the performance is good. View full review »
Valai Gunapalan
QlikView Consultant at a tech services company with 11-50 employees
We did not encounter any issues with stability. View full review »
DBAdm3495
Data Warehouse Architect at a consultancy
Great stability in Netazza's Mako. View full review »

Sign Up with Email