Creating separate storage for temporary table spaces in Db2

Important: IBM Cloud Pak for Data Version 4.6 will reach end of support (EOS) on 31 July, 2025. For more information, see the Discontinuance of service announcement for IBM Cloud Pak for Data Version 4.X.

Upgrade to IBM Software Hub Version 5.1 before IBM Cloud Pak for Data Version 4.6 reaches end of support. For more information, see Upgrading IBM Software Hub in the IBM Software Hub Version 5.1 documentation.

You can dedicate a separate storage area for temporary table spaces on the Db2® pod to reduce I/O bottlenecks and improve performance.

Procedure

When you deploy the Db2 service, on the Temporary table space storage page of the web console specify the following values:
  • Create new storage
  • Use storage template
  • Storage class: Choose manage-nfs-storage, ocs-storagecluster-ceph-rbd, or portworx-db2-rwo-sc.
  • Size: Your chosen value between 1 and 1,000 GiB.