IBM Db2 Warehouse vs IBM Netezza Performance Server comparison

IBM Db2 Warehouse vs. IBM Netezza Performance Server

Download the complete report

Helped 900,644 peers since 2012

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Categories and Ranking

IBM Db2 Warehouse

Ranking in Data Warehouse

13th

Average Rating

7.8

Reviews Sentiment

6.1

Number of Reviews

Ranking in other categories

No ranking in other categories

IBM Netezza Performance Server

Ranking in Data Warehouse

12th

Average Rating

7.8

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

Hadoop (6th)

Mindshare comparison

As of June 2026, in the Data Warehouse category, the mindshare of IBM Db2 Warehouse is 3.2%, up from 2.1% compared to the previous year. The mindshare of IBM Netezza Performance Server is 4.3%, up from 4.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Data Warehouse Mindshare Distribution
Product	Mindshare (%)
IBM Netezza Performance Server	4.3%
IBM Db2 Warehouse	3.2%
Other	92.5%

Data Warehouse

Featured Reviews

Sherpard Muzuva

Senior Technical Manager at SYSTEMS INTEGRATED LTD (SYMPHONY)

Advanced features enhance business intelligence, but complex management calls for improved user guidance

While my experience with IBM Db2 Warehouse is somewhat limited, when compared to other databases such as Oracle, there are areas for improvement. They need to enhance the database to make it more user-friendly and easier to master. They should implement a more comprehensive graphical user interface with additional features. For instance, when users encounter problems, the system should provide better guidelines and troubleshooting directions, except for hardware-related issues. They need to implement tools that would help users perform basic troubleshooting rather than solely relying on support. Other databases have features where users can investigate specific issues using error codes. From my experience, many minor issues could be resolved before escalating to support.

Read full review

Shiv Subramaniam Koduvayur

Project Manager at MAF Retail

Parallel data processing streamlines operations while cost and cloud integration challenge adoption

The cost of the solution is on the more expensive side, which is a concern for me. Additionally, its promotion and interaction with cloud applications are limited. The cloud version is only available in AWS, and in the Middle East, it is not well-developed in the Azure environment. For the cost to be reduced, it should match competitors. Many features need to be incorporated on the cloud.

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"I think it scales really well and as long as you take enough time to learn a little bit about it, it works really well."

"It can be mounted on the cloud, which is a huge plus. If the client, for example, starts small with on-premise deployment and then it rapidly needs to grow, we can transfer this to the cloud easily."

"It's easy and practical to use."

"The solution is stable."

"It can scale effectively as long as resources are available."

"The initial setup was really easy; it's Docker compliant, you just pull the image from the IBM repository and that's it, and the deployment must have taken less than an hour, making it really fast to have it completely working."

"The solution works with big data, so it's pretty scalable."

"The most valuable features of IBM Db2 Warehouse include its availability, easy integration, ability to deal with a large size of data, excellent performance with no delays, powerful security mechanisms, and effective support."

More IBM Db2 Warehouse pros

"ROI is high because analyst productivity improved drastically."

"We had a lot of POC's on a data warehousing project with the help of Netezza, we have proved that it has really improved time on doing analytics."

"The most valuable features of the IBM Netezza Performance Server are the NPS server because of the reduced maintenance and overall good performance."

"Billions of data are processed within an optimal amount of time, and it supports almost real-time analytics."

"It has the capacity to handle terabytes of data with query response times that are very low."

"The performance of the solution is its most valuable feature. The solution is easy to administer as well. It's very user-friendly. On the technical side, the architecture is simple to understand and you don't need too many administrators to handle the solution."

"Our BI enviroment with Netezza, Cognos and Data Stage has been a great success"

"Earlier there was high latency to query extraction but Netezza has improved the speed for all OLAP operations, helping the organization get business answers right on time."

More IBM Netezza Performance Server pros

Cons

"IBM Db2 Warehouse needs to improve its interface."

"I previously used DataStage, which I think is better than InfoSphere Warehouse."

"On a scale of one to ten, I would rate the technical support as a five. It is fairly bad."

"The areas of the solution that is needing the most improvement are separating compute from storage, elasticity, which means scaling up and then retracting."

"Lacks sufficient documentation and particularly in Spanish."

"It takes a long time to have a new version or release, similar to Oracle."

"The primary challenges customers face with IBM Db2 Warehouse are related to its complexity in usage. It requires highly skilled professionals who understand Db2, and both training and support are challenging to obtain."

"There were some initial challenges with IBM Db2 Warehouse about eight months ago when I worked in this environment. When I coordinated with IBM support, they mentioned that the memory was insufficient for our needs. Our business environment required significantly more memory than the previous cluster could provide. Consequently, we have worked closely with on-site IBM technical personnel to address this issue."

More IBM Db2 Warehouse cons

"Integration with XML is still not there for nzload utility."

"Community support. There was none, or very little, especially when using add-on software (e.g. building functions, MapReduce, R, Lua, etc.)."

"IBM Netezza Performance Server could improve its interface, support for big data, and APA-based connectivity should be available."

"Concurrency was an issue. If you run small queries it runs well, and the performance is good, however, when you run multiple long queries or multiple joins, it has some concurrency issues."

"It’s a good product for analytical processing, but they need to conduct more seminars and hands-on training and events."

"Scalability of this solution is not possible."

"It is not designed to process a huge volume of data."

"Data lineage on column or even object level does not exist, therefore external applications have to be used"

More IBM Netezza Performance Server cons

Pricing and Cost Advice

"In a traditional on-prem database, in a data warehouse, the solution is probably on the expensive side."

"The pricing is very expensive. It has a lot CPUs with a lot of components in it. It also has built-in redundancy for resiliency reasons."

"For me, mainly, it reduces my costs. It's not only the appliance cost. There are also support costs and a maintenance costs. It does reduce the costs very drastically."

"The annual licensing fees are twenty-two percent of the product cost."

"The solution has a yearly licensing fee, and users have to pay extra for support."

"Expensive to maintain compared to other solutions."

"Netezza is a costly solution. It does serve a specific purpose but it's costlier than what's available in the market, if you go to the cloud."

See which vendors are best for you

Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.

See recommendations

900,644 professionals have used our research since 2012.

Comparison Review

it_user232068

Senior Data Architect at a pharma/biotech company with 1,001-5,000 employees

Aug 5, 2015

Netezza vs. Teradata

Original published at https://www.linkedin.com/pulse/should-i-choose-net Two leading Massively Parallel Processing (MPP) architectures for Data Warehousing (DW) are IBM PureData System for Analytics (formerly Netezza) and Teradata. I thought talking about the similarities and differences…

Read full review

Top Industries

By visitors reading reviews

Financial Services Firm

27%

Construction Company

Manufacturing Company

Government

Financial Services Firm

19%

Manufacturing Company

11%

Construction Company

10%

Comms Service Provider

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	5
Midsize Enterprise	3
Large Enterprise	5

By reviewers
Company Size	Count
Small Business	9
Midsize Enterprise	6
Large Enterprise	33

Questions from the Community

What is your experience regarding pricing and costs for IBM Db2 Warehouse?

The pricing for medium and large environments is almost the same as Oracle. I rate the pricing as six out of ten.

What needs improvement with IBM Db2 Warehouse?

What is your primary use case for IBM Db2 Warehouse?

The main advantages of IBM Db2 Warehouse become apparent when dealing with business intelligence applications. I worked with it when it was installed for one of our customers, a utilities company, ...

What needs improvement with IBM Netezza Performance Server?

What is your primary use case for IBM Netezza Performance Server?

I use this solution as a data warehouse.

What advice do you have for others considering IBM Netezza Performance Server?

The solution has generally received positive feedback from me and is recommended for continued use by end users. However, the product cost is high compared to others in the market, and this cost ha...

Snowflake vs IBM Db2 Warehouse

Comparisons

Compared 11% of the time

BigQuery vs IBM Db2 Warehouse

Compared 9% of the time

Amazon Redshift vs IBM Db2 Warehouse

Compared 8% of the time

Oracle Exadata vs IBM Db2 Warehouse

Compared 8% of the time

Infobright DB vs IBM Db2 Warehouse

Compared 4% of the time

More IBM Db2 Warehouse Competitors

Snowflake vs IBM Netezza Performance Server

Compared 8% of the time

Teradata vs IBM Netezza Performance Server

Compared 6% of the time

Oracle Exadata vs IBM Netezza Performance Server

Compared 5% of the time

Apache Spark vs IBM Netezza Performance Server

Compared 5% of the time

OpenText Analytics Database (Vertica) vs IBM Netezza Performance Server

Compared 5% of the time

More IBM Netezza Performance Server Competitors

Product Reports

IBM Db2 Warehouse

Download IBM Db2 Warehouse product report

IBM Netezza Performance Server

Download IBM Netezza Performance Server product report

Also Known As

InfoSphere Warehouse, IBM InfoSphere Warehouse

Netezza Performance Server, Netezza, Netezza Analytics

Overview

IBM Db2 Warehouse provides scalable and efficient data handling, offering rapid data processing, excellent integration capabilities, and strong security. Its compatibility with cloud environments and robust analytics make it ideal for enterprises requiring high-performance transaction processing.

IBM Db2 Warehouse is recognized for its big data scalability and fast response times. Its support for ETL processes and robust security measures ensures consistent data handling. Easy installation and a powerful analytics engine facilitate forecasting, making it practical for high-volume transactions. It supports Windows and Linux, offering a flexible yet resilient environment. However, improvements are needed in separating compute from storage, interface usability, and Spanish documentation. Users may experience delays in support response and challenges with publication and backup issues, highlighting the need for enhanced training resources and user-friendly troubleshooting tools. Though related to Oracle, IBM Db2 Warehouse may benefit from improved user guidance and online resources.

What are the standout features of IBM Db2 Warehouse?

Scalability: Effectively handles big data volumes.
Integration: Seamlessly works with multiple platforms, including IBM Cognos.
Analytics Engine: Robust tools support forecasting and advanced analytics.
Security: Offers strong security measures for data protection.
Cloud Compatibility: Deployable on IBM Cloud with ease.

What benefits and ROI should users consider?

Data Processing Speed: Fast response boosts efficiency.
Reliability: High volume transactions are managed efficiently.
Analytics Power: Enhances decision-making with data analytics capabilities.
Deployment Flexibility: Supports Windows and Linux systems.

IBM Db2 Warehouse is implemented across industries for data warehousing, reporting, and analytics, notably benefiting businesses focusing on utilities usage prediction and growth analysis. Its integration with IBM Cognos enhances report generation, while its support for star or snowflake schemas optimizes high-volume data management, providing a solid foundation for data-driven decision-making in business intelligence applications.

IBM

IBM Netezza Performance Server offers high performance, scalability, and minimal maintenance. It seamlessly integrates SQL for efficient data processing, making it ideal for enterprise data warehousing needs.

IBM Netezza Performance Server is known for its outstanding data processing capabilities. Its integration of FPGA technology, compression techniques, and partitioning optimizes query execution and scalability. Users appreciate its appliance-like architecture for straightforward deployment, distributed querying, and high availability, significantly boosting operations and analytics capabilities. However, there are areas for improvement, particularly in handling high concurrency, real-time integration, and specific big data functionalities. Enhancements in database management tools, XML integration, and cloud options are commonly desired, along with better marketing and community engagement.

What are the key features of IBM Netezza Performance Server?

High Performance: Offers fast query execution using advanced hardware integration.
Scalability: Designed to handle expanding data needs efficiently.
Seamless Data Loading: Enables simple and quick loading of large datasets.
ANSI-compliant SQL: Supports standardized SQL for easy integration with existing tools.
Efficient Architecture: Appliance-based for easy deployment and hands-off administration.

What are the benefits and ROI to consider?

Minimal Maintenance: Reduces administrative overhead with reliable setup.
Comprehensive IBM Support: Provides robust problem-solving resources.
High Availability: Ensures uninterrupted operations and consistent performance.
Enhanced Analytics Capabilities: Drives analytics and reporting processes effectively.

Industries rely on IBM Netezza Performance Server for robust data warehousing solutions, particularly in sectors requiring intensive data analysis such as finance, retail, and telecommunications. Organizations use it to power business intelligence tools like Business Objects and MicroStrategy for customer analytics, establishing data marts and staging tables to efficiently manage and update enterprise data. With the capacity to handle large volumes of compressed and uncompressed data, it finds numerous applications in on-premises setups, powering data mining and reporting with high reliability and efficiency.

IBM

Sample Customers

Alameda County Social Services Agency, Sui Southern Gas Company Limited

Seattle Childrens Hospital, Carphone Warehouse, Vanderbilt University School of Medicine, Battelle, Start Today Co. Ltd., Kelley Blue Book, Trident Marketing, Elisa Corporation, Catalina Marketing, iBasis, Barnes & Noble, Qualcomm, MediaMath, Acxiom, iBasis, Foxwoods

IBM Db2 Warehouse vs. IBM Netezza Performance Server