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.