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.

Figure 1. Database storage for Db2 Warehouse SMP
Diagram of storage types for Db2 Warehouse SMP

Figure 2. Database storage for Db2 Warehouse MPP
Diagram of storage types for Db2 Warehouse MPP

The preceding diagrams illustrate the storage configuration options for Db2 Warehouse.

Mandatory storage:
  • System data is the shared (RWX) volume for Db2 Warehouse metadata, also referenced as Meta.
  • User data is the non-shared (RWO) volume for database storage, also referenced as Data.
Optional storage:
  • Backup - shared (RWX) volume for database backups
  • Activelogs - non-shared (RWO) volume for transactional logs
  • Tempts - non-shared (RWO) volume for temporary tablespaces
  • Archivelogs - non-shared (RWO) volume for archive logs
  • Auditlogs - shared (RWX) volume for audit logs

For a full listing of supported storage types, see Storage requirements.

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.
  • 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 a comparison of NAS versus SAN storage, see Storage technologies for IBM Db2 Warehouse.