Help

Db2 Warehouse

A fully managed, elastic, cloud data warehouse built for high-performance analytics and AI.
Type
  • Service
Provider
  • IBM
Updated on
  • 02/10/2025
Category
  • Storage
  • Databases
  • Developer tools
Compliance
  • IAM-enabled
Location
  • Sydney (au-syd)
  • Frankfurt (eu-de)
  • Dallas (us-south)
  • Sao Paulo (br-sao)
  • Tokyo (jp-tok)
  • Washington DC (us-east)
Related Links

Platform

Choose which network and compute environment to run your database on

      Product description

      Select an initial resource allocation preset, or customize your deployments resources. Displayed prices do not include tax. Monthly prices shown are for the United States.

    • Highly scalable, fully managed cloud data warehouse designed for mission critical, always-on workloads that require high performance and high reliability
    • Scale compute up to 5760 vCPUs and take advantage of multi-tiered storage options to support any size of workload
    • Native support for petabyte scale cloud object storage (AWS S3) with advanced caching to reduce cost of data storage without affecting performance
    • Scale analytics and AI across the enterprise through integration with watsonx.data
    • Securely share data across your ecosystem with support for open data formats such as Parquet and ORC
    • License

    • On Demand license model is a consumption-based, license-included option that charges for compute on an hourly basis.
    • 1-Year and 3-Year Reserve provides substantial savings over On Demand with 1 or 3 year commitments.
    • Bring Your Own License (BYOL) option allows you to save on compute when you bring a participating software license to the cloud.
    • IBM Integrated Analytics System (IIAS) allows you to leverage your appliance investment to reduce the cost of compute for this instance.
    • License Type
      Savings over On Demand
      On-demand (license included)0%
      1 year reserve (license included)26%
      3 years reserve (license included)44%
      Bring your own license (BYOL)28%
      Integrated Analytics System (IIAS)51%

      Resource allocation

      Select an initial resource allocation preset, or customize your deployments resources.

      Compute

      Configure compute nodes for performance.

      Type
      Open menu

      Storage

      Db2 columnar tables now run natively on object storage (Amazon S3). If you need to run row organized tables or create indexes on your tables, allocate and deploy your data to block storage. A minimum amount of block storage is required depending on your selected configuration. Estimate what your costs could look like by entering your hypothetical storage size for both object and block storage.

      0.04TB600TB
      Select your desired configuration size first.

      Snapshot Backups

      Db2 Warehouse takes automatically scheduled snapshot backups of both block storage and object storage provisioned as part of the service. Estimate what your backup costs could look like by entering your expected data change rate and number of backups to retain. Configure your backup retention in the web console, after deployment.


      0%100%

      You will only be charged based on usage regardless of current selection.

      Add-ons

      Create a database instance in a dedicated virtual network managed by IBM. Open a support case if you're interested. Add to estimate to see what your costs could look like.

    • Configure with Oracle compatibility, so applications written for an Oracle database can run on Db2 Warehouse seamlessly.

      Summary

      • Db2 Warehouse
        • Location: Dallas
        • Service name:
        • Resource group:
      • Compute$0.00
        • 0 vCPUs compute
        • License included: On Demand0% savings
      • Object Storage$0.00
        • Projected estimation: 0 TB storage
      • Block Storage$0.00
        • 0 TB storage
      • Backups$0.00
        • Projected estimation
        • 1 backups retained
        • 3% of data changing per backup
      • Add-ons$0.00
      • Per month$0.00
      • Total per year$0.00