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.