Spreading temporary tables and sort files across multiple disks

You can spread the I/O associated with temporary tables and sort files across multiple disks, after defining dbspaces for temporary tables and sort files. This can improve performance for applications that require a large amount of temporary space for temporary tables or large sort operations.

To define several dbspaces for temporary tables and sort files, use onspaces -t. When you place these dbspaces on different disks and list them in the DBSPACETEMP configuration parameter, you spread the I/O associated with temporary tables and sort files across multiple disks, as Figure 1 illustrates. You can list dbspaces that contain regular tables in DBSPACETEMP.
Figure 1. Dbspaces for temporary tables and sort files
This figure is described in the surrounding text.

Users can specify their own lists of dbspaces for temporary tables and sort files with the DBSPACETEMP environment variable. For details, see Configure dbspaces for temporary tables and sort files.


Copyright© 2019 HCL Technologies Limited