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.