Creating separate storage for temporary table spaces in Db2 Warehouse

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

Procedure

When you deploy the Db2 Warehouse 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.