Multiplexing

Multiplexing uses parallel access points to data on the database server. This configuration is useful when tape drives are used during database backup operations on the backup server.

Figure 1. Multiplexing
This graphic shows the principle of multiplexing. On the left side of the graphic, the database server allows parallel access to the database. The network and the IBM Spectrum Protect server are not affected.

The value of keyword MULTIPLEXING defines the number of files that are read in parallel within a single session. Appropriate MULTIPLEXING values are expected in the range of 1 to 4. The best value for your environment depends on the I/O rate of your disks, the location of your data on the disks, the network capacity, the throughput rate of the storage media, and the compression setting. If the MULTIPLEXING value is too high, the processing that occurs might offset any performance gain.