Communications Bandwidth (comm_bandwidth)

Configuration Type Database manager Applies to Partitioned Database Server with local and remote clients Parameter Type Configurable Default [Range] -1 [ 0 - 1 ] A value of -1 causes the parameter value to be reset to the default. The default value is calculated based on whether a high speed switch is being used.

The value calculated for the communications bandwidth is used by the SQL optimizer to estimate the cost of performing certain operations.

You can explicitly set this value to model a production environment on your test system or to assess the impact of upgrading hardware.

Recommendation: You should only adjust this parameter if you want to model a different environment.

The communications bandwidth is used by the optimizer in determining access paths. You should consider rebinding applications (using the REBIND PACKAGE command) after changing this parameter.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]