Certified storage options for Db2

Db2® on Red Hat OpenShift provides a broad range of certified storage options.

Certified storage options for Db2 shows the certified storage options and their deployment requirements.

Table 1. Certified storage options for Db2
Certified storage Deployment requirements
IBM Spectrum® Scale Container Storage Interface 2.0 or higher

For more information, see IBM Spectrum Scale.

Split storage:
System/backup data
  • ibm-spectrum-scale-csi storage class
  • ReadWriteMany (RWX)
User data
  • ibm-spectrum-scale-csi storage class
  • 4K sector size
  • ReadWriteOnce (RWO)
Portworx 2.9.1.3

For more information, see Creating Portworx storage classes.

Split storage:
System/backup data
  • portworx-db2-rwx-sc storage class
  • ReadWriteMany (RWX)
User data
  • portworx-db2-rwo-sc storage class
  • You must specify 4K block size.
  • ReadWriteOnce (RWO)
OpenShift® Data Foundation 4.12

For more information, see the OpenShift documentation.

You can enable two-way replication on Db2 for better performance. Note that three-way replication is the default, and you need to manually enable for two-way replication. To create a storage class enabled with two-way replication, follow the steps listed in the Red Hat OpenShift documentation on Creating storage classes and pools.

Split storage:
System/backup data
  • ocs-storagecluster-cephfs storage class
  • ReadWriteMany (RWX)
User data
  • ocs-storagecluster-ceph-rbd storage class
  • 4K sector size
  • ReadWriteOnce (RWO)
Setting up IBM Cloud File Storage ibmc-file-gold-gid storage class
Traditional storage:
  • NFS
  • Local storage
Elastic File System (EFS) and Elastic Block Store (EBS): Shared Storage for meta and backup (EFS):
  • Parameters:
    • uid: 0
    • gid: 0
    • directoryPerms: "777"
    • provisioningMode: efs-ap
    • fileSystemID: <efs filesystem id>
Database Storage, Transactional logs, Temporary TableSpaces (EBS)