Managing the collection of history data

You can manage many aspects of history-data collection.

Changing the owner of a history database
Each database has an owner. To change the owner of a history database, alter both the database and the history configuration to reflect the new ownership.
Dropping a history database
As with any user database, you can drop a history database to remove it from your system. When you drop the database, all of its tables and views and all of the collected history information it contains are also dropped.
Starting the collection of history data
To start the collection of history data, issue the SET HISTORY CONFIGURATION command to change to a history configuration that collects data.
Stopping the collection of history data
To stop the collection of history data, issue the SET HISTORY CONFIGURATION command to activate a history configuration that does not collect history data.
Changing history configuration settings
Issue the ALTER HISTORY CONFIGURATION command to change the settings for a history configuration.
Displaying history configuration settings
Issue the SHOW HISTORY CONFIGURATION command to display information about the active configurations or about all configurations.
Dropping history configurations
You can use the DROP HISTORY CONFIGURATION command to remove a history configuration. You can drop a configuration that is not active.
Maintaining a history database
A history database grows as it accumulates history information. Plan for routine maintenance of the history database. Determine the amount of time that you need to keep the history data before you can archive or delete it (for example, keep only data for the current and previous month, or the current and previous quarter, or for the current year only).

Parent topic: Collecting data history