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 Dbspaces
for temporary tables and sort files illustrates.
You can list dbspaces that contain regular tables in DBSPACETEMP.
Figure 1: Dbspaces
for temporary tables and sort files