Best practices for deploying Db2 Warehouse on Azure

When deploying Db2® Warehouse on Azure, be sure to choose the optimal compute environment and storage file system.

Compute environment

When using Azure with Db2 Warehouse, it is highly recommended that you use a memory-optimized VM instance, because such instances work very well for in-memory analytics and offer a high memory-to-CPU ratio.

Storage file system

When configuring for storage, choose Azure managed disks. For production workloads, use premium storage disks if possible; otherwise, use standard disks.

Managed disks offer the following benefits over non-managed disks:
  • Backup capability
  • Simplicity
  • Scalability
  • High durability
  • High availability
A Db2 Warehouse MPP setup on Azure requires two separate volumes:
bludata0
This is a local attached disk for the table data. Attach a managed disk to each MPP node.
blumeta0
This is a shared cluster for the database engine instance path or the metadata.