This blog will explain how the summarized table column can be recalculated.
The goal is to convert from a non-computed table column to calculated table columns
It is important to make a backup
There are situations where the calculation of the columns in the summarized tables should be changed.
On the one hand because one needs a different calculation or because the function does not exist.
The following site can be used as a basis
Please note these steps are not supported or tested.
The next steps reflect my test.
To change the calculation, the following steps must be carried out
1: Search for the application support file (ODI) dock <pc>
2: Backup the application support file dock <pc>
3: Change the parameter * BEHAV: from the attribute which is to be recalculated
4: Replace the application support file dock <pc>
5: Stop the historical collection in the tep client
6: Backup and drop the tables in the warehous db that needs to be changed
7: Stop tivoli portal server (TEPS) and reseed the application support file
8: Restart of portal server (TEPS)
9: Start the historical collection
Describes the content of the data. You can only specify the BEHAV keyword for a numeric attribute type, such as Counter or Gauge. This keyword is used at the column level. The following list shows the valid values:
A range-based number (such as a percentile).
An enumerated list of options that refers to the condition of the resource, such as up or down.
The number of iterations that have passed. The counter can be reset.
A characteristic of the resource that rarely changes, such as the amount of memory or processor speed.
The smallest value reported over a particular period of time.
The largest value reported over a particular period of time.
Deltas pre-calculated by the application as measured over a particular period of time.
The number of averaged readings by the Summarization and Pruning Agent. By default, the SampleCount is stored in the SAMPLECOUNT column.
The change is shown to the linux application support file docklz -> exchange *BEHAV: PROPERTY --> *BEHAV: GAUGE
Application support file
Contents: source definition
*CAPTION: Kernel Priority
*BEHAV: PROPERTY <----- static value/ No calculation
*TEXT: Kernel scheduling priority (0 - Highest)
Contents: target definition
*CAPTION: Kernel Priority
*BEHAV: GAUGE <----- calculation MIN_/SUM_/AVG_/MAX_
*TEXT: Kernel scheduling priority (-100 = Highest). Negative values are
*TEXT: used by real-time processes.
=> replaced the dock<lz> application support file
=> stop the historical collection in the tep client
=> backup / droped the tables ITMUSER.KLZ_Process_H|_D|_M ...
=> reseed the application support restart the teps and wait until the wpa collect data
=> wait until the sy agent launch the first time
the sy agent created new trables with different columns that are refect the new calculation