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, so you can focus on data analysis and delivery instead of administration. The service also includes 24x7 monitoring of the database and infrastructure.
How do I purchase IBM 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 we’ll 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 our aggressive discounting program for 1- and 3-year commits, contact your IBM Sales Representative. You can also connect directly with our sales team through the “Let’s talk” button at the bottom right of this page, and selecting “Chat with a rep.”
What cloud providers does Db2 Warehouse on Cloud support?
Currently, IBM 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 connect directly with our sales team through the “Let’s talk” button at the bottom right of this page, and selecting “Chat with a rep.”
What compatibility does Db2 Warehouse on Cloud offer with on-premises databases, such as Netezza and Oracle?
Db2 Warehouse on Cloud offers the highest Netezza compatibility of all cloud data warehouse vendors, including near-100% compatibility for DDL, DML, and even NZPLSQL stored procedures. 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.
How do I load data into IBM 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 Db2 Warehouse on Cloud’s 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.
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 Db2 Warehouse on Cloud’s 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.
What security compliances does IBM Db2 Warehouse on Cloud support?
Db2 Warehouse on Cloud supports several security compliances, such as ISO 27001, SOC 2, and HIPAA. Visit this page to see the most updated list of compliances.
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 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.
What monitoring tools are available for Db2 Warehouse on Cloud?
The console that is included with Db2 Warehouse on Cloud provides detailed monitoring information on currently running statements, connected applications, and user and storage usage. By using IBM Data Server Manager 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 round-the-clock automated monitoring of your Db2 Warehouse on Cloud system. Data Server Manager is free of charge, and can be downloaded here.
Does Db2 Warehouse on Cloud offer native geospatial capabilities?
Yes. Db2 Warehouse on Cloud supports various spatial data types. Our Knowledge Center can tell you more.
Proofs of concept
Did you know that IBM offers proofs of concept for Db2 Warehouse on Cloud?