Administration Guide

Enabling Utility Parallelism

This section provides an overview of how to enable intra-partition parallelism for the following utilities:

• Load
• Create index
• Backup database / table space
• Restore database / table space

Inter-partition parallelism for utilities occurs automatically based on the number of database partitions.

Load

To enable parallelism while loading data, use the following parameters on the LOAD command:

• CPU_PARALLELISM
• DISK_PARALLELISM

See the Command Reference for information on the LOAD command.

Create Index

To enable parallelism when creating an index:

• The INTRA_PARALLEL database manager configuration parameter must be ON
• The table must be large enough to benefit from parallelism

See the SQL Reference for information on the CREATE INDEX statement.

Backup Database / Table Space

To enable parallelism when backing up a database or table space:

• The INTRA_PARALLEL database manager configuration parameter must be ON

To enable I/O parallelism when backing up a database or table space:

• Use more than one target media
• Configure table spaces for parallel I/O

See the Command Reference for information on the BACKUP DATABASE command.

Restore Database / Table Space

To enable parallelism when restoring a database or table space:

• The INTRA_PARALLEL parameter must be ON

To enable I/O parallelism when restoring a database or table space:

• Use more than one source media
• Configure table spaces for parallel I/O

See the Command Reference for information on the RESTORE DATABASE command.

[ DB2 List of Books | Search the DB2 Books ]