Load Historical Data Prior to Initial Data Collection
This optional procedure is intended to be used only if you want to load the historical data from a CommServe database. This utility must be run prior to the first data collection. It prompts you for the number of hours to go back in time within the historical data and then configures data collection to capture that data.
To configure data collection to capture historical data, follow these steps.
1. At the command line, go to the database tools directory.
cd <HOME>\database\tools
2. Login to SQL Plus.
sqlplus portal/portal
3. Run the utility that configures the Data Collector to look for historical data. This utility only prompts you to enter hours and then configures data collection accordingly.
SQL> @cmv_update_max_lookback_hours.sql
Enter value for hours: 12
old 1: UPDATE ptl_system_parameter SET param_value = &hours WHERE
param_name='
CMV_MAX_LOOK_BACK_HRS'
new 1: UPDATE ptl_system_parameter SET param_value = 12 WHERE
param_name='CMV_
MAX_LOOK_BACK_HRS'
Commit;
1 row updated.
Commit complete.
4. Exit SQL Plus.
SQL> exit