SET HISTORY CONFIGURATION

Use the SET HISTORY CONFIGURATION command to specify which history configuration settings are to take effect after the next Netezza Performance Server system restart. Until then, the current settings remain in effect. After the restart, the history loader process attempts to load any existing history data in the staging or loading area for the previous configuration. This command is run on the source system.

Syntax

Syntax for setting the history configuration:

SET HISTORY CONFIGURATION <config_name>

Input

The SET HISTORY CONFIGURATION command has the following input:

Table 1. SET HISTORY CONFIGURATION input
Input	Description
<`config_name`>	The name of the history configuration whose settings are to take effect after the next Netezza Performance Server system restart.

Outputs

The SET HISTORY CONFIGURATION command has the following outputs:

Table 2. SET HISTORY CONFIGURATION outputs
Output	Description
`SET HISTORY CONFIGURATION`	The command was successful.
`ERROR: permission denied`	You do not have the necessary permissions.
`ERROR: <config_name> not found.`	The specified configuration name cannot be found.

Privileges

You must be the admin user, or your account must have Manage Security permissions to set a history configuration.

Usage

The following command sets the history configuration to the configuration with the name all_hist:

MYDB.SCH1(USER)=> SET HISTORY CONFIGURATION all_hist;