Frequently asked questions

Get answers to the most commonly asked questions about this product.

What does IBM Db2 Warehouse on Cloud manage for me?

The IBM® Db2® Warehouse on Cloud team manages deployment, encryption, database backups, maintenance and upgrades for your data warehouse. This means you can focus on data analysis and delivery instead of administration. The service also includes 24x7 monitoring of the database and infrastructure.

What cloud providers does Db2 Warehouse on Cloud support?

Currently, Db2 Warehouse on Cloud can be deployed to IBM Cloud® and Amazon Web Services (AWS).

Can I work with IBM on a proof-of-concept (POC)?

Yes, Db2 Warehouse on Cloud offers free POCs. If you’re interested in running a POC with us, please contact your IBM Sales Representative, or contact us through this site.

What compatibility does Db2 Warehouse on Cloud offer with Oracle on-premises databases?

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

How do I load data into Db2 Warehouse on Cloud?

There are several ways to load data into Db2 Warehouse on Cloud. You can easily load small files from your desktop through the Db2 Warehouse web console. We support various IBM data movement and integration tooling, such as IBM Lift CLI for over-the-wire, high-speed data migration, IBM Database Conversion Workbench for schema migration, IBM Mass Data Migration Service for high-volume ingest, IBM InfoSphere® DataStage for ETL and IBM Change Data Capture for database replication.  In addition, we support various third-party data integration tools, including Informatica, Microstrategy, SAP Business Objects, Segment, Talend, Tableau and SAS.

How can I scale the storage and compute capacity of my Db2 Warehouse on Cloud system?

With the Db2 Warehouse on Cloud Flex plans, you can independently scale storage capacity and compute cores for your Db2 Warehouse on Cloud system using a UI or REST API. The REST API provides a simple way to automate scaling operations.

What monitoring tools are available for Db2 Warehouse on Cloud?

The console that is included with the product provides detailed monitoring information on currently running statements, connected applications, and user and storage usage. By using IBM Db2 Data Management Console connected to a Db2 Warehouse on Cloud system, users have access to advanced diagnostic real-time and historical monitoring, statement tracking and optimization, application locking details, storage, memory, and over 20 other KPIs. Numerous alerts for performance optimization and availability are also available for around-the-clock automated monitoring of your Db2 Warehouse on Cloud system. Db2 Data Management Console is packaged with all Db2 editions at no extra charge and comes set up out of the box.

How do I purchase Db2 Warehouse on Cloud and what payment options do I have?

You can purchase Db2 Warehouse on Cloud directly through the IBM Cloud Catalog and start provisioning your system right away. Billing for Db2 Warehouse on Cloud systems purchased through the IBM Cloud Catalog is done on an hourly basis.

If you want to discuss specific technical requirements or explore the aggressive discounting program for 1- and 3-year commits, contact your IBM sales representative, or connect with the IBM sales team directly through this site.

What security compliance programs does Db2 Warehouse on Cloud support?

Db2 Warehouse on Cloud supports several security compliance programs, such as ISO 27001, SOC 2 and HIPAA.

How do I keep my Db2 Warehouse on Cloud data safe and secure?

At the database level, data is encrypted at rest and in motion by default. In addition, all Db2 Warehouse on Cloud plans come with robust row and column access control capabilities, as well as the ability to define audit policies. Db2 Warehouse on Cloud also supports various private networking options, such as VPN, private IP deployment and IBM Cloud Direct Link.

Does Db2 Warehouse on Cloud offer an uptime service-level agreement (SLA)?

Yes. Aside from the entry plan, all Db2 Warehouse on Cloud plans are financially assured by an uptime SLA.

How can I manage backups for Db2 Warehouse on Cloud?

Snapshot backups are taken every day for the Db2 Warehouse on Cloud Flex plans. You can use the Db2 Warehouse web console, which is accessible through your IBM Cloud dashboard or direct URL, to schedule when snapshot backups are taken.

How does Db2 Warehouse on Cloud handle highly concurrent workloads?

The Db2 Warehouse engine includes an adaptive workload management technology that automatically manages job scheduling and concurrency based on the resource demands and expected response times of individual jobs. This technology is included as part of Db2 Warehouse on Cloud.

Does Db2 Warehouse on Cloud have any in-database machine learning capabilities?

Yes. With Db2 Warehouse on Cloud, you can train and run machine learning (ML) models directly in memory, without needing to move the computation to an external engine. You can leverage a wide variety of supervised and unsupervised ML models, such as linear regression, k-means, k-nearest neighbors, naïve Bayes and association rules. You can also call these procedures using Python or R.

Does Db2 Warehouse on Cloud offer native geospatial capabilities?

Yes. Db2 Warehouse on Cloud supports various spatial data types.