How does DB2 calculate the CPU speed of the system (CPUSPEED dbm cfg parameter value) ?
When creating a DB2 instance, DB2 runs a small calibration test multiple times to assess the CPU speed. The average time from these tests are used to calculate the CPU speed. There is a bit of science to these tests. The tests are run within the duration of a quantum of time that the operating system scheduler provides to ensure the CPU calibration tests are valid regardless of how busy the system is when they run. Customers can change the CPU SPEED value to a desired value or let DB2 recalculate it by setting the value to -1 (negative 1). C.
Related Questions
- You have a system with two CPUs and the database is experiencing latch contention. Which initialization parameter can you check to find the number of redo copy latches currently assigned?
- Why does the System Properties dialog box display the CPU speed as 849MHz or 848MHz even though I have an 850MHz CPU and power management is disabled?
- How does DB2 calculate the CPU speed of the system (CPUSPEED dbm cfg parameter value) ?