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.
Note: The smaller the number, the faster the CPU speed.
Unit of measure
Milliseconds per instruction

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.