IBM Books

Data Movement Utilities Guide and Reference


Parallelism and Loading

The load utility takes advantage of a hardware configuration in which multiple processors or multiple storage devices are used, such as in a symmetric multiprocessor (SMP) environment. There are several ways in which parallel processing of large amounts of data can take place using the load utility. One way is through the use of multiple storage devices, which allows for I/O parallelism during the load operation (see Figure 3). Another way involves the use of multiple processors in an SMP environment, which allows for intra-partition parallelism (see Figure 4). Both can be used together to provide even faster loading of data. For more information, see Optimizing Load Performance.

Figure 3. Taking Advantage of I/O Parallelism When Loading Data

IMAGE4


Figure 4. Taking Advantage of Intra-partition Parallelism When Loading Data

IMAGE2



[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]