If the existing processors are fully utilized much of the time, consider installing one or more additional processors in your machine. To allow the DB2 database manager to take advantage of the new processors, there are configuration parameters that should be reviewed and perhaps updated. (Some operating systems, like Solaris, can dynamically vary processors on- and off-line.) The parameters that are used to determine the number of processors used and may need to be updated include:
You should also consider the parameters associated with applications that may need to be updated. See Parallel Processing of Applications for more information.
When working in an environment where TCP/IP is used for communication, you should consider the value for the DB2TCPCONNMGRS registry variable. See Appendix D, DB2 Registry and Environment Variables for more information on this variable.
Utilities in DB2 such as load, backup, and restore can take advantage of the additional processors. See Chapter 19, Recovering a Database or refer to Data Movement Utilities Guide and Reference for information on these utilities.