The dataflow components that display on the DB2 for LUW (Linux, Unix, and Windows) database, database partition, or instance home page on your Spotlight desktop show the rate of different types of dataflows in your system over time. The speed of a home page dataflow varies based on the volume of data being transferred within the database or the instance. The greater the data traffic, the faster the flow.
Each home page dataflow corresponds to a type of dataflow in your database, partition, or instance. In order that home page dataflows represent actual dataflows in your system accurately, Spotlight must know the normal range of activity for this system. For example, if the normal range of a specific type of data flow in your database during a specific span of time is from 0 to 100, a value of 8 is slow¾the corresponding home page dataflow moves slowly. However, if the range is from 0 to 10, a value of 8 is very fast¾the home page dataflow moves much faster.
Spotlight provides a calibration tool that calculates the normal range of dataflows in your connection¾that is, in the database or database partition to which you are connected and in the instance to which this database or partition belongs. When you start the calibration process, Spotlight measures the flow of data through your system over a set period of time. It then uses this data to set the upper limit of each dataflow on the database or database partition home page and on the corresponding instance home page. (Spotlight always uses zero as the lowest value when calculating the normal range of values for your system.)
The first time you open a connection you created in Spotlight, the calibration window is displayed, prompting you to enter a length of time for the calibration. After you provide the information and close the window, the calibration process begins.
You can set up a connection to a multiple-partition DB2 for LUW database is several ways. The way the connection is configured determines how the calibration process is run:
During the course of a calibration the user may still cancel, change, or stop the calibration process. The action (cancel, change, stop) affects the database and its associated partitions in the following ways:
Spotlight automatically runs calibration when you open a open a connection for the first time in Spotlight database for the first time. However, you can choose to run the calibration at any time.
If the data traffic in your database or database partition has increased or decreased significantly since you last ran a calibration, calibrate that system again so that your home page dataflows accurately depict your system’s activity.
When you disconnect from the database or database partition connection, you are prompted to save any connection changes. This save includes the calibration values for the connection home pages. The calibration values for the connection are used until you change them or until you perform another calibration.