Configuring database storage for Db2

Db2® 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.

Diagram showing supported storage types for Db2 Advanced Edition

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

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 also supports 4K for OpenShift® Container Storage.
  • 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.