Using multiple disks for a dbspace

Using multiple disks for a dbspace helps to distribute I/O across dbspaces that contain several small tables.

A dbspace can include multiple chunks, and each chunk can represent a different disk. The maximum size for a chunk is 4 terabytes. This arrangement allows you to distribute data in a dbspace over multiple disks. Figure 1 shows a dbspace distributed over three disks.
Figure 1. A dbspace distributed over three disks
This figure is described in the surrounding text.

Because you cannot use this type of distributed dbspace for parallel database queries (PDQ), you should use the table-fragmentation techniques described in Distribution schemes to partition large, high-use tables across multiple dbspaces.


Copyright© 2019 HCL Technologies Limited