DB2 10.5 for Linux, UNIX, and Windows

cpuspeed - CPU speed configuration parameter

This parameter reflects the CPU speed of the machine(s) the database is installed on.

Configuration type

Database manager

Applies to

Database server with local and remote clients
Database server with local clients
Partitioned database server with local and remote clients

Parameter type

Configurable online

Propagation class

Statement boundary

Default [range]

-1 [ 1x10^-10 - 1 ] A value of -1 will cause the parameter value to be reset based on the running of the measurement program.

Unit of measure

Milliseconds

This program is executed if benchmark results are not available if the data for the IBM® RS/6000® model 530H is not found in the file, or if the data for your machine is not found in the file.

You can explicitly set this value to model a production environment on your test system or to assess the impact of upgrading hardware. By setting it to -1, cpuspeed will be re-computed.

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

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