Frequently asked questions

FAQ

Getting started with this product

Where can I find what's new around IBM Db2 Warehouse if I want to upgrade or if I'm new to the product?

The current release of IBM Db2® Warehouse supports the new features and functions detailed in the link below. Any changed or deprecated functions that require changes on the client side are also noted here.

How do I set up Db2 Warehouse?

Following the guidance on the Knowledge Center on how to deploy the Db2 Warehouse on-premises product.

Can I get a developer edition or free version for Db2 Warehouse?

Yes, we encourage everyone to try out the Db2 Warehouse Developer Edition for the on-premises product. We work closely with developers and the open source community. They are a huge part of our ecosystem. Follow this link to download it.

Can I install Db2 Warehouse on a single node or laptop?

Yes. Db2 Warehouse has been designed with a variety of personas in mind, including developers, designers, analysts, data scientists and more. The simplicity of the Docker container lets users get started quickly on a Windows or Mac — and as a single node instance. Follow the link for detailed information.

How is Db2 Warehouse licensed and how can it be monitored?

You can easily manage and view the license usage within the Db2 Warehouse console. A VPC is a virtual processor core available to a Virtual Server Operating System or one VPC for each physical core of a non-partitioned physical server.

Does IBM offer a stand-alone installation of Db2 Warehouse without having to pull the image from the Docker Store?

You can download the Developer Edition here. You can also work with your IBM Client Representative or open a support ticket to request access to the stand-alone image that is staged on a Box folder.

What compatibility does Db2 Warehouse offer with on-premises databases, such as Netezza or Oracle?

Db2 Warehouse has built-in IBM PureData® System for Analytics (Netezza®) compatibility, which makes migrating Netezza appliance workloads fairly seamless. IBM also provides a tool to check the overall compatibility readiness. IBM offers a best-in-line Migration Center of Excellence that can assist with your needs and timeline.

In addition, Db2 Warehouse can be provisioned with Oracle compatibility, which allows applications written for an Oracle database to run on Db2 without needing to be rewritten.

Learn more about Netezza to Db2 Warehouse migration

Learn more about Db2 Warehouse Oracle compatibility features

Support

Where can I get my questions answered by product experts?

IBM has a forum that you can join and post your questions to get them answered by top product experts of the Db2 Warehouse community.

Have an idea or question you want to share about Db2 Warehouse?

At our Request for Enhancement Community, you have an opportunity to collaborate directly with the IBM product development teams and other product users. Help us improve IBM Db2 Warehouse. We want to hear from you.

Where can I go if I have a usage error or support issue with my product?

If you encounter a usage error or other support issue, you can use these troubleshooting and support resources below to help resolve the problem.

Db2 Warehouse support

What is the support policy and fix pack schedule?

Db2 Warehouse is on a continuous delivery model. IBM releases updates on a monthly basis. Updates comprise new features and bug fixes.

Can I use Db2 Warehouse for production use to support petabyte scale data warehouse?

Yes. Db2 Warehouse is production-grade, robust data warehouse to meet your development and enterprise production needs. It can easily grow from few terabytes to petabytes in size. Read how an IBM client is using Db2 Warehouse in production.

What are the key platforms that support Db2 Warehouse?

Db2 Warehouse is supported on any platform where Docker is supported. Currently, you can deploy it on x86 (Microsoft Windows, Macintosh, Linux®), Power and Linux on IBM z Systems®, Power Linux platform and Linux on Z.