Configuring database storage for Db2 Warehouse

Db2® Warehouse supports a variety of both traditional and software-defined storage types. You define your storage types during database provisioning.

The following diagram shows the supported storage types for Db2 Warehouse SMP.

The following diagram shows the supported storage types for Db2 Warehouse MPP.

For a full listing of supported storage types, see Certified storage options for Db2 Warehouse.

Notes:
  • When provisioning the database, for user data (the main database data), select ReadWriteOnce (RWO) access mode for your storage.
  • Select 4K sector size during provisioning if your storage supports 4K (this setting is mandatory for Portworx). Db2 Warehouse also supports 4K for OpenShift Data Foundation.
  • Appropriate host-attached SAN storage is usually the better performing option for OLTP workloads. For a comparison of NAS versus SAN storage, see Storage technologies for IBM Db2 Warehouse.
  • If you are using Security Enhanced Linux®, see one of the following topics:
  • For more information about configuring dynamic provisioning for NFS storage for testing, see the External Storage topic in the kubernetes-incubator repository on GitHub.
  • For more information about configuring a hostPath for data storage, see HostPathVolumeSource in the Red Hat® OpenShift documentation.